Editing a report with conditional dropdowns
In my form, I have a 3 conditional dropdowns in my "Loads" table. My users will first pick a "Grower", then based off of the "Grower" selection, the "Farms" will be filtered. Then, the user will pic...
Forum Discussion
Not tested, but how about this for an idea
Make two similar form rules that say when the CDD one is not equal to blank, make read only CDD one. . Then similarly for CDD 2.
But then the issue is what does it do when they decide they need to edit CDD 1 or 2.
The suggestion is to have a checkbox field called reset.
Make a form rule that says when reset is checked,
change CDD 1 to blank,
change CDD 2 to blank
change CDD 3 to blank
change reset to blank.
In other words in order to make a correction they will have to start over from the beginning.
Make two similar form rules that say when the CDD one is not equal to blank, make read only CDD one. . Then similarly for CDD 2.
But then the issue is what does it do when they decide they need to edit CDD 1 or 2.
The suggestion is to have a checkbox field called reset.
Make a form rule that says when reset is checked,
change CDD 1 to blank,
change CDD 2 to blank
change CDD 3 to blank
change reset to blank.
In other words in order to make a correction they will have to start over from the beginning.