I notice that if I have a linked form field on my form, and try to add a calculation field, the linked form variables are listed as inputs to the calculation, but selecting them forces a COUNT(variable) to be added.
How can I access, for example, the first value of a given variable on the linked form?
The COUNT(variable) seems redundant since it should be the same value for each variable in the linked form, right?
Thank you.
Hi JBB,
No, the COUNT method is not redundant because it excludes empty values. So you could have different results for different fields. If you insert a Number field, then you get other options such as TOTAL, MIN, MAX, and AVG.
I’m working on Tap Forms 5.3 which will have a new Script field which lets you write JavaScript code to fetch values from Link to Form fields — along with many other things. So you will be able to do what you want, but not until 5.3.
Thanks!
Brendan