Hi, I am new to glide and have a question on how to approach a specific issue.
I am using the edit screen and I have 3 choice components that are required fields. The 3 choice components are all referencing the same table and the table contains numbers that range from 5-100 (the numbers represent percentages). I would like for the user to select their percentage for each choice component. However, I am not sure how to ensure that their 3 different values from the choice components total to 100 (100%) before submission.
Is there a way to ensure that the three different values chosen in the choice components total to 100 before submission?
You would need to capture each value in a User Specific column, and then use a Math column to add them up. Then you could put a condition on your Submit button that prevents submission unless the total is 100.
Thank you for the quick reply! I am under the impression that forms create new rows, I was hoping to edit an existing row. Can forms edit an existing row?
Sorry, I missed that you were using an Edit Screen.
However, the answer remains the same, you will still need to use a custom form. The only difference is that your Submit button will do set column values rather than add row.
Have a look at the topic that I linked to, and then come back with questions if anything isn’t clear.
Thank you for the extra information! I think I found a work around by creating a custom action on submit from the edit screen. If the 3 values from the choice components do not sum to 100, I clear out the values and pull up the edit screen again with an error message. This process will continue until the values sum to 100 or the user presses cancel!
Pretty amazing how creative you can get with custom actions!
