Hi folks,
I am having trouble creating a formula to navigate to a page and then view any open records.
There are two fields I am trying to filter from - Address and Open.
Address is name of a site and Open is the status of a ticket.
I have a home page where the user would choose a button to view all open records for a certain site.
The name of the sharepoint list is contacts.
The filters work separately, but I can't get them to work together.
Here are the two filters: (in Items)
Filter (Contacts, address = Dropdown1.Selected.Value)
Filter('Contacts', Open = "Open")
Is there a way to create one formulate so a user would select a site from the drop down, press a button to navigate to a page that includes a list filtered by the address and open fields?
