Re: Managing multiple mailing templates with Airtable (Formula Field limitations)
Hi all,
Hope you’re doing well.
I’m asking the community about a strategic choice I’m about to make.
We are handeling Client Missions through Airtable. We did automate most of our process with Zapier, like sending e-mails.
Right now, we only have 1 Client Langage, and 2 differents type of products. Each product and lang will result in a quiet different mail template. For now, I was using Paths in Zapier.
However, we’re going to scale to 3 langages, and maybe up to 4 or 5 products, therefore I may have up to 15 differents mail templates. Zapier Paths seem not appropriate at all, without considering maintenance costs…
I’m about to change the strategy to conditionally format e-mails templates directly in Airtable in a Formula Field.
This formula with look like :
SWITCH ( Product ,
“Classic”,
SWITCH ( Lang ,
“FR”, ‘Mail template…”
“NL”, ‘Mail template…”
“EN”, ‘Mail template…”
),
“Copro”,
SWITCH ( Lang ,
“FR”, ‘Mail template…”
“NL”, ‘Mail template…”
“EN”, ‘Mail template…”
),
“Office”,
SWITCH ( Lang ,
“FR”, ‘Mail template…”
“NL”, ‘Mail template…”
“EN”, ‘Mail template…”
),
)
Of course “Mail template” will be a HTML formatted, including variables, etc…
My questions are :
- Considering the size of the potential formula (I already made a valid test with 9 branchs and 40.000 chars total), should I anticipate issues ?
- Would you recommend an other strategy ?
Thank you very much for you advices,
Regards,
Pierre-Louis
