Maintenance table:
Equipment 1: Name task 1 + detail
Equipment 1 : Name task 2 + detail
Equipment 2 : Name task 1 + detail
Etc
User maintenance table:
IdUser, task name 1 + detail + status
IdUser, task name 3 + detail + status
Here is the context:
The user comes to have personalized advice on the maintenance of different elements that he will have informed.
After registering, the user can personalize the different equipment he has.
I want to be able to propose to the user a list of actions (maintenance task) to perform. Once the action has been completed, it should no longer appear in the list of actions to be performed.
Each time I update or add equipment to the user table, I want an entry to be created in the user maintenance table.
Your workflow looks doable, but it will require quite a few automations on the airtable side.
Will the visitor ‘equipment’ be a list of predefined options by admin, or user can add new items?
I need to understand how much interaction will the end user have with the app, or the user will be a passive visitor simply checking their maintenance status of his equipment?