Editing a report with conditional dropdowns

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
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 pick a "Parcel" and then a "Crop Zone".  My conditional dropdowns are working great.

The problem I am having is when the user goes to edit the record after they have created it.  For example, they will have a parcel called "South of Railroad".  The crop zone will be "Corn".  They realize they entered the parcel incorrectly and go to change "South of Railroad" to "North of Railroad".  When they do this, I need the crop zone field to clear out so they are forced to choose a new crop zone.  When it does not clear, the incorrect crop zone will stay in the field box and will cause issues in other areas of the app.  

Another instance where this happens is when my users copy a record and edit the parcel name.  

I have used the form rules to clear out the crop zones whenever the parcel is cleared out, but do not know how to do it if the parcel name is just modified.

Thanks for your help!
Photo of Joshua Nurrenbern

Joshua Nurrenbern

  • 150 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
(Edited)