This is harder! I appreciate the opportunity to learn something new.
I think, based on your reply, it sounds like you’ve already set up references between the tables. If you haven’t, though, you might want to start with the References Between Tables guide.
You’re going to need two actions and a workflow.
The first action is one that sets a car’s status to “recon” and should look something like this:
You may also want to change the options under “Appearance,” maybe set it to “Do not display” if you don’t want this action to be visible to users.
The second action is harder. For this one, you want an action on the tasks table, that looks up that task’s car record and runs your “set a car’s status to recon” action on it. That would look something like this:
The formula under “Referenced Rows” selects this task’s car record. The exact formula will depend on what your column names are. So for example:
[name] = [_THISROW].[car]
This selects the first argument,
Cars[name], which is the key column of the Cars table. Instead of name you might have something like “car id”, “vin”, etc.
The second argument is the condition which must be met on the Cars table for the lookup to match. So in this case, it’s saying, give me the record where the column for
name is the same as the
car column on the
You can see the key column and the ref column I’m using in my schema below:
Finally, you need a workflow to trigger the second action on any added task record. It should look something like this:
and hey, look, it works!