Hello, I have a table with my inventory, which is grouped by the status โโin-transitโโ โโin reconโโ โโretail readyโโ.
When in recon, the mechanic, detailing and bodywork need to be completed. I set it up with a true/false for each, so that when the task is completed, I can toggle to done (true).
Is it possible to create a workflow that when all three are true, it automatically changes the status to โโretail readyโโ?
To accomplish this, you can add an action that sets status to โretail readyโ and a workflow that triggers the action when all three of those values are set to true.
The action could look something like this:
The workflow could look something like this:
In that workflow, under โIf this is trueโฆโ you can set the condition to the following expression, which will only be met when all three values are set to true:
and([mechanic], [detailing], [body work])
You are a genius !!
Ok something a little harder.
I created another data table for tasks. And when a task is created for that specific car, I want to update the status from In stock to in recon. Is this possible ?
Thank you
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:
select(
Cars[name],
[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 Cars
called name
is the same as the car
column on the Tasks
table.
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!
Thank you so much for your reply, this is perfect !!!
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |