NICK75 - profile

NICK75 · Nov 28, 2023

Hello,I would like to not have a space at the beginning of each entriesI think I have to use Trim but My formulas is long and I do not know how to make sure each line and trimmed.Right now with this formulas each lines as a white space at the beginni...

NICK75 · Oct 09, 2023

I already have a formulas that work fine although i need to add “( )” around my Base field called MODELEIF(AND({PRODUIT},{MODELE}),{PRODUIT} & " - " & {MODELE} & "\n",IF({PRODUIT}, " " & {PRODUIT} & "\n") &IF({MODELE}, " " & {MODELE} & "\n"))& Right ...

NICK75 · Oct 07, 2023

I am trying to have a formula which give me the possibility to have on the same line two fields separated by a coma. This is tricky, because, i need also to have in the formula that if the field is empty if it not showing the empty space or make a br...

NICK75 · Sep 30, 2023

Hello community,My script do not work if the field is blanc there is a line break. however, i need the linebreak when there is a record.How can I do ? Thanks in advance {MARQUES} & IF({DESIGNER}, " X " & {DESIGNER}) & IF({DATATION}, " - " & {DATATION...

NICK75 · Dec 04, 2023

I do not understand where and how to use REGEX_REPLACE() to remove all white space next to a line break but I do know how to write it correctly. and what to put into () ?Can you be more specific ?thanks in advance here's what I have so far and where ...

NICK75 · Nov 30, 2023

I still have a problem i would like to use REGEX_REPLACE() to remove all white space next to a line break but I do know how to write it correctly.here's what I have so far and where should insert and write with REGEX_REPLACE (?????) IF(AND({MARQUES},...

NICK75 · Oct 10, 2023

well i did refresh and char is not acdepted

NICK75 · Oct 10, 2023

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

NICK75 · Oct 09, 2023

Thanks that is great

User Statistics

User Activity

Remove white spaces at the beginning of all fields

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

Impossible to combine fields and line break if empty fields

Pb : the empty lines don't show up and don't make a line break with empty lines.

Re: Remove white spaces at the beginning of all fields

Re: Impossible to combine fields and line break if empty fields

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

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

Re: Impossible to combine fields and line break if empty fields