Perform automation action on trigger record

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • Answered

I've become a big fan of Automations following the NYC Community Summit last week, but having trouble with one component. 

Case: User opens Table A Record 1 and changes value in Field  'Trigger Status' to 'Initiate'; this change in record triggers 4 actions in the the automation. As a 5th action, I'd like to change the 'Trigger Status' value in Table A Record 1 to 'Complete'. This would let non-admin users know that the automation was successful. 

Is there a way to perform an automation action on the trigger record?
Photo of AO

AO

  • 242 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Indeed there is.
The last step in the Automations can edit records and select the parent table itself.  A filter should be available that the Trigger Record ID# field  = the [Record ID#],

ie only edit the trigger record.
Photo of AO

AO

  • 242 Points 100 badge 2x thumb
That makes sense- thanks!! Now I'm encountering something odd- the field dropdown list for 'the value in the field...' is only showing a few options, and Record ID# is not in the dropdown. Any thoughts? Screenshot attached
Photo of AO

AO

  • 242 Points 100 badge 2x thumb
Issue resolved- criteria should be set to modify records where Record ID# is equal to the value Trigger: [table] Record ID# 

In my case, trigger an action on a record in the Web Form Submissions table when that same record is modified. 
(Edited)