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:
Use the Uri.Encode block of the web component
Save the data encoded with that block
Something like this:
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!!