Hi, after my trigger, I'm doing a search for an email address, using the row number I want to update a cell by including the new value and not replace it. eg.
I did this but it just added to the next column
BEFORE
AFTER
I did this but it just added to the next column
BEFORE
Name | product | price | |
Fake fname 1 | [email protected] | product 1 | 100000 |
Fake fname 2 | [email protected] | product 3 | 100000 |
Fake fname 3 | [email protected] | product 1 | 100000 |
Fake fname 4 | [email protected] | product 1 | 100000 |
AFTER
Name | product | price | |
Fake fname 1 | [email protected] | product 1 | 100000 |
Fake fname 2 | [email protected] | product 3 | 100000 |
Fake fname 3 | [email protected] | product 1, Product 2 | 100000 |
Fake fname 4 | [email protected] | product 1 | 100000 |