Hi!
I have a form that’s used to inspect buildings. If the user discovers something that needs a correction, we want them to be able to instantly add a row to a “Task”-table with additional details. This table is a child-table to the “Inspection” table.
The inspection form is splitted between several pages. Is it possible to somehow show the child-table several places, after each question/page? If not, do you have any other suggestions how to accomplish this?
-Oliver
Hi,
You can create an action “add task” that opens the child table form.
The action will be visible on the inspection detail view.
Thank you very much for the answer!
But is it by any chance possible to add it in the form-view? For as for now, I am only able to add the child-table part once in the form. Because the users will need to access it while filling out the form, before saving it.
Any suggestions?
I have this functioanlity in one of my apps but my method is questionable.
There might a more practical way to do it.
It’s a checksheet app so basically the same thing.
The user will start a checksheet.
For every check I have a page.
If a defect is found, the user can add a photo or a comment. (actually multiple)
My way:
Checksheet spreadsaheet
Comments spreadsheet
Photos spreadsheet
Loaded the checksheet spreadsheet into my app .
Loaded Comments spreadsheet into my app once for every check the needs to be done.
(10 checks, then 10 times → named as Check1 comments, Check2 comments,…,Check10 commenys)
Same thing for Checksheet Photos.
The comments and photos tables have a column ref to Checksheet table
Checked the “Is a part of?” - this will create a button in your form. Won’t work without it!!!
Next, created a slice on the Checksheet table so I can rearrange the columns.
This is the result
All the comments entries will be stored in the same place, the comments spreadsheet and the same for photos, in the photos spreadsheet.
Hope it helps but, again, this is not the best way, it’s just the only one I know.
Thank you! That was a clever way to do it.
I will continue to investigate this, it would be really nice to have this functionality without having to import the spreadsheet multiple times, but it was a smart way to do it! Thanks!
