If Then column brings edited values

[Lucas_Pires]

I’d really like to when If Then column brings me the value edited as we already did in Data, and not like this

Cause my intention is to display it in a Tiles Details but…

[Jeff_Hager]

Related to this.

In-app filter with dates shows dates in ugly format

Hello everyone, I have an app where I use in-app filter with dates, but it shows dates in a very ugly way. [Captura de pantalla 2020-05-10 a las 0.22.38] In data builder I have configures how to visualize dates, but it seems to me that this does not affect to in-app filter… [Captura de pantalla 2020-05-10 a las 0.27.34] Is there a way to change that? Thank you!

[Lucas_Pires]

So, is it a bug yet?

[Jeff_Hager]

I don’t know. Haven’t seen anything saying it’s fixed. Might be a new bug.

[Paco_Nunez]

A week ago, I received official confirmation - yes, it’s a bug

[Lucas_Pires]

Yeah

@Mark any update?

[Lucas_Pires]

Doing my own To-do app

[gvalero]

Hi,

Did you try to fix it via Google sheet??

I saw it days ago but I modified the column format as workaround and worked for me.

Saludos Lucas

[Lucas_Pires]

I can’t @gvalero, ‘cause, as @Jeff_Hager mentioned here up, it’s a bug.

In the sheets, the value isn’t a “date” format, it’s an ugly one with time zone and so… that’s why formatting doesn’t work

In-app filter with dates shows dates in ugly format

Hello everyone, I have an app where I use in-app filter with dates, but it shows dates in a very ugly way. [Captura de pantalla 2020-05-10 a las 0.22.38] In data builder I have configures how to visualize dates, but it seems to me that this does not affect to in-app filter… [Captura de pantalla 2020-05-10 a las 0.27.34] Is there a way to change that? Thank you!

[Jeff_Hager]

The date should be recognized by google as a date. You can try setting the column formatting in the spreadsheet. If for some reason google sheets doesn’t see it as a date (such is the case in app: logins) then you can use a formula to rebuild it as a date in a new column.

Date formatting

I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY")

[Mark]

Sorry, we’ll fix this in due time.