Hey,
I have tables of:
customers
Assets - each customer can have several assets
Faults - any property can have faults
The handyman - for each fault there can be several handymen who will fix the fault
Suppliers - for each malfunction there can be several suppliers through whom we will buy the materials to repair the malfunction.
My problem is that I am unable to send the bank details of the handymen and suppliers to the customer by email.
For example, if I have a problem that 2 handymen fixed the problem and we bought materials to fix the problem from 2 suppliers.
When the fault has been fixed, I want to perform an automation that will send the customer a message in the following style - "Hi X, please transfer payment for handling fault Y to:
Handyman 1:
Bank - XXXXX
Branch - XXXXX
Bank account number - XXXXXX
Handyman 2:
Bank - XXXXX
Branch - XXXXX
Bank account number - XXXXXX
Supplier 1:
Bank - XXXXX
Branch - XXXXX
Bank account number - XXXXXX
Supplier 2:
Bank - XXXXX
Branch - XXXXX
Bank account number - XXXXXX
In addition, another thing that makes it difficult to create this automation is that the email should be left to right.
Is it possible to create it through AIRTABLE?
Thanks.
