• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Applications Questions
S

Saul Macht

started a topic over 5 years ago
Answered

Sendgrid multiple substitution tags / Create list using multiple data pills

I am using sendgrid to send out emails. There is field option when using Workato for sendgrid. The field names are under the section Substitutions fields but there is only one set of the fields "original text" and "replace text". I also see the "Substitutions Source List" but I'm not sure how to use it. I have multiple words that need to be replaced dynamically using data from Quickbase. How can I do this?


%first_name%

%Appointment Date%

%Appointment Time%

%Address%

%City%

%State%

%Postal Code%


Best Answer
A
Amanda Wong said over 5 years ago

Hi Saul, you are correct that you can use the Substitutions Source List to replace multiple email placeholders with data.


First, you would need to create a list containing your placeholder fields and the corresponding data. There are a few steps involved. 




1) Create a dummy list for iteration 

Since you have a total of 7 placeholder fields, you would create a list of size = 7.


image




2) Use repeat action to iterate over dummy list i.e. repeat nested action 7 times


image




3) The nested action within the Repeat action is Append item to list 

Define a name for your list e.g. Email Placeholders. 


image



Create 2 list item fields: (1) Placeholder names and (2) Text fields to contain the placeholder text and actual text respectively. For 7 item fields, the index of the items begin from 0 and ends at 6. The sequence of the item fields should match. The additional formula for date and time is to return the datetime data in a specified format. 


image




Once you have followed the above steps and successfully created the list, you can map it to your Sendgrid Substitution Source List fields as follows:


image




Answer

Amanda Wong

said over 5 years ago

Hi Saul, you are correct that you can use the Substitutions Source List to replace multiple email placeholders with data.


First, you would need to create a list containing your placeholder fields and the corresponding data. There are a few steps involved. 




1) Create a dummy list for iteration 

Since you have a total of 7 placeholder fields, you would create a list of size = 7.


image




2) Use repeat action to iterate over dummy list i.e. repeat nested action 7 times


image




3) The nested action within the Repeat action is Append item to list 

Define a name for your list e.g. Email Placeholders. 


image



Create 2 list item fields: (1) Placeholder names and (2) Text fields to contain the placeholder text and actual text respectively. For 7 item fields, the index of the items begin from 0 and ends at 6. The sequence of the item fields should match. The additional formula for date and time is to return the datetime data in a specified format. 


image




Once you have followed the above steps and successfully created the list, you can map it to your Sendgrid Substitution Source List fields as follows:


image




Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count