I’m currently working on creating an “Approval/Rejection” workflow for a project using Airtable forms.
- The customer submits a form.
- I review the form, if everything is good, I approve it (Change the status to “Approved”). ALL GOOD
2.1 submitter will received an email that form has been approved.
- HOWEVER, if the form is not correctly submitted, I will change the status to “Rejected”.
3.1 submitter will receive a rejection email with rejection reason.
This is where I need help:
I have added a field called = “Rejection reason”, which will be emailed to the submitter (via zapier integration) as soon as the status changes to “Rejected”. However, in order for the email to be sent out WITH the rejection reason, I need the rejection reason to be filled out BEFORE the status change.
I was hoping to find out if there was a way to only allow a status change to “rejected” if the “rejection reason” has been filled out.
Any help would be greatly appreciated.