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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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?
Photo of QewBee

QewBee

  • 318 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
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.
Photo of QewBee

QewBee

  • 318 Points 250 badge 2x thumb
Thank you.
Photo of QewBee

QewBee

  • 318 Points 250 badge 2x thumb

Is it possible to use Webhooks or Actions to accomplish this?
Surat has the cirrrect answer
Photo of QewBee

QewBee

  • 318 Points 250 badge 2x thumb
Thanks.
Photo of Danie Grabe

Danie Grabe

  • 172 Points 100 badge 2x thumb
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.
Photo of QewBee

QewBee

  • 318 Points 250 badge 2x thumb
Thank you