Hello Gliders
I have a work order management app where managers assign work orders to field workers. Everything is working well so far. Now I want to integrate a form into specific work orders so that users can complete the existing paper form directly within the app.
I’m unsure about the correct backend logic for this setup and would appreciate guidance.
What would be the best approach? Should I create separate tables for this purpose — for example:
-
One table for assigning and filling forms linked to work orders
-
Another table to store records of all submitted forms across different work orders
Or is there a better structure to handle this use case efficiently?
A sample of the form is attached for reference.
Thank you in advance for your help
