Forum Discussion

UmaHarithsa's avatar
UmaHarithsa
Qrew Cadet
6 years ago

In a Grid Edit Report, make a field mandatory if another field is checked

I have a Grid Edit Report on a Workstation table. I would like to duplicate the form functionality, where once the Marked for Deletion checkbox is checked, make the Deletion Reason field mandatory. Is it possible to program for this in a Grid Edit report?
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    Form rules do not work on grid edit reports. However, if you request Quick Base for the early release feature called "Data Validation" you may be able to validate that if the delete checkbox was selected and the reason is blank, you can throw an error message and prevent the data from being saved.
  • In my experience only dynamic form rules can work "on the fly", and they are not present during grid edit. Webhooks can only be triggered once you save - in which case it would be too late to change a field's properties.