In a sequence I would like to:
Add Row Table 1 (data)
Add Row Table 2 (data)
Add Row Table 3 (Table 1 (Row ID), Table 2 (Row ID))
Is this possible? I don’t know if any ‘Add Row function’ returns a result like ROW-ID and if that can be used in a Sequence.
Asking a different way:
Can you assign your own identifiers as the ROW ID for tables which have a GLIDE assigned ROW ID?
In this case I can create my working Table with 2 unique identifiers and then I would use those identifiers as ROW ID when calling “Add Row” for the two new objects.
Calling Action Sequence:
Action sequence creates working table (or uses existing)
Working table always initialized with 2 unique identifiers.
Add Object Action Sequence:
Add Row Table 1 (ROW ID = unique ID 1)
Add Row Table 2 (ROW ID = unique ID 2)
Add Row Table 3 (New ROW ID, unique ID 1, unique ID 2)
Thanks
I think you have the right idea with your second post to generate unique ID’s before you ever add any rows. But, I would not attempt to assign a unique ID to a Row ID column. Just create a new column to hold the unique ID in the other tables. It doesn’t specificly have to be an official Row ID column. You’ll still be able to establish your relations.
2 Likes
That works too and it didn’t even occur to me.
Time to add more columns to my tables!
Thanks again
1 Like