I'm building a custom form that starts with a checkbox field. Upon selecting an item, it shows a single-select dropdown listing numbers. Then I have a calculation that says, "Sum the value of all those number dropdowns." However, if you deselect an item in the checkbox, it doesn't clear the dropdown value and the calculation is therefore inaccurate. I'm thinking there are two possible workarounds, but I'm struggling to take my thinking further:
I'd prefer option 1, but I suspect option 2 is more feasible. What do you think?
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
option 2 all the way, as well as figuring out other risks of having a hidden, selected dropdown field.
Views
Replies
Total Likes
Thank you for validating. Now I have to figure out the if statements, which make my head spin.
Views
Replies
Total Likes
have you tried chatGPT? If you give it a sample of a simple IF statement, I bet you can get it to help you on something more difficult.
Views
Replies
Total Likes