- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 11:03 PM
Hello everyone! I'm a new member in the airtable community and wanted help on my airtable problems.
I currently have a base table that receives emails, the problem currently is that it saves the whole email chain instead of just the email itself. I wanted to ask if there's a way (scripting/formula) to automatically remove lines of texts after the word "From:" for every new entry that comes in.
Thank you!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 11:18 PM
Try:
TRIM(
LEFT(
Notes,
FIND(
"From:",
Notes
) - 1
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 11:18 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 29, 2024 11:34 PM
This works! Thank you!
