Hi there,
I’m new with this community and I am trying to send data leads from Airtable to Gmail but I wan’t to set a Dynamics fields like for example:
__________________
Airtable Data:
First Name: John
Last Name: Mike
Address:1234
Age:
Email: John@sample.com
________________
Gmail:
First Name: {{142106945__John}}
Last Name: {{142106945__Mike}}
Address: {{142106945__1234}}
(Age: - I want to remove this section if empty including the Age label.)
Email: John@sample.com
_________
Thank you.
Best answer by GetUWired
Hi
To add some more explanation to this, you will need to change your email body type to HTML as opposed to plain. Otherwise, you will end up with odd spacing when a field doesn’t exist.
Here is a real slick way you could write your code
*Add Code Step > Run Javascript above Gmail Step*
Configure your code block like the attached but with your own variables and keys. The code is written to handle any number of combinations.
The code (<br> denotes a line break in HTML):
let conditionalText = "";
for (const [key,value] of Object.entries(inputData)) {
if (value) {
conditionalText += key + ": " + value + "<br>";
}
}
return {conditionalText}
This will return something like the below. Notice the Phone number field isn’t included since the value was blank.
which can be mapped into your email step. Please be sure to change body type to html and put a <br> anywhere you want a line break.
RESULTING EMAIL
Added Phone Value back in (no change needed to code or gmail configuration)
+14Hi
You can use Paths in Zaps: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths
Paths have Filters: https://zapier.com/apps/filter/help
Hi Tony!
Thank you for responding, and this is an excellent solution, but the problem with this is I had multiple fields like ten fields; if I make this method, I will end up numerous paths, which is not practical because there is a scenario that 2 fields are missing that would be end up just another parth and also, if I tried to change in the future that means I will change all of the paths.
Thank you
+14Hi
Then you’ll need to use a Code step to evaluate if the field value exists and return the output: https://zapier.com/apps/code/help
+12Hi
To add some more explanation to this, you will need to change your email body type to HTML as opposed to plain. Otherwise, you will end up with odd spacing when a field doesn’t exist.
Here is a real slick way you could write your code
*Add Code Step > Run Javascript above Gmail Step*
Configure your code block like the attached but with your own variables and keys. The code is written to handle any number of combinations.
The code (<br> denotes a line break in HTML):
let conditionalText = "";
for (const [key,value] of Object.entries(inputData)) {
if (value) {
conditionalText += key + ": " + value + "<br>";
}
}
return {conditionalText}
This will return something like the below. Notice the Phone number field isn’t included since the value was blank.
which can be mapped into your email step. Please be sure to change body type to html and put a <br> anywhere you want a line break.
RESULTING EMAIL
Added Phone Value back in (no change needed to code or gmail configuration)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.