Discussions

Expand all | Collapse all

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

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

    Posted 02-25-2019 21:47
    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?


  • 2.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Bronze
    Contributor
    Posted 02-25-2019 21:51
    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.


  • 3.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-25-2019 21:53
    Thank you.


  • 4.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-25-2019 22:06

    Is it possible to use Webhooks or Actions to accomplish this?


  • 5.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-25-2019 22:55
    Surat has the cirrrect answer


  • 6.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-26-2019 13:34
    Thanks.


  • 7.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-25-2019 22:35
    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.


  • 8.  RE: In a Grid Edit Report, make a field mandatory if another field is checked

    Posted 02-26-2019 13:33
    Thank you