Initial text value misunderstood as date

Hi,
I set a text column ("Aspect ratio") with "16:9" as initial value (without any kind of validation). 

Dub_App_0-1663621572872.png

When record is created this is the result:

Dub_App_1-1663621666731.png

As you can see, the content its a dummy date as text (but misunderstanding "16:9" as a time value).

The workaround was add an additional text ("Ratio 16:9") as initial value to avoid the weird convertion:

Dub_App_2-1663621972650.png

My humble opinion is that it is a bug.  But if I am wrong, please let me know.

Thanks!

 

Solved Solved
0 5 262
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

@Dub_App wrote:

My humble opinion is that it is a bug.  But if I am wrong, please let me know.


I would agree, but it is in fact intended behavior: AppSheet is trying to be helpful by "recognizing" dates and times whether you the app creator want it to or not. Working around the "feature" is the only option.

View solution in original post

5 REPLIES 5
Top Labels in this Space