So I have a dataset with links to create a Direct Debit with a payment system (GoCardless). for multiple products.
Now I have a separate dynamic pages set up with how often the payments to be taken (1 week..22.214.171.124.6...) this dataset has a connections to store . Im wanting to make a link to these pages. But getting the ID to then filter and if null hide elements else show, seems to be very difficult...
What I need to do is apply a filter to #dataset1, column product ref = with the product ID of the product shown on product page.
If the dataset results show >0 it will then expand the #columstrip9 which will have the process on maybe some more selling points etc! but if the dataset show null then this will be kept collapsed.
If you could give me so direction on
1. how to get the products id from #productPage1
2. how to take that and filter the #dataset1.
3. then how to show #columnstrip9 if results >0 else collapse.