Nice to meet you!
I want to compare 2 fields and fill another field with checkbox.
For example, I have Company_tags and Current_firm fields in A table.
Company_tags fields contain several companies name, and Current_firm contains 1 company name only or not contains.
So what I want is I want some automatic way of seeing if the Current_firm is included in the Company_tags.
If not, I want to check Confirmed field.
I think this can be done in Airtable automation script or using other script.
Thank you for your reply and help.
Yes, your explanations are very clear to me and helped a lot.
It works professionally. :grinning_face_with_big_eyes: You’re super!
I added LOWER() function to the formula for ignoring Case Sensitive and exact match.
“ :white_check_mark: Found”,
“ :no_entry: Not Found”
Sorry, I have one more question.
How to update Confirmed field at once? It looks like some fields are not updated properly even though Not Found. Of course, I added trigger in automation workflow, but for now, I want to update Confirmed field with Checked or Unchecked.
And I don’t want to check Confirmed field when Current_firm is a blank.
I cleaned the automation up to look for all changes to the Companies, Current Firm, and Result field.
This will allow the automation to keep an eye for every possible scenario that might influence what you want to happen.
I changed the conditions on the first action group to make sure that the Current Firm field is not empty.
Then, just setup an action group as your “Otherwise”, and tell it to set the checkbox to false.
I tested it a few times and it seems to be running smoothly.
Again, feel free to copy the base I shared into your workspace and peek at how it’s setup if you’re having trouble with it.