Add a form within a form

Ask for Help
1

Hi.
I am trying to add a form within a form meaning:

  1. i fill out a form with different questions and once finished its submitted. this will add the information in row 3.
  2. i then open this form to read the info of row 3, but then i want to add another piece of information as ‘finished time’ where this information needs to appear in row 3 (another column on same google sheet) showing in this case the time when the subject has finished.
    thank you for your help.
2

Forms add new rows, so you don’t need a form for this. You just need to enable editing on the existing row.

2 Likes
3

let me try that solution. could be the solution. thank you

4

Just curious, does it always have to be row 3 or is it just an example you made here?

5

Not gonna work. because it does add to a new row, and i need to add to an already existing row that has been submitted previously. (i use google sheet)

image
image2716×138 25.8 KB

Basically, first you submit the entry data (name, time, date) then submit → fills the row (2)
then i will open that row again to see the information on it, but this time i also will want to add the exit data (time and date of exit, and any observation). here an image:

image
image718×1266 54.9 KB

So the red arrows indicate what i actually need to add/update on the already existing row in my sheet. as this info comes later, i have to add it later on.

PS edit is not the best choice as i dont want the user to be able to modify previous inputs. it would defeat the purpose of the job.

6

Then you can just don’t show those users the entries to edit the previous inputs?

7

yep that works! simply solution! thank you as always. u’r the king!

1 Like