Hey Appsheet community!
Iโm attempting to create a slice that filters out rows to only include a specific โDate.โ
Setup:
2 Tables.
Table 1: Titled Meeting_Topics (Key = Topic name, has a column titled โdatesโ that has a list of dates inside of it. (i.e. โ2/23/2020 12:00:00 AM,2/24/2020 12:00:00 AMโ))
Table 2: Is a form that references Table 1 as an enum.
Goal: Create a slice to filter to only show the โtopic nameโ that contains todayโs date in the โDateโ Column.
Current setup that doesnโt work: in the Slice Row filter condition, i have, โCONTAINS([Date], Today())โ .
When I test it, it has a โYโ next to the correct topics. But when I look at the slice as a Table view or as a reference in the table 2 form, it shows up as blank.
Thanks for your help!
What does that mean?
Perhaps IN(DATETIME(TODAY()), SPLIT([Date], ","))
?
What does that mean?
Sorry for the confusion.
What I meant to say that I am using table 2 as a form. One of the columns in that form is referencing table 1. That column is as an โenumโ type.
That Expression works the same way as the other one I tried. When tested, it gives a โYโ next to the correct Meeting Topic, but when in I view it as a table view, nothing shows up.
I meant to say that in the table 2 form that has a column that references Table 1, it doesnโt show any results. This column is โenumโ type.
Thanks for your help Steve!
I think some screenshots might help. Please post screenshots of:
The Type Detail section of the Enum column in table 2.
The slice configuration.
The configuration of the table view that uses the slice.
Does this help?
Hmmโฆ Nothing looks amiss. How about a screenshot of the table view in the app that doesnโt show what you want?
But here is what shows up in the Slice Expression Editor when I hit โTestโ
This going to require a bit more digging, it appears. I recommend you engage support@appsheet.com directly, as theyโll be able to access your app directly, which will make troubleshooting a lot quicker.
Bummer. Alright. Thank you Steve!
Out of curiosity, do you need to be using DateTime values in the Dates column? It might be easier to solve without the time values altogether. I mean, either way, this is probably a bug that needs fixing.
I tried without the dates, but I wanted to use the โToday()โ expressions (or syntax? idk lol) and it outputted a time โ12:00:00 AMโ and in the expression tester, it wouldnโt match unless I also put the time in the column. Am I doing something wrong? Because from what I read, the โToday()โ isnโt supposed to spit out a time. Thanks for your help!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |