Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Extract Initials from String Including Full Name

Topic Labels: Formulas
123 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi folks,

I was able to extract initials from full name (thanks to the Name demo base from @W_Vann_Hall ), but because of duplicate names, I added the email as part of the customer identifier (full name + email), which lives in my Customer table. Now I can’t seem to figure out how to extract the initials from this new field. When I try to apply the same formulas to the Name field linked to my Customer table, the formulas no longer work (because I guess it’s merely a linked record, not actual value?). So I created a second table called New Name Table, and extracted the initials under that table first, then linked it back to my original table. But the values are not populating when new records come in (i.e. blank records in the screenshot).

FYI the field “Calculation” is the first initial formula applied on the Customer Name field. I am completely lost on how to trim everything up to " (" from the right. Otherwise that would be a solution too (and spares me an additional table).

image

This is my New Name Table:
image

0 Replies 0