What is the best way to combine text and variable into a column?

[P_C]

I’m trying to pull a table.name field into a new column and have it followed by a “written content to the recipient” plain text. Is there a way to do this?

[Jean_Pierre_Traets]

Dear @P_C,

You might be searching for something like this:

How can I update textbox based off another column

Dear @P_C, welcome to the Coda community! [image] This is the used sample “IF” statement If(thisRow.Status="Reminder","We haven’t heard from you in awhile. Please reach back out to us!" , if(thisRow.Status="Paid","Thanks for your in time payment!" ,"")) And a reference to the formula builder for the IF statement:

If I misunderstood , a sample of the expected outcome is always appriciated

[P_C]

That’s the gist of it but how could I also inject variables into the email content?

[Jean_Pierre_Traets]

Dear @P_C

This post from @BenLee is a good sample:

Google Calendar Events and Gmail Invites

I took some time to do a deep dive into our Google Calendar Pack after being asked some questions about event and meeting management. Being able to send a custom invite email, add attendees after creating the event, and managing RSVP lists were all requirements for a full featured solution. This solution is a single table, but I split like items into views to better show each function. Feedback is always welcome!