I've tried to create such an automation:
When one updates the value of field 1,
if this value matches that of field 2,
input a static value into field 3!
How do you let people do this?
Because AirTable doesn't let us set this condition, I've done this:
a. added a hidden field with the formula:
IF({field 1}={field 2}, "1")
One can input any value after the condition / first comma.
One can add an "else" output after a second comma.
b. set the condition: If this field 4 has the value 1
I've added step a because some service providers make service users do costly work.
Service providers are supposed to do the main work. This is a part of the main work.
