set a filter from a different page

Ask the community
,
6

@givemeawhisky ah i see what you mean. Thanks for the idea bu the multiple dropdowns could get confusing as i want the user to be able to reuse the dropdown if needed. I will leave it as it is and going to connect them to just text. As it is searching the database, it needs to be in a user input text box, or can i query or ‘search’ the table without having a user input.
I’ve written a bunch of code for different ways and am confusing myself now.

i tried using user input textbox. This is like a search bar. The problem is i am trying to connect all the buttons on page 1 to the same user input element on page 2. So that doesn’t work.

I now am trying to query the table and the database its connected to by using hidden textboxes on the page e.g. africa, asia… Then the table will automtically filter the table depending on the button clicked in page 1. I like this more but i am finding it difficult. I have done this so far:

 $w.onReady(function () {
 
 const africatext = session.getItem('Africa');
  
 return wixData.query ('#dataset1').setFilter(wixData.filter()
    .find('africatext')
    .then( (result) => {
      $w("#table1").expand();
    } )
    );

it’s not working but i like this idea more!