How to setup a form for multiple entries that update the same row

Options

Hello,

We're trying to create a form that you would use throughout the day checking boxes as certain daily tasks get completed.

Goal is, to have 1 row per day.

In that row you have an X amount of columns, each represents a task. Those tasks - for now - I have as separate form-fields (checkbox) in the form.

Example:

Entry date 4/18/2023

[] 8:00-8:45 - "Task 1"

[] 8:45-9:30 - "Task 2"

[] 9:30-10:15 - "Task 3"

...


Once you complete "Task 1", you check the box and submit. When "Task 2" is completed, you again would check that box in the form and submit, and so on... Each time one of the boxes per completed task gets checked, the SAME ROW in the sheets gets updated with that new entry.

How would I do that? Is that possible? What steps would I need to do to make that happen?

As of now, each time the form is submitted, the entries "arrive" in the sheet in a new row.


Thank you very much in advance for any help!!

Answers