Create rows in different tables, but grab the rowID of first one and put it into the second row

[apaschea]

Hi guys,
When customers push complete order, I would like:
A row to be create in table XXX

A row to be created in table YYY
But in this row, grab the ROWID of the row just created in table XXX and add it into this second row to connect the two.

[Jeff_Hager]

I think what would work better would be to generate a Unique ID when you are navigating to the screen that contains your button. Then when you click on your button you can write that unique ID to your two tables.

[apaschea]

is there a column type that creates a unique ID (like a RowID)? All I see is “random number” but I don’t think it is unique.

[Jeff_Hager]

Unique identifier

[Jeff_Hager]

It all depends on how you get to the screen that contains your button, but in many cases, you can create a custom action that first uses a set column action to set the unique id, followed by a show detail screen or whichever method you are using to get to the screen with the button.

[Jeff_Hager]

Something like this.

Create a new row and inmediately open in a new windows

The only way to do it would be to do this set up / custom action: Set up: User specific “Temp ID” column Single relation “Relation to ID” column from the Temp ID column to a ID column in the table where the new row is added Custom Action on the Button: Set column action > unique value to a user specific column Add row action that adds the Temp ID to the ID column along with any other data you want to prepopulate Show Detail Screen > Relation to ID

[apaschea]

that worked! i knew i saw it somewhere before.

My custom form has a “review order” button so i am able to write the unique value at that time.