Get to 'Edit' screen after 'add row' without user interaction?

Ask for Help
1

I feel like I don’t always do a great job explaining myself sometimes, so bear with me - there’s two version, mine and Claude’s. I’d genuinely appreciate feedback on which is better/why, alongside (or not!) some help with the actual problem!!

Heck - maybe we’ll all learn something :stuck_out_tongue_winking_eye:

My Version:

I’m creating something akin to an order form that only allows specific available SKUs. It’s not a shopping cart, but it’s close enough to use it as an idea of what I’m aiming for if you assume that you can have multiple shopping carts and you select the shopping cart you want to add the item to…

TLDR; User clicks a collection entry (a row in a table component), that item’s details gets added to a table, but I need to get the user to add more info to that line without further navigation and I can’t figure out how, as the table it’s writing to is not the table contains the collection they’re clicking.

Bit more info:
DB 1 - Groups
DB 2 - Line Items associated with Groups
DB 3 (contains Imported info using an importrange function) - Options available for user to select from that will be added to table 2 with more details
Table 1 - Displays all Group names
Table 2 - Displays line items from DB 2, filtered to display only those for a selected Group
Table 3 - A filtered selection based on user and other metrics, that displays specific information not available when using ‘choice’.

I’m using DB as shorthand for Database instead of ‘table’ because I don’t want to confuse the table component with the table data source… so ‘tables’ above are all compnents.
Note - DB 3 is really meant to be a reference source, not an interactive editable table for this part of the system

UI
Page 1 contains Table 1 and Table 2
Clicking an ‘add to group’ button on Page 1 brings up an overlay/modal which displays Table 3. The user can then click a line on that item to add it to a group (and that’s where my problems are).

Rough Flow:

  1. User creates a group in DB 1 via a form, or can select from an existing group by clicking its line in table 1.
  2. Clicking a line in table 1 saves a cookie. The cookie is used as 1) data filter for viewing the contents of a group in table 2, and 2) is used to set a column val for the group name when lines are added to DB 2.
  3. The products displayed in table 3 are available to be added as a line item in DB 2 which will be associated by a relationship to a group in DB 1. The overlay with table 3 has relevant and useful product info from DB 3 so that the user can make the correct selection. When the user clicks a row in table 3 an action starts that creates a new row in table 2 using the info from the line in table 3 that user clicked on, and sets the column value of the ‘Group’ that it’s in using the Cookie.

I need add information to the line that was just created in DB 2 - order amounts, purchase order numbers etc, you get the idea. There isn’t a way that I can edit that row in DB 2 without further interaction by the user that I can tell?

For example, if I create an edit screen using the action started at point 3, I can only edit the info in DB 3 (which is verboten!). If I use the action to navigate to a screen that uses DB 2 as its info source then that doesn’t work (bit of a hail-mary, but thought I’d try!).

I’m pretty sure that if I had a relationship from DB 3 to DB 2 then I could do something with that, but I can’t - like I really can’t be doing that.

I don’t even think I can use another helper table, because the data source that I’m accessing is still from DB 3. So, can anyone else think of something I’m missing? I’ve tried creating a relationship between DB 2 and DB 3 and using the relationship as the data source, thinking that it was indirectly coming from DB 2 as a source, then I might have a bit more luck. Unfortunately it still sees DB 3 as the data source in the action.

Ultimately I want the user to be able to ‘select’ from a collection component, and then be able to add additional details, all in one fell-swoop. I can’t figure this out, and am just banging my head against this particular brick wall!

Claude’s Version:

Need help: Adding user input after selecting item from a collection in Glide

Problem
I’m creating an order form-like system in Glide where users can select items from a collection and add them to a group, but I’m struggling to allow users to input additional information for the selected item without further navigation.

Setup

  • Database 1 (DB1): Groups
  • Database 2 (DB2): Line items associated with groups
  • Database 3 (DB3): Imported reference data (available options for users to select)

UI Components:

  • Table 1: Displays all group names (from DB1)
  • Table 2: Displays line items from DB2, filtered by selected group
  • Table 3: Displays filtered selection from DB3 based on user and other metrics

Current Workflow

  1. User creates or selects a group from Table 1
  2. Clicking a group saves a cookie for filtering and setting group name
  3. User opens an overlay/modal with Table 3
  4. User clicks a row in Table 3 to add it as a line item in DB2

Issue
I need to allow the user to add more information (e.g., order amounts, PO numbers) to the newly created line in DB2 immediately after selection, without further navigation or editing DB3.

Specific Questions

  1. Is there a way in Glide to edit the newly created row in DB2 within the same action that creates it?
  2. Can I create an intermediate step or form in Glide to capture additional information before writing to DB2?
  3. Are there any Glide-specific features or workarounds I might be overlooking?

Any suggestions or alternative approaches would be greatly appreciated!