I managed to get an id to send each product.
Your recommendation helped me, I’m not sure if I did as you tell me, but it was based on your idea.
In the products table I already had the trade in each row, so I only had to add the mail, concatenate it to control with the confirmed table. While I succeeded, I had to make multiple columns in the editor. Surely there is a simpler way, but I’ll show you to see.
- In the spreadsheet I entered the word name to all the products, to relate it to the user.
Already in the editor - A relation column to get the mail.
- A vlookup column to get the mail again, otherwise I can’t find a way to concatenate it.
- A template column to link commerce and mail.
- A relation column to join with confirmed orders
- A vlookup column to find the number of times that mail and trade are in the confirmed orders table.
- A template column to join Commerce & mail & count
I show you the link:
It works, it takes a while for the order to arrive and at this moment the internet works slowly, I would have to use a total in the data editor and also make several changes to optimize the application and reduce formulas. But I wanted to test that logic and it works. I am missing many things, but it is the basis for taking off.