Solved: How to change data on a different table - Page 2

BobG · 06-11-2020 07:50 AM

I have 2 tables a Job table and a Log table. When an employee checks into a Job initially a row is added to the Log table. Multiple employees can check into the same job. When an employee checks out (from the Job table) I need the related Log table row to be updated to “Checked Out”.

I have a column on the Log table that references the Job table which created a “Related Log” list.

I have a “Check Out” action button for the Job table that changes the Job table status and an action on the Job table to execute and action on a set of rows but can’t, after many hours of trying, figure out how to change the status on the related Log table. I don’t know if I’m using an incorrect reference the the action or if its a workflow issue. I read the support articles on workflows and references and still can’t make it work.

Steve

Ah, sorry, my bad. Remove ANY() from around SELECT():

SELECT(
  [Related Logs][key-column],
  AND(
    (USEREMAIL() = [Email]),
    ("Checked Out" <> [Status])
  )
)

View solution in original post