I am creating a car maintenance history sharing app.
In this app, the maintenance shop owner can register the maintenance menu on the app.
Car owners can find the menu and place an order with the garage on the app.
The maintenance shop that receives the order can create an estimate based on the maintenance history of the vehicle registered in the app and additional explanations from the owner.
When creating an estimate, you select what to do this time from the work details and parts list linked to the initially registered menu, or add a new one.
The UX on the app will continue after this, such as sharing work progress, making payments, and creating history, but the current issue is the realization of a UX that allows repair shops to create estimates from templates.
The data structure of this app takes the form of coexisting data with different statuses such as menus, orders, and history in one data table called “records”.
And in this record table, the relation between work details and parts table is established.
When the car owner orders from a screen displaying a record with a status of “Menu”, a record with a status of “Order” is created by copying the original record’s values.
When creating the “Order” record, we copy the Row ID of the original record, so we can refer to the work detail list and parts list associated with the original record.
The problem comes after this.
In car maintenance, it is not enough to do work and parts replacement according to the template menu.
We customize the work details and parts list according to the condition of the vehicle.
However, 80% work according to the template menu.
Therefore, from the work details and parts list of the copy source “menu”, I would like to copy only the necessary amount for this order in a form linked to the “order” record.
I really wanted to copy the relevant work details and parts list when the order action was executed, but after looking around the official guide and this community, it seems that it is not possible yet.
I tried to do this by adding a row in the list component’s collection item action, but I couldn’t set the row id of the “order” record I wanted to associate.
After trying various things, it seems that the add row action cannot bring in values from other tables.
Therefore, we are looking for ideas that successfully pull Row IDs and ideas that change the UX itself.