this is probably the dumbest question.
i have a table with a list of organizations (Members table) and a single-select field that tells me whether they are members or not.
i have another table with a list of organizations that have sent someone to a training (All Orgs table).
i made an automation triggered by when a new organization is added to the All Orgs table to search for that org by name in the Members table and update a field in the All Orgs table to indicate if the org is a member.
when i test the automation, it finds zero records, even where i can see that the orgs are in both tables. the condition i am using is:
Where 'trim org name' contains 'trim org name'
'trim org name' are formula fields i made in both tables, just in case there are extra spaces in the org name fields that would make the find fail.
what am i missing?? i'm guessing it's something so obvious. thank you!