Workflow - add row to table and then get it's row ID

Ask for Help
1

Hi, new to glide and learning with ChatGPT, making good progress, but struggling with workflows that create a new row in a different table. In a nutshell, i have a form on a ‘windows’ page, that i want to create a new entry in the ‘quote products’ table. i can add a step to add the row in the quote products table, and that works fine, but I then want to go straight to that details page for the newly created row.

What am I missing? ChatGPT keeps on telling me to use Result of Step 1 → Row ID but I never see this, so assume that this was removed in an update that CGPT hasn’t worked out yet!

What;s the work around? I’ve wasted hours on it and must be missing something really simple.

Edit: seen a few posts on here about this, with some saying to use the write Row ID field to option at the bottom of the list of fields, but on the table I’m working with, I don’t have this option - i do on others?

2nd edit & Fix - the workaround seems to be to save the row ID in a field on the user table, seems to work well, but that requires the write row ID option to show - which it wasn’t on some. Turns out, this was when the Row ID column had been created in Google Sheets, not Glide. The fix was to delete the Row ID table in sheets, and then re-create it in glide.

1 Like
2

Are you using a native form or a custom form? Based on your wording, it looks like a custom form.

In a native form, you can just have a show details screen > this row for the on-submit action.

For a custom form, make sure you have a user-specific text column to write to. This must be a column that either sits in the table where you’re hosting the form, or the User Profiles table.

Create a relation using that column to your destination table, and use a show details screen > relation to open the details page for the newly created row.

2 Likes