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]
) )
@Benoit_Gramond You could change the column type to Enum and set the order of the values in the column definitions.
No spaces needed
@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.
@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.
@Gil_Littman_AppSheet Nice idea! Problem solved thanks to you!
=> I created a virtual column like this:
IF([Taille] =
S, CONCATENATE("
",[Taille]), … )
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |