Hello dear community members,
I hope you’re doing great.
I am requesting your help because I would like to use a script, so that when a partner edits a Linked Field (here ‘Status’) in his Table View, it will directly compare its value to the Status of the client in my Lead Table (lookup field) to update it, based on the one the partner selected.
I was using “edit shared view” before but it has been removed by Airtable, and I tried different options but seems the “only way”. I already have different synced tables within my main base, and I manage to organise everything between them, but he cannot work for this specific need of editable view.
Because the “Status” that is to be chosen from the partner in its view is creating a duplicate in my ‘Status’ table, and thus do not update my CRM, which therefore do not stop/ launch my sequencing and is a big problem for me because it means I will/or will not send email to people who should receive/or not one.
The thing is that in both table my ‘key field’ is not the same. That’s why I think only a script can help me here…I have been able to prepare what I want using VSCode but I know nothing about scripting in JS or JSON. Could someone please help me redact it ?
I am adding some pictures to show the structure and what I imagined.
Thanks a lot in advance for your help,
Pierre