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

[pepocero]

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:

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:

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

I hope it’s useful!!

[vknow360 (Sunny Gupta)]

You are an airtable master…

[yanquisalexander (Alexander Barrios)]

Buena guía!

---

Good guide!

[app_dvn_19 (Ngoc Nghi)]

How to convert unicode code?

[Bebemo]

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

[dora_paz (Dora)]

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

[Bebemo]

then I stop experimenting
Thank you very much

[jimy_jonayker (jimy Jimenez)]

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

Greetings.

[jimy_jonayker (jimy Jimenez)]

Teacher you solved it?

[akhtarrkhan_joyia (Humble Tricks)]

How can I use the decode block here? If I use it behind the select list index block then items in listview become unclickable… Encoding and Decoding is working, but items are not clickable… Please help.

Tags removed by Mod

[dora_paz (Dora)]

Please do not tags mebers in order to get attension. Use web uri decode before select list item list block and move all green blocks outside the loop

[akhtarrkhan_joyia (Humble Tricks)]

There is another issue!

[akhtarrkhan_joyia (Humble Tricks)]

Its done, i have added listview elements block after the loop “each number” but still listview items are not clickable.

[akhtarrkhan_joyia (Humble Tricks)]

why listview items are not clickable after decoding?

[dora_paz (Dora)]

Outside the loop, inside local variable

[akhtarrkhan_joyia (Humble Tricks)]

yes, but still listview items are not clickable

[akhtarrkhan_joyia (Humble Tricks)]

I have a link behind every item of listview. Using activity starter to open that link, if I am not using encoding and decoding then airtable doestn’t accept “Hindi” language and “emojis”, that why I use web component. Now decoded items in the listview are not clickable. Do you understand anything?

[dora_paz (Dora)]

Post a test aia or pm me your aia