The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have a field that is bringing in names using the web clipper block. The problem I am having is the names from the site come in with additional header, and extra space between them. Is there a way to clean this up in a formula or in the web clipper ...
So I have been working on various integrations using Integromat for my Destiny Search Project system. I have come to a roadblock and looking for some help…
I have an Attachment field in Airtable that has a .csv file in it. The file is formatted with ...
I am trying to figure the correct syntax for a consistent name concatenation. I have two fields, First Name, and Last Name. I have used the following formula to capitalize the first letter:
UPPER(LEFT({First Name}))&LOWER(MID({First Name},2,LEN({Firs...
I really love the Page Designer block but found another feature idea that would be very useful. Right now when you use Page Designer it’s for a specific record. I would love a way to design a printable page for a view or table.
Kamille_Parks:
TRIM(SUBSTITUTE(SUBSTITUTE({Field}, “Clients:”, “”), " ", ", "))
Same issue I’ve been having… for some reason it does not remove the space between names or add the comma. I’ve been trying combinations of trim, substitute, replac...