Below is a list of common scenarios that involve the use of a formula to achieve.
Scenario:I I have a multiple choice Choices field with options 'Large', 'X-Large', 'Jumbo', 'Small.
| Expand | ||
|---|---|---|
| ||
Use the selected() function to get a true/false result for each option in your Choices field. e.g. if you want to control visibility of other fields in your Form based on if the Apple option is selected: selected({{mychoicesfield}}, 'Apple') |
Scenario:I I have a set of Choices fields with data names of q1, q2, q3, q4. All have fixed answer options - e.g. 'Y', 'N', 'N/A'.
| Expand | ||
|---|---|---|
| ||
Use the concat() function to create the desired result, much like you would with the Microsoft Excel CONCATENATE function. You can mix dynamic answers with static bits of text as needed. concat('Question 1 Answer: ', {{q1}}, '; Question 2 Answer: ', {{q2}}, '; Question 3 Was: ', {{q3}}) |
...