I have an action that uses a record from one table “Volunteer Check In” to create a record in another table “Groups”. I need to capture the key of the new record in Groups to pass to another action to use in creation of a record in “Individuals” so they are then related records. How do I pass that variable? I’ve seen a few tips on the Input command, but most seem to use the old UX interface and I don’t have access to some of those prompts.
Please try MAXROW( “Groups”, “_Rowumber”, [Email]=USEREMAIL()) to get the key of the latest row added in the “Groups” table.
The above suggestion assumes that it is a multi user app. So, the Groups table will have a column called something like [Email] that stores the email of the user who added the record. In the absence of [Email] column, it will be difficult to identify record belonging to a user and there could be mix up of records.
Also in place of “_Rownumber” you could use a date time stamp column filled in while adding the record if such a column is available in the Groups table.
The above suggestion also assumes that the action to create the record in the Individuals table immediately follows the action that creates the record in the Groups table.
3 Likes
Hi @NCBOM ,
May we know if you were able to get it working.
2 Likes
Thanks for your help. I was able to get it working using another method to determine the Group number by storing a UNIQUEID() in another field when the initial record was created. I then use that field as the key to the Group record that is created. Thanks again.
1 Like