I have a table with a column "Size". I have s...

(Benoit Gramond) #1

I have a table with a column “Size”. I have spaces before the size in my database (in order to sort by "

S", " M", “L”).

When I use this table in Appsheet (That comes from my ERP’s database so not possible to change), the spaces are automatically deleted.

Is there a way to avoid the Delete of the spaces before my size?

SOLUTION: A virtual columns like:

IF([Taille] =

S,

CONCATENATE("

",[Taille]),

IF([Taille] =

M,

CONCATENATE(" ",[Taille]),

[Taille]

) )

(Gil Littman [AppSheet]) #2

@Benoit_Gramond You could change the column type to Enum and set the order of the values in the column definitions.

No spaces needed :slight_smile:

(Benoit Gramond) #3

@Gil_Littman_AppSheet the space is not needed in appsheet but needed in the other application. When I need transfer information from appsheet to my other application, it does not match because in the other app the spaces are required.

(Gil Littman [AppSheet]) #4

@Benoit_Gramond Gotcha, you can try to use some other non visible characters like this one: “” It shouldn’t be trimmed when you save your record. Just copy the character between the quotes above and paste it into your app.

(Benoit Gramond) #5

@Gil_Littman_AppSheet Nice idea! Problem solved thanks to you!

=> I created a virtual column like this:

IF([Taille] =

S, CONCATENATE("

",[Taille]), … )