Https://www.integromat.com/scenario/846414/edit

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.

Take care,
Magda