Do not require user to click refresh button when field is hidden

460
5
Jump to solution
a month ago
JoseVidal
New Contributor III

When using the Inbox feature and the 'calculation' column to calculate values, sometimes those calculated values are not now shown. Instead the user sees a recycling icon. When the user presses it then the value gets calculated.

This works OK, until that field is 'hidden' and its value is used by yet another 'calculation'. In these cases the final value cannot be calculated because there is no recycle button to press.

 

2021-05-14_15-01-34.png

0 Kudos
1 Solution

Accepted Solutions
abureaux
New Contributor III

Thanks for the reply.

The thing that jumps out to me is the use of text fields for calculations. Have you considered using a combination of [type] note and calculate? See below:

typenamelabelcalculation
textnameName 
decimalinputEnter a number 
calculatedouble_input ${input}*2
note Double of it: ${double_input} 
calculateyes_no_calc if(selected(${yes_no},'yes'), ${input} * 50, 0)
select_one yes_noyes_noYes or No 
notegrade${yes_no_calc} 
calculatedouble_grade ${yes_no_calc}*2
note Double of above = ${double_grade} 

View solution in original post

5 Replies
abureaux
New Contributor III

I am likely not understanding what you are doing. Looks like you are using text fields, so I am not sure where your output is supposed to be. And sounds like you are using hidden fields for calculates?

Why not use a [type] calculate field? They are hidden by default. May help if you share your example doc.

0 Kudos
JoseVidal
New Contributor III

I am using the calculation column to do some calculations. The above image is from the spreadsheet:

typenamelabelcalculation
textnameName 
decimalinputEnter a number 
decimaldouble_inputDouble of it${input}*2
select_one yes_noyes_noYes or No 
decimalgradeinput * yes_no(yes = 50, else = 0)if(selected(${yes_no}, 'yes'), ${input} * 50, 0)
decimaldouble_gradeDouble of above${grade}*2

The process is complicated:

To reproduce the problem you have to connect both TCSubmitter and TCReviewer to the TC Service. Turn on the Inbox for the TCReviewer. Then submit a TCSubmitter form with the number field empty. Then go to the Inbox of TCReviewer to see the submitted form.

The TCReviewer will show the "reload" icon above on that one field (see image above).

But, if I make that field hidden then the final field (double of the above) does not get the reload icon and does not get a value either.

0 Kudos
abureaux
New Contributor III

Thanks for the reply.

The thing that jumps out to me is the use of text fields for calculations. Have you considered using a combination of [type] note and calculate? See below:

typenamelabelcalculation
textnameName 
decimalinputEnter a number 
calculatedouble_input ${input}*2
note Double of it: ${double_input} 
calculateyes_no_calc if(selected(${yes_no},'yes'), ${input} * 50, 0)
select_one yes_noyes_noYes or No 
notegrade${yes_no_calc} 
calculatedouble_grade ${yes_no_calc}*2
note Double of above = ${double_grade} 

View solution in original post

JoseVidal
New Contributor III

You might say "just don't make the 'grade' field a 'hidden' field and the user will press the reload button".

The thing is, this is just a reproduction of the real spreadsheet, which has hundreds of values and dozens of intermediary values. 'grade' is an example of an intermediary value. We would like it to be hidden, but its value automatically calculated so that other calculations which depend on the value of 'grade' will also get calculated.

0 Kudos
JoseVidal
New Contributor III

Yes, thanks!

Making the intermediary values  of type 'calculate' and the final values of type 'note' makes it work.

0 Kudos