In automations, I often want to update fields (or input a value to a newly created record) for linked-record fields
For example, In the screenshot below I want to, when a record is updated in the EMPLOYEES table, create a record in the SUBMISSIONS table
In the SUBMISSIONS table there is a linked record field that goes back to the QUIZZES table. I want to input a value here, and the only way to do so right now is to:
Create a record_id field on the quiz table
Manually copy that new id
Manually paste it into the automation field
Is this the only way to do this? Am I missing something?
