
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 11, 2023 05:58 PM
Hi all,
II'll try and better explain.
Imagining you have a base with multiple tables, and on one table there are 2 fields... One, is a linked to field that allows for multiple selected records... Let's say it links to a table listing people's names; members of a team.
One record has 3 names:
- Jason Jones
- Amy Abner
- Steve Sullivan
Again, these are individual records from another base, not text.
Is there a way I can pull just the first record, automatically, into the 2nd field? Similar to if I was using the right or left functions with numbers.
I want to have a second field that pulls out just Jason Jones in this field, and does the same for all the other records along that same field; ie pulling out just the first record.
🙏
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 06:26 AM
Hmm, yeah, try an IF() that uses a FIND() to see if it can find a comma, and if it doesn't just display the name?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 11, 2023 08:31 PM
Linked fields still can work with the LEFT, so you can use it to get the first linked record like so:
LEFT(
{New table},
FIND(
',',
{New table}
) - 1
)
And if you wanted it to operate like a linked field, you could either manually paste the value into a linked field or use an automation to do so?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 06:15 AM
Thanks for the reply TTSCo, I've got this to work with the exception of when that field with a list of names, contains only one name (given that there is no comma separator). Im thinking an IF Function applied to trap the times that there is a singular name, but can't wrap my head around the conditions I would place in there.
Any ideas?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 06:26 AM
Hmm, yeah, try an IF() that uses a FIND() to see if it can find a comma, and if it doesn't just display the name?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 08:56 AM
Holy Crap. Yes. That has to be it. Will try it, but marking it as the solution all the same.
Thanks again

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2023 08:59 AM - edited Apr 12, 2023 09:00 AM
Yeah that worked. Really grateful for your brain. 🙂 🧠
