Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 08, 2023 08:27 AM
Hi guys, I need help building formula automation and seem to have trouble with the Find function.
So we have an outreach database for our customers and for each outreach, we track a response as "yes" or "no," Ideally after two constant rejections we would mark the customer inactive. If later on they respond or reach out then we will mark them active again.
With this in context, I'm trying to build an automatic status update function in Airtable. If one customer's status is "No, No" or "Yes, No, No," the customer's status shall automatically change to "inactive." If a new yes is recorded, like "No, No, Yes" then it shall change to "active,"
I tried a few different ways but none seem to work perfectly. The closest I could think about right now is to use the "Find()" function which in my understanding returns the last position of the string being looked up. However, when I tried it, this is what I got:
Does anyone know what's going on or have a better way to build our solution? Attaching the current issue.
Feb 08, 2023 09:58 AM
Hi,
I think this will work:
Feb 08, 2023 08:25 PM
Hi @bruceconsulting the Find function doesn't work in our case (it doesn't recognize "No, No" but the Right function worked perfectly fine in our case!!
So I updated the function to a super simple case