Skip to main content

How To add “( )” around a text field in a formlas of airtable

  • October 9, 2023
  • 2 replies
  • 10 views

Forum|alt.badge.img+4

I already have a formulas that work fine although i need to add “( )” around my Base field called MODELE

IF(AND({PRODUIT},{MODELE}),
{PRODUIT} & " - " & {MODELE} & "\n",
IF({PRODUIT}, " " & {PRODUIT} & "\n") &
IF({MODELE}, " " & {MODELE} & "\n"))&
 
Right now when I got the formulas it shows 
ANNEAU DE FOULARD - ALEXANDER
I would like to add ", so it will show this.
ANNEAU DE FOULARD - "ALEXANDER"
 
 
 

2 replies

Forum|alt.badge.img+4
  • Author
  • Inspiring
  • 7 replies
  • October 10, 2023

Sorry, there was a problem saving this field. Unknown function names: CHAR


Forum|alt.badge.img+4
  • Author
  • Inspiring
  • 7 replies
  • October 10, 2023

well i did refresh and char is not acdepted