What I would like to do is to prevent users from going forward when their total exceeds 100%.
I also, would like to show them, which field(s) is/are causing this field to go over the threshold of 100%.
The rules section is not conducive to this goal, as rules section is limited.
Triggered action section forces me to either email or text the users if their total exceeds 100%. I don't want to do this, since the whole point is for users to correct errors immediately.
Is there anyone out there who can impart me a script or two to help me?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
EmmePGN
Hello, I'm new to Caspio.
I have an Update Form with a calculated field called "Total_Percentage", that takes the values from other fields.
Code below:
Isnull([@field:PointFactor_Duties_PercentDuty1],0)+Isnull([@field:PointFactor_Duties_PercentDuty2],0)+Isnull([@field:PointFactor_Duties_PercentDuty3],0)+Isnull([@field:PointFactor_Duties_PercentDuty4],0)+Isnull([@field:PointFactor_Duties_PercentDuty5],0)+Isnull([@field:PointFactor_Duties_PercentDuty6],0)
What I would like to do is to prevent users from going forward when their total exceeds 100%.
I also, would like to show them, which field(s) is/are causing this field to go over the threshold of 100%.
The rules section is not conducive to this goal, as rules section is limited.
Triggered action section forces me to either email or text the users if their total exceeds 100%. I don't want to do this, since the whole point is for users to correct errors immediately.
Is there anyone out there who can impart me a script or two to help me?
SQL or javascript that would work with Caspio.
Thank you so much.
Emme
![trigger for when exceeding threshold value.png](//content.invisioncic.com/r269793/monthly_2020_01/970757509_triggerforwhenexceedingthresholdvalue.thumb.png.ff09088707d3a6841a448aa4aa9de90c.png)
Edited by EmmePGNto attach the picture
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.