Creating a new record using Automation

I have a table in two apps, App X and App Z, that when a record is submitted, I need to use the Automations to make a new record in the other app copying the information over. The issue is that the consumer data field, which looks at the consumer's name and creates a relationship to another table called ticket, references only the same app. So if I make a record in App X, then the relationship between the table, and the ticket table will be all within App X. The person will have a ticket in App Z as well, but there is a very low chance of them both having the same record ID. 

Is there a way for App X to know which ticket to send to App Z when doing the Automation of creating a new table in the other app. This process should be repeatable in both directions.

Also, we only want to use native QuickBase, and avoid the use of code pages.