- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 03, 2023 08:59 PM
My table has a Rollup field (let's call it 'Titles Field').
I used the ARRAYJOIN(values, ', '), so the titles are separated by commas.
However, I want to add a Formula Field that show only the Newest/Latest title added to the rollup field.
Please advise.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 03:37 AM
I believe the array displays in order from earliest linked to most recently linked, and so you could perhaps try using this in your rollup:
REGEX_EXTRACT(
ARRAYJOIN(values),
'[^,]*$'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 04, 2023 04:42 AM
Unfortunately, Airtable doesn’t offer that function natively, even though customers have been requesting it for years & years. Be sure to report this as a feature request to support@airtable.com.
In the meantime, you will need to use the trick I outline in this episode of the BuiltOnAir podcast: https://youtu.be/T9RWQndgKoQ
If you have more questions, I may not see your followup questions here but you can find me & other Airtable experts here.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 03:37 AM
I believe the array displays in order from earliest linked to most recently linked, and so you could perhaps try using this in your rollup:
REGEX_EXTRACT(
ARRAYJOIN(values),
'[^,]*$'
)