Skip to main content

When pasting the created formula field from Airtable to another application (Chrome or TextEdit), the result adds open and closing quotations "".


Formula:

’ & Name & '’ & “\n” &

{FIELD 1} & “\n” &

"FIELD 2: " & FIELD 2 & “\n” &

"FIELD 3 " & {FIELD 3} & “\n” &


"FIELD 4 " & IF({FIELD 4}=“1”,“Yes”,“N/A”) & “\n” &

"FIELD 5 " & {FIELD 5} & “\n” &


"FIELD 6 " & IF({FIELD 6}=“1”,“Yes”,“N/A”) & “\n” &


"FIELD 7 " & IF({FIELD 7}=“1”,“Yes”,“N/A”) & “\n” &


"FIELD 8 " & IF({FIELD 8}=“1”,“Yes”,“N/A”) & “\n” &


"FIELD 9 " & IF({FIELD 9}=“1”,“Yes”,“N/A”) & “\n” &


"FIELD 10 " & {FIELD 10} & “\n” &

"FIELD 11 " & “\n” & {FIELD 12}


Result:

Sample Name

FIELD 1

FIELD 2: FIELD 2

FIELD 3 FIELD 3

FIELD 4 Yes

FIELD 5 FIELD 5

FIELD 6 Yes

FIELD 7 Yes

FIELD 8 Yes

FIELD 9 Yes

FIELD 10 FIELD 10

FIELD 11

FIELD 12”


Any idea what’s going on? The quotations doesn’t show in the cell itself, only when copied and pasted the content to other apps. Actual formula and result omitted. Thanks!

Be the first to reply!

Reply