Hi,
I work for a property management company.
I made a table for assets, faults, professionals and suppliers.
When there is a fault, I add a fault to the fault table and link to the property where it happened.
In addition, I add to the fault the professional in the fault.
When the fault is over, an email is sent to the customer to whom the property belongs and in the email there is a request for payment for the fault with the professional's bank details (for bank transfer).
So far it's working great!
When we need to buy materials for the breakdowns.
I wanted to do the same as with the professionals only with suppliers.
I mean, when there is a malfunction for the purpose of the example - painting an apartment - and there is no paint then we buy from one of the suppliers, at the end of the malfunction I would like to ask the customer in the email of the automation to transfer payment for the supplier as well.
It also works great! When we buy materials from only one place
The problem is, when I buy products for a fault from several different places, in the email it is not displayed well, it shows the name of the supplier like this "Please transfer payment for supplier 1, supplier 2".
And this is how it also shows the suppliers' bank details, for example - please transfer the payment to the following bank details:
Bank name - "Supplier 1's bank name", "Supplier 2's bank name"
It doesn't look neat and understandable to the customer.
Is there a way to arrange it so that it looks understandable to the customer in the email?
Thanks
