How to save special characters (such as ç , í , ü , etc) in Airtable

When we want to save the contents of a text box and type words that contain special characters, such as accents, these are stored in airtable with signs that cannot be read.

We see that the data is saved in the following way:

airtable%20character%20special

To solve this we must do two things:

First

Use the Uri.Encode block of the web component

Save the data encoded with that block

Something like this:

Second

When we obtain the data from airtable, to the variable that receives the data we have to put the Uri.Decode block.

If we get a whole column, we should do it like this:

AIRTABLE%20CARACTER%20ESPECIAL%202

In this example in “global getConcepto” we get the list of the whole column with the characters correctly.

I hope it’s useful!!

12 Likes

You are an airtable master…:smile:

Buena guía!


Good guide!

How to convert unicode code?

Hello
I want to save special characters like (ä, ö, ü, and others) (e.g. Theodor Pörtner Haus) in Airtable. In the picture you can see the results. But I need an “ö” in the table. Does the encoding work for anyone or does someone have another idea?
Thanks


image

Unfortunately with web encoding you won’t be able to see this special characters in your airtable spreadsheet and there is no solution for that . I know it cause I have also the same problem with Greek characters. This is how my spreadsheet looks but at least when data received from airtable everything looks ok

2 Likes

then I stop experimenting
Thank you very much

1 Like

Good morning, will you have an aia file as an example?

Greetings.

Teacher you solved it?