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 |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |