User Input Submits to Existing Row (/Choose row)

Hi Folks,

I’m creating a marketplace, and when the user wants to gift something to someone, they input their recipients’ details through text/number submission - this data is submitted to the corresponding columns, but in an entirely new row, rather than on the relevant existing row.

Is there a workaround, or is this a known gap?

Thanks!

Are you using a form button to submit the recipients details? If so, the form button is designed to always write to a new row. If you want to edit an existing record, you need to enable editing and click on the pencil at the top right of the screen to edit the record. Or you need to add entry fields on the detail screen.

If you still prefer to use a form button, then you will need to also write some sort of unique identifying information from the item detail you are viewing. The form will need to write to it’s own separate sheet. In the data tab you will then need to create a relation column to link the item to the item in the form response sheet. Then create lookup columns that use the relation to pull back any data you need from the form sheet into the item sheet.

1 Like

@Jeff_Hager. Regarding the form button workaround, would this work if you have data from an inline list? Here’s my use case:

  1. I have a form button where a user can add a new task each day. Throughout the day, that same user can create multiple tasks (for each new task, the user would select the Add Task form button which as you pointed out, Glide will write to a new row). Right now, I display their tasks via inline list.
  2. Throughout the day, the user can go into each task and update the task status via choice option (In progress, complete, etc).
  3. At the end of the day, the user select a button which shows them the list of all the tasks they have submitted for that day along with a few text entry fields where they can comment and fill in some additional info based on how the day went. In this view, the user can also manually update the status of each task(s) if they didn’t do it earlier that day.

Step #3 is where I’m stuck on. I’m trying to figure out what is the best way to do this (via form, create another tab?)

Any feedback would be appreciated.

Best way to do what? Add comments? Change status? If you are displaying a list of tasks, then I would think you could open each task to display it’s details and make any changes via the edit button or entry fields.

Or are you talking about how to display the list? A link to screen button should suffice. If you wanted to could filter the view where date is within Today, so only today’s tasks show.

Thanks @Jeff_Hager. I’m trying to find the best way to display the list of tasks along with additional text entries in one display form/screen. I’d like to avoid having the user click on each task to update the status and then having to open up another form/text entry to enter the day’s feedback/summary that’s applicable to tall the tasks for that day. Would be great if they can do all their updates in one form vs having to go into each detail display and doing multiple submits.

Are you saying that you want a list with editable fields on the list items so you don’t have to go into the details of each list item? If so, your office are pretty limited and you can only do a checklist with a checkbox on each list item. Your best bet it to have the user tap on each list item to open it’s details, then add a choice commonest and text entry component so they can make changes without having to click on the edit pencil to go to the edit screen. Nothing to submit. They simply make their changes to each task and hit the back button to go back to the list.

1 Like

@Jeff_Hager. Thank you once again. Can always count on you in finding a solution and learning more about Glide. Much appreciated!

1 Like