How can I update textbox based off another column

I’m trying to make my emailing a bit easier by having a textbox change it’s value based off of the row’s “Status” column so that I can send the content of that text box in an email with a button push.

so, in layman, the formulas would need to be something like ‘if [status] is “reminder” then [email content] is “We haven’t heard from you in awhile. Please reach back out to us!”’

This would need to be repeated for a couple different steps to have it input different content. The goal is just to avoid clogging up my rows with lots of columns since I would just have default values in different text box, but then you wouldn’t get to help me and who doesn’t want that?

Dear @P_C, welcome to the Coda community!

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:

Thank you so much. Coda is so cool, but the thing that really makes it right for me is how helpful the community is.

1 Like