Use {Field Name} in Long Text?

I’m trying to insert your formula into a formula field, but I’m getting the error “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.” I updated the Field Names to be my own fields, but for some reason AT’s not taking it. Any ideas?

And I’m also curious, what are the Automation steps? Just create another column that’s Long Text and reference the formula column?

Thanks for your help.

-ML

Hi @M_L
Can you post a screenshot of what you have pasted that gives you an error?

I just checked and @Kamille_Parks formula worked for me.

Update - I was able to get it to work by updating the field references. How do I automate the filling of a long-text column with this data?

Thanks,
Mitch

Yep, here’s a screenshot of the error I get when I try to enter @Kamille_Parks formula in a Formula column.

Thanks for taking the time to look into this for me.

Airtable Screenshot of Formula Error (Google Drive jpg)

CONCATENATE(
  "Hello **", {First Name}, "**, your User Name is ", {User Name}, 
  " and your password is ", {Password}, ".", 
  "\n* Bullet point #1", 
  "\n* Bullet point #2"
)

Thanks so much for the responses on this one. I wanted to let you know I used @Kamille_Parks response, and it did solve the issue for me.

The main problem I had was using / instead of . I don’t code much and didn’t even think about it. Once I fixed the “slashes” I was able to build an entire multi-paragraph email using code, and automate it into another Long Text field.

THANK YOU!

-ML

My use case is super similar and I thought I'd put it here for the next person who finds this too much effort. It's not!

I need to concat a Text Field {Title}, then add a comma, then a second Text Field {Year}. I then want the text to copy to a rich text ready out that is "Title, Year"

I understand the method to do this is to add markdown in-line so that the formula read out would be "*Title*, Year" and then I'd need an automation to update a target Rich Text field based on any changes to the concat field. 

My inital formula was :

This worked but, I need to add an if statement so that if a there was nothing in the {Year} field it would only return "*Title*"

Next let's get that automation going - - > 

For dummies like me : the automation builder isn't super clear in setting up the action "Update a record" in the "Task" section. It's been a few year since I used this but this GUI is very confusing. 

For Record ID use "Airtable record ID" – this selects the record you're looking for in the automation record. 

For Fields select your output field eg "Rich Text" and then select your computed / concat field immediately below it. Clearer GUI would say: 

"Airtable record ID" - "Update Self"

Fields would say - Content from "Concat Title Formula" updates "Concat Title Rich Text"