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)
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.