Searching dates in Table View

AppSheet AppSheet Q&A
1

I have an app using the new UI. One field is [Date of Birth] and the user is trying to find “01/12/1979” which is in DDMMYYYY format. But to find the record they have to search in MMDDYYYY format as “12/01/1979”. The google sheet is set to UK, the spreadsheet column is set to DDMMYYYY and I get this issue in browser mode and also the 2 app definition views.

Also other people seem to have had other issues

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Searching-dates-using-native-search-box-in-views/m-p/344797

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Search-by-Date-Table-View-UK-format/m-p/248336

Is this resolved or is there a way around it?

2

Using the filters I guess.

You could also add a text VC that is searchable but use a “false” into the show_if with an expression that calculates it with the right format, like this:

TEXT([Date of Birth], "DD/MM/YYYY")
3 Likes
3

I’d initally considered this option, but rejected it because I knew you couldn’t have something both hidden and seachable. So I got around this by putting in the show_if formula as

UserEmail()="me@me.com" 

The only slight issue now is its it’s now looking for dates matching both US (MMDDYYYY) and UK (DDMMYYYY) formats. Now I could turn off searchable for the origional [Data of Brith] column. But I think that could cause problems if they try to use the filter option in a table view.

Client seems happy so that’s all thats important :slightly_smiling_face:

1 Like
4

Yep. Hence the “false” instead of unchecking the field, it works because it sees it as an expression and expressions could return anything :grin: