I connected my gmail account with a table doc and like send an email once a checkbox in one of the columns has been checked. All good until I get to the content field of the automation. I dont like to show a static message whenever the automation is triggered but instead send the information from a few selected columns of the row in focus (i.e. the row where the checkmark has been clicked). How can I do this?
Welcome to the CODA community. I had a similar need last week, and found the following doc to be quite helpful. Very flexible, it makes use of the Format() functions to achieve what I think you are looking for.
If the message is fairly simple you could do it all in a formula in the content field.
=” to make it a formula.
And then use Concatenate() to build the message (add commas between the different things you want to mash together):
Concatenate( "Hi ", Step1Result.Name, "! We're just writing to inform you that your appointment on ", Step1Result.Date, " has been confirmed." )