How to reset dropdown values when page loads

Ask the community
,
1

Hi,

Site name: gkmatsaridis, page: Law Database

In Preview , dataset records populate my table cells nicely. In Live, the table loads blank and it only gets its records when I either click on a Reset (‘reset input values’) button I’ve made to clear the values of my dropdowns or I choose a dropdown value!

https://gemats.wixsite.com/gkmatsaridis/law-database-1

I used the code below as a fix. This partially solves the problem. It makes data load into the table but it makes the right dropdown menu (‘choose tag’) not to function. This dropdown menu is linked to another dataset due to referenced values.

import wixData from ‘wix-data’;
$w.onReady(function () {
$w(“#dataset1”).setFilter( wixData.filter() );
});

How can I fix it please??

Thanks.

2

bump due to updated information.

Anybody please??

3

It’s not clear what you’re asking and the purpose of the code you posted is also unclear. What are you trying to do.
(+if you set a filter or reset a filter by code you should put it inside dataset.onReady() )

4

@jonatandor35 Ok, let’s start with why Preview works and Live doesn’t. Permission are set to anyone and Sandbox synced.

In any case, in order to make Live to work, I need to either press any reset button or choose any value from the various dropdowns (I assume you have the page open).

What I want to achieve is actually very simple and pretty much what I chose to happen in the Editor. User visits the page, page loads with a table full of 450 records, user is able to choose filters from within 4 categorical menus where the last one (‘choose tag’) is linked to a referenced dataset. Table gets filtered. User clicks on Category menu record, moves to another dynamic page, reads extended results.

Sorry for not being quite clear and thanks for your time.

5

@gemats Post your code please.

6

@jonatandor35 Which code? I built the site with the Editor. The only code I used was the one I copied above, to make my dropdowns reset while page loads. Anyway, here it is:

//import wixData from ‘wix-data’; <----- IF I ACTIVATE THIS CODE,
// <----- THEN LIVE PAGE LOADS DATABASE RESULTS CORRECTLY, AS IN PREVIEW, BUT
// >----- NOW #DROPDOWN4 (“CHOOSE TAG”) MENU STOPS FUNCTIONING!
//$w.onReady(function () {
//$w(“#dataset1”).setFilter( wixData.filter() );

// });

export function table1_dataChange(event) {
let count = $w( “#dataset1” ).getTotalCount();
$w( “#text10” ).text = String(count);
}

7

@gemats If you have no code and all the data permissions are correctly set, then it looks like a bug.

8

@jonatandor35 I’m afraid my post does not get proper attention and I can’t tell why.

Did you have the opportunity to visit my actual site/page/editor? Did you read the code I provided twice as well as my comments saying that enabling the code, one of my menus gets disabled?

Finally, if it’s a bug where should I turn to for help/report of the issue?

9

@gemats only Wix personnel can access your editor, not me. I had a look at your live site though, and saw the problem.
It doesn’t look related to the code you posted, so if you did everything right on the editor/database, it might a bug that should be fixed on Wix end.
So you have 2 options:

  1. To contact Wix Support.

  2. Since it may be related to the new rolling improvements, you can post it in the pinned thread at the top of the forum.

10

@jonatandor35 The team in the ‘rolling improvements’ thread fix the bug, as you suggested. Thank you very much.