Using a single DataMaster for all DataLists

Josh2876 shared this question 2 years ago
Answered

Hi. I currently have multiple DataMasters feeding multiple Datalists in my app. I am wondering whether it is possible to create one big Datamaster that all my Datalists can feed from?


In this "Master" database I would have a column called "Data Type" and then tag each row with a keywords to distinguish the data points - "User" "Article" "Comment" etc.


When I run a search in e.g, my "Users" screen, the list would only search through and display rows that have the word "User" in the Data Type column in the Database. All rows tagged with "Article" would be omitted from the search.


Is this possible?

Comments (5)

photo
1

Hi there,


That's possible, you'll just need to edit the specific Data Lists on each page to only include the desired data.


Best,


Danielle

photo
1

Hi Danielle. To my understanding, the Datalist will only let you select which COLUMNS of Datamaster information you want to include in it, not which ROWS. I want to disclude certain rows of Datamaster info from the Datalist results (Rows in the Datamaster tagged with certain keywords. Is this possible?

photo
1

Hi Danielle. Any thoughts on this. Still isn't quite resolved

photo
1

Yes this is possible - create an On Page Load -> set value event with the calculated outcome to filter the data master by the keyword. The expression will look like Filter [Data Master, Attribute (the desired keyword)]

photo
1

Thanks a lot Danielle. Will give it a try