I’ve tried multiple times and I’m still stuck so I’m hoping this community can help.
I have a bunch of tables in a base. The main one is called Leads & Clients. There is another called Waitlist which also has a form view. LC has a field called ‘status’ and Waitlist has a question asking ‘have we worked together before?’
I have it set up where a new form submission triggers an automation that creates a new client record in LC if one doesn’t already exist for that client or it just updates one that’s already there. And the automation links the two records across both forms.
This is where I’m stuck… I want the status in LC to change to ‘lead’ if someone says no on the Waitlist form to the question asking if we’ve worked together before.