Main database is for Projects, 'Projects'.
Other database is for Videos, 'Videos'.
I am trying to display multiple Videos on Project pages, with some of the videos in Video Player format, other videos in Link format.
I have a repeater of Video Player, followed by a repeater of Text Link.
To connect video URL in database to either Video Player or Text Link, I have a boolean field.
I have two datasets, Video Player and Text Link. Firstly, filtered by Project (Projects field of the video is the same as the Projects item dataset). Secondly, filtered by Boolean value (Video player = True, or Video player = False, depending on whether the URL should be used in the Video Player repeater or the Link repeater).
Wix is giving me an error because I am trying to filter two datasets with the same filter (Project same as Projects Item). Why is this happening? Is there a way I can better achieve what I am trying to do?
Here are the dataset's filters for reference. The 'Project' filter on one of these two datasets will throw an error every once in a while and the whole thing will screw up. I don't understand why.