Sendgrid Email HTML - Pull custom data from another record in a different table

[Jamie_Rood]

Hi!

I run a recruitment business and I currently have a table for ‘Jobseeker sign ups’ and ‘Open Projects’. When I get a new ‘Open Project’, I send an HTML email to notify jobseekers about the project. Apart from referencing the jobseeker’s Name and Surname in the HTML code, the rest of the information about the ‘Open Project’ is hard coded.

I wanted to know whether there is a way to include data about the ‘Open Project’ in the email HTML even though the Sendgrid block is set to send emails to a view in the ‘Jobseeker sign ups’ table.

Ideally when I get an open project, I would like to generate an email template containing the information from the fields that exist in the Open Project table, so I can notify the jobseekers about the details of this Open Project.

Any assistance is greatly appreciated. Thank you!

[Jamie_Rood]

Hi @Mohamed_Swellam ,

Sorry what do you mean by all at once?

[Mohamed_Swella1]

I mean it has to be {Field Name}

What i see in your HTML is the following

{ “HTML Code”>Field Name< “HTML Code” }