Using Single Select Column data to make a Multiple...

[eranggg]

Hi everyone,

I have a table for customers, a table for assets and a table for faults.

Each client can have several assets and each asset can have several faults.

When a fault is closed, an email is sent to the customer with a request for payment for that fault.

I have clients who are divorced and they are paying for the same property.

Their email column in the faults table looks like this now - email 1, email 2

And the same for the column with their first name - first name 1, first name 2

Is it possible to send an email to each of them separately when a fault is closed?

[Sistema_Aotearo]

If you use the "Repeating Logic" in your automation. Repeat the send email action for each email on the list.

Making the email into your list might be the tricky bit here. But very possible. I'll assume each payment request has a link field to the customer. In this particular case, there are two customers linked.

Use the customers themselves as the list. And then you can use their emails from each item found on the list.

If your tables are set up differently than described, let me know and I can see what other suggestions I have!

Let me know if this helps. 🙂

[eranggg]

ok but how can I send email presonlize to each email?

for example - Hi First Name 1, please pay for the fault......?

[Sistema_Aotearo]

In the email, use information from the repeated list (Customer).

Don't use details from the payment request. Use details from the customer.

The logic is; send payment request details to customer(s) listed.