Solved: Add item to child-table several places in form - Page 2

OliverDahl · 06-10-2020 01:07 AM

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

AlexM

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.

View solution in original post