Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 04:22 AM - edited ‎Mar 06, 2024 08:05 AM
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.
https://github.com/Julian-Dumitrascu
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 05:00 AM
You could try using a formula field to check if they match, and then trigger the automation off of that?
