Question
In a Grid Edit Report, make a field mandatory if another field is checked
+4I 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?
This topic has been closed for replies.
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.