Set Value in a column based on changes in value in another column

AppSheet AppSheet Q&A
,
1

Hi,

I’m trying to set a behavior to update Company ID when Company Name is changed.
I have two tables:

  1. Company: lists Company ID and Company Name
  2. Drivers: lists driver names, Company Name they work for, and Company ID which references back to the Company table.

What I have done so far:

  1. I have set up an action
    a) Data: set the values of some column in this row
    b) Set these columns: Company ID (having trouble with the expression here to look up Company Name and return the Company ID from the Company table.

  2. I’ve set up a worklow
    a) Target Data: Driver table
    b) Update event: updates_only
    c) Condition: [_THISROW_BEFORE].[Company Name]<>[_THISROW_AFTER].[Company Name]
    d) Set task category to Chang Data and linked the Date Change Action name back to action in step one.