I’m trying to filter a table using a dropdown. The field in the table I’m trying to filter is a a reference field to another table. I thought I fixed it by having two datasets to the look up table (one to be used in the dropdown; and one to be used to filter off of; which I then linked to the table 's dataset)
It works when I choose a value in the dropdown, but the table won’t load initially anymore (it did work, and then I came back and it wasn’t loading anymore); It seems to be related to the filter I am setting on the table set that connects to another dataset.
Sorry if I didn’t explain this well. The link to the page I’m having difficulties with is: https://syverts2.wixsite.com/mysite/lookup-roster
The Members dataset is connected to the Universities dataset and the Universities dataset starts with a university that has no members.
Try creating at least one member item for each university and it will help you understand how data is filtered by the different datasets on the page.
Thanks Shay, I guess that I may be out of my league with what I am trying to do.
On-load, aren’t all the dataset filters cleared? Or is there a way to do this?
Also, my drop-down used to work, and now there isn’t any values shown. I thought that the drop-down’s dataset mode needed to be write-only? The values show when I set the mode as read-write, but then it won’t show the Placeholder text.
Ideally I want to have the drop down show the place holder text (value of null so that all filters are cleared), and then filter the members dataset when I select a university.
Christine