We use airtable to keep track of our clients and their projects. The clients place an order, and all the information appears in our airtable. We would love to have a way for our employees to update specific jobs without having access to the airtable. Ideally, if they could fill out a form and put a specific job # in that it would match the existing job and change the status of the job and assign their name to the job, that would be ideal.
The goal is instead of giving them entire access to the airtable, they are only able to view and make specific requests. We want them to only have the ability to assign themselves and change the status of a job.