What triggers the action you described below? Is it manual? Unfortunately, with my users workflow, I can’t get them to click a Button to get sent a reminder email.
“use a set column action to set that rowID to the “basic rowID” column in that same table.“
Late in the day here…I’m just not understanding this.
In Airtable, I have a unique “Add-People-Sessions LookupCode” that is (i) the SessionNumber and (ii) the user’s email address. This unique value is known for every Add-People-Sessions row before it’s created, unlike the Glide RowID. Or am I wrong and the Glide RowID is predictable so I know what it will be?
This Action is triggered in my Sessions-Table, so I can only Create a new row in my Add-People-Sessions-Table (not edit an existing one), so i have to “Set column values” in that same step.
What new step am I creating in my Action to achieve what you describe?
Do you have an image/video of what you’re describing? I can’t picture it at the moment…
I hope this is clearer. Taking all other irrelevant actions in your flow out of the way, I’m just talking about how to set the rowID to a basic column.
I’ve followed all these steps, but when I create that basic column in Add-People-Sessions, it does not write to/sync with the basic column in the last step
My issue is trying to Set Column Value in the Action using the info from that Single Value column. I don’t know how it’s possible to wait for 5-6 seconds in the middle of an Action.
I’m basically advising you to add the row first, then wait 5-6 seconds so that you can retrieve it’s automatically generated ID, and use a set column action to set that ID back to your basic text column so that it can be synced to Airtable.
OK, here’s what I’ve done (screencaps below). It’s still not populating the Row ID in my basic [Add-People-Session] column, even though I can successfully Query the Row ID in my Sessions-Table (per your instructions). There must be something wrong with the way I’m trying to execute the Set Column Values step after the delay…?
Just for convenience/simplicity; it’s aggregating six different Single Value column types. It doesn’t have to be an if/then column. Here it is with the Single Value, below.
Unfortunately, I don’t think I can solve this by creating links for the Add-People-Sessions table. I think I’ll have to create one link for the Sessions table instead. Not my first choice because it adds an extra click for the user to then select the Add-People-Sessions table that they want, but it’s better than nothing. Thanks so much for your help!