I have a view that starts as a gallery view pulled from a dates column. I would like for the view to not have any duplicates. Currently if I have 3 appointments for 12/09/2019 then it shows up 3 times in the Gallery. Is this possible?
Thanks
Foster
Try creating a slice using https://help.appsheet.com/en/articles/3416532-unique and then point your gallery view at the slice
Thank you 1minManager. I still need a little help though. If I put the expression โUNIQUE(Tyson Test[Appointment Date])โ in the โRow filter conditionโ in my slice it get The expression is valid but its result type โListโ is not one of the expected types: Yes/No".
Tyson Test is the name of my table. Appointment Date is the name of the column.
I appreciate any help in figuring this out.
Thanks
What do you want to happen when the user clicks on an item in the gallery?
go to a list view of all the appointments under that date.
I donโt see a good easy way to do what you want to do. @LeventK, do you have any ideas?
Thnx @SteveโฆActually I donโt have any idea but though @Foster_Leeโs request is quite reasonable, on the contrary itโs not logical as well. Because though the dates might be repetitive, as per AppSheetโs logic, they are associated with separate Detail Views. Provided we think a way to list them only once, then how AppSheet will now which Detail View to show when selected? On the other hand, Gallery View has minimum data to dispay: an image and a description text only. It might be more beneficial to use a Deck View I believe. As you can have more things to do in a single day, my preference will be using a Deck View and somehow display all the related ToDoโs for that particular date in a nested table under any Deck View item for example.
You should add another column in which you record if the appointment is the first appointment for each day and use that to slice your table.
Or create a slice with the expression: MINROW("Tyson Test","Appointment Date")
With this you will have only the first row for each date.
Use this slice as the data source for your gallery view.
Then create an Action โApp: Go to another view within this Appโ with a deep link LINKTOFILTEREDVIEW() to open a list view of all the appointments under that date.
Attach this Action to the โEvent Actions Form savedโ in your Gallery view.
Beautiful!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |