New Airtable user here! not quite sure If I am out of my element, but I am looking to streamline a work operation to where our intake team receives a vehicle, and records are created for them to validate all of the parts from the vehicle, efficiently as possible
- I need a user to login to a "form" with 6 steps:
- Drop down- 6 options
- number
- text
- text
- text
- based on the dropdown option, this creates records in a new table based on records in an existing "template table" (6 tables for each option) and concatenates the input number with a defined field from the existing records. also auto populate fields in the new table with the number and 3 text fields
- This notifies user 2
- user 2 logs in to access only the new table, that is displayed as a form view for each record- they need to validate vehicle parts
- Ideally, they can upload a picture as one of the fields as well
- When they finish, they click a submit button that exports the table as an .xlsx file and notifies user 1
And that's it! Any help would be greatly appreciated!