I am using the calculation column to do some calculations. The above image is from the spreadsheet:
type | name | label | calculation |
text | name | Name | |
decimal | input | Enter a number | |
decimal | double_input | Double of it | ${input}*2 |
select_one yes_no | yes_no | Yes or No | |
decimal | grade | input * yes_no(yes = 50, else = 0) | if(selected(${yes_no}, 'yes'), ${input} * 50, 0) |
decimal | double_grade | Double 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.