Hello,
I am working on a Time Tracker app to help me better understand how much time I am spending on various tasks. I added a gallery screen so I can edit entries if needed (e.g. I forgot to log in or log out at the correct time).
Normally this would be pretty straightforward, but all of my categories and subcategories are text-based and I haven't tried to filter a gallery with buttons before, just dropdowns, so I'm kind of stuck.
Here is a snapshot of my list settings for the Categories and Subcategories. These are used in the entry form via cascading dropdowns.
Here is a snapshot of my 'Project Time Spent' SharePoint List where the information from the form is recorded via a Patch formula.
The name of my gallery is "galActivities". Here is the current Items property. The Search box is working fine, but the "ID" has double blue lines. I expect to eventually have thousands of entries so delegation is a concern.
Sort(Filter('Project Time Spent', StartsWith(Description, txtSearchBox.Text)),"ID", Descending)
The button gallery Items formula is:
Table({Tab: "All"}, {Tab:"Admin"}, {Tab: "Mtgs"}, {Tab: "Emps"}, {Tab: "Tools"}, {Tab: "D4G"})
The OnSelect of the button control is:
UpdateContext({varTab: ThisItem.Tab})
Thank you in advance for your help,
Teresa
