Hi, I would like to create a scenario, where an email in my Inbox with subject containing word ‘estimate’ and an address (eg. Subject: Estimate 43 Holbrook Lane), updates a record in Projects table named:
[19.06.21] Magic-43 Holbrook Lane BR7 6PE [ASAP][19.06.27]
so containing the address.
The update changes Status field in Projects table from ACTIVE to DONE.
I would like it to run via Integromat, but failed totally and thought that in Zapier it will be easier but it’s not.
Please help, I have a very scarce knowledge about formulas.