Help

Re: I need only the first letter of every word Big

7106 1
cancel
Showing results for 
Search instead for 
Did you mean: 
airtableManuel
6 - Interface Innovator
6 - Interface Innovator

From this:
animals > cat > face > eyes
into
Animals/Cat/Face/Eyes

how can i do that i know the first step:

SUBSTITUTE({Category 1}, ’ > ', ‘/’) // this replaces the > into /
and then how can i use the upper case method only for the first letter of every word?
thanks for the help
please write an example code, thanks!

20 Replies 20

Long story short, Airtable’s formulas won’t let you do what you want. You need the ability to iterate through a collection and perform a specific operation on each item in that collection, which can’t currently happen with existing formula tools.

Depending on how you’re getting the original string, though, you might be able to do the first-letter capitalization elsewhere in the process. Are you receiving the source string (animals > cat > face > eyes) from an external source, or somewhere else in the same base?

EDIT: Not sure why I said it’s not possible. It can be done, but it’s going to take a collection of formulas.

Yes i received only this: animals > cat > face > eyes

From a external source

In that case your only options are to either do the capitalization in that external source before it gets to Airtable, or to use some form of integration—either custom code that uses the API, or a tool like Zapier or Integromat—to process the text.

0d41b7239ab01c5f5e8f76a7f7d714f76ba86a36.png

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.


this doc can write 3 words automatically Big :stuck_out_tongue:

but i dont understand the full code…

I can’t see the formulas in that base because it’s shared as read-only, so I’m afraid I can’t help.

Looking deeper, methinks that’s a product of @W_Vann_Hall. Perhaps he can shed some light on this situation.

That link doesn’t open up a specific base. It just takes me to my own workspace page.