Best answer

Dynamics Fields

2 years ago
30 December 2021
6 replies
95 views

Clyteroll
Beginner
2 replies

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.

icon

Best answer by GetUWired 30 December 2021, 17:08

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
23925 replies
2 years ago
30 December 2021

Hi @Clyteroll

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

Clyteroll
Author
Beginner
2 replies
2 years ago
30 December 2021

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

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
23925 replies
2 years ago
30 December 2021

Hi @Clyteroll

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

Userlevel 7

+12

GetUWired
Certified Zapier Expert
1015 replies
2 years ago
30 December 2021
Answer

Hi @Clyteroll

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.