Select one and return a value on a box

352
3
08-05-2022 07:53 AM
Luwerli
New Contributor II

Hi! 

The context: I have a question, of the select one type, that shows a box to put numbers on it if I have answered 'yes'. If I have answered the question as 'no', the box doesn't show. So the line of the column of numbers is empty if I have answered 'no' on the previous question.

My problem is that I need the column of numbers to be filled with 0 if the previous question was answered 'no'.

survey:

Luwerli_2-1659710789335.png

Luwerli_4-1659710876933.png

the table:

Luwerli_5-1659711027010.png

 

 

 

 

 

Tags (1)
0 Kudos
3 Replies
Katie_Clark
MVP Regular Contributor

Would it work to have the number of columns question set to have a default value of 0?

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
0 Kudos
Luwerli
New Contributor II

Hi Katherine!

So I've tried this before and it didn't work. When I press the button 'no', the box that I should put the numbers doesn't show. It only shows up when I press the button 'yes'. That's why I think it's something more complicated than that.

but thank you anyway! I'll keep trying here

0 Kudos
DougBrowning
MVP Esteemed Contributor

Use the esri visible column vs relevant.  Relevant always stores as blank or null if not used.  Then as stated set the default to 0 and it should work.

Hope that helps