i have 3 inspection sheets each sheet consist of 40 raws so i create three sheets as child sheets and one sheet as a main sheet i need to transfer from main sheet to the child sheets , i created actions button to transfer to the sub sheets but if i want to edit any previous data in main sheet haw i connect the sheets to edit the old row in child sheet
or you have another suggestion to do this app
Each child sheet/table should have a column to specify which Main/Parent row they belong to. Add this parent sheet column to each child sheet, then in AppSheet regenerate each of the child tables. Once regenerated, go to each table, edit these new parent column, set it to a REF type column of the Main/Parent table and set the “Is part of” property to “On”.
Now, simply add the associated child list to the Main/Parent Form view. These child lists are created in the Main/Parent table automatically with the column editing you did above and start with “Related…”. By adding them to the Form view, an Inline table is shown in the view to allow you to ADD and EDIT the child rows.
I hope this helps!
This is ambiguous, misleading, and wrong. Try again.