I'm evaluating if I can user Airtable for a Job Requisition Approval process.
I don't get how I can do 4. Any ideas?
You can enter in the record data using the "Airtable Record URL" placeholder in your email message automation. This will be a direct link to the record that was used.
In this scenario, they will need to be a User in your Airtable base and have Editor or Creator permissions. Then you can have a Status field in your table where they can Approve/Not Approve. You won't be able to select the Status from the email itself.
Unfortunately, that is not possible with Airtable forms. You can't update records with a native Airtable form. And If the person you're emailing is an Editor User, they can edit data in any field.
You can do this with 3rd party tools, like our On2Air Forms app, a form and dashboard builder for Airtable.