+3I have a single table where I have different columns for Town, County, Region etc. I then have a Description field with some generic copy but at the end I want to automatically add the Town name within its row (see image).
E.g. Town: Aaron's Hill
Description: Welcome to the beautiful town of {Town}
Seems like a fairly basic requirement but I've done a lot of Google searching and I can't find the answer. Any help very much appreciated 🙏
Best answer by ScottWorld
You would create a formula field that looks like this:
"Welcome to the town of " & {Town}Hope this helps! You can learn even more about formula fields in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.
— ScottWorld, Expert Airtable Consultant
+33You would create a formula field that looks like this:
"Welcome to the town of " & {Town}Hope this helps! You can learn even more about formula fields in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.
— ScottWorld, Expert Airtable Consultant
+3You would create a formula field that looks like this:
"Welcome to the town of " & {Town}Hope this helps! You can learn even more about formula fields in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.
— ScottWorld, Expert Airtable Consultant
Thanks @ScottWorld . That worked for what I described. I then tried to add two parts to the sentence so the 'Town' appears in the middle but this through an error. Is there a way to do the below?
+33You will need to add another ampersand (the & symbol) before your quoted text. You use that symbol to connect different pieces of text in your formula.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
