Help

Re: Scripting - Text - Concatenation

Solved
Jump to Solution
2058 0
cancel
Showing results for 
Search instead for 
Did you mean: 
FChAirTable
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I use a script to update a field {TypeForm} by concatenating 4 fields {Rang},{TypeQuestion},{Question},{Option}. {Rang} is Single line text / {TypeQuestion} is Single select / {Question},{Option} are Rich text

When i execute the following script:

image

with these data:

image

I get the following result:

image

Why first column values {Rang} like 1., 2., 3. etc.are not properly transferred in {TypeForm} as we see 1. , 1., 1,

Thanks a lot for your help.

F.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Because you are setting the value of a rich text field, which uses Airtable flavored Markdown.

If you want the text to be exactly as you set it without the formatting, customize the field by turning off “rich text formatting”.

See Solution in Thread

4 Replies 4
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Because you are setting the value of a rich text field, which uses Airtable flavored Markdown.

If you want the text to be exactly as you set it without the formatting, customize the field by turning off “rich text formatting”.

FChAirTable
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks a lot !!! As usual your answers are crystal clear…

By the way, is there a reason why you are doing this with scripting versus a formula field? (There are lots of possible reasons why scripting might be necessary, but if there isn’t a reason, a formula field might be easier.)

From Data with a rich formatting in AirTable (Rich Text Column), i will generate a survey in Typeform by using Google Docs. I need to follow Typeform guidelines for Google Docs. For example, for a multiple choice question, i need to provide these structure in Google Docs.

1. {Multiple Choice} Question
a. Option1
b. Option2

Having the first line generated is quite easy with AirTable and Google Docs. But having the 2 next lines generated as expected is another story. I was not able to do it. These 3 lines should be generated in the same cell with the right structure. Unfortunately, AirTable & GoogleDoc integration does not transform AirTable rich text in GoogleDocs rich text. So i lose the expected syntax.

I have to figure out another solution :slightly_smiling_face:

F.