- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 11, 2024 01:39 AM
I 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 🙏
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 11, 2024 06:02 AM - edited May 11, 2024 06:05 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 12, 2024 12:05 PM
You 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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 11, 2024 06:02 AM - edited May 11, 2024 06:05 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 12, 2024 02:25 AM - edited May 12, 2024 05:56 AM
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?
System said: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 12, 2024 12:05 PM
You 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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 12, 2024 12:19 PM
Your a star, thanks @ScottWorld 🙏
