Date and time appear in weird format

Get Help
1

Hi all,

I created a form using text inputs and dropdowns.
The dropdown is linked to a date/time collection.

When i check the preview, the date and time comes up in a weird format.

Can anyone help me with this please.

Thank you

image
image828Ă—1792 76.6 KB

2

Hi @Shohidul,

Here is the thing: dropdowns (in the form and standalone) take first field’s value from the collection as a a display label.
So, I assume that 1st field in your collection is a Date or DateTime field. The format you see is a raw text ISO time format.

To solve this you can change the fields’ order in your datetime collection, so that the 1st field is a Text type, call it “Text Time”, with some human-friendly info about current record.

I can imagine that records to your datetime collection are added dynamically (by app users). Then you won’t be able to enter the human-friendly info. However, the workaround could be:

  • you Create new record in this collection - put datetime value to datetime field (from the place you get it)
  • and you also put same datetime value to the “Text Time” field, and you can format it in the way you want.
    If this option isn’t available (you use a form), then you add a 2nd step to Update new record and put a datetime value from DateTime field to a Text Time field.

Hope this was clear.

Best regards, Victor.

1 Like
3

Hi @Victor

Is this what you meant.

image
image1920Ă—2560 252 KB

I updated the record so that when the date/time is added by user, it adds date and time to the text field.

However it hasnt changed on the app though, it still comes up in the weird format

4

Hi @Shohidul,

Interesting. Yes, this is what I’ve meant and it worked for me. Did you try to re-create the form?

Best regards, Victor.

5

Hi @Victor

Thank you! It worked now, I had to recreate the dropdown component

1 Like
6

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.