I’m building a small introduction app but I’m having trouble writing 2 operations that looks easy. ^^’
- In the column “Match” is used to select a match. Eg.: I want to introduce to Orelsan Cotentin to Michael Jackson → select email address firstname.lastname@example.org (cfr. table below). But then, I’d like that the table autofills email@example.com in Orelsan’s row.
Do you guys have any idea how to do it?
- Once the matches are done, I’d like to send an introduction email to all matches at the same time.
Any ideas how can I create a formula that would understand the concept of matches to populate email content with the right data?
Thanks in advance for guiding me!