Hi
I added a drop down list to my form, and when I try to use it, I see blank lines instead of the items I added.
Any help would be great!
Important forum update
This forum is migrating to one unified Wix community forum starting July 26th, and will be read-only during the process.
Wishlist Page is the official platform for requesting new features. You can vote, comment, and track the status of the requested features.
Hi,
The date picker returns a date object that always represents midnight.
Using equals() to find records that were created on the same day will not work, since it looks for records that were created exactly on midnight (with millisecond precision).
Therefore in order to execute the filter command correctly you should search for records that were created during that day (between 00:00 and 23:59 of that same day) using the between() function
See the example below:
export function datePicker1_change(event) { const dayInMsMinusOne = (1000 * 60 * 60 * 24) - 1; const dateOne = event.target.value; // (always midnight) const dateTwo = new Date(dateOne.getTime() + dayInMsMinusOne); //midnight plus midnight of the next day minus one millisecond $w('#dataset1').setFilter(wixData.filter() .between('_updatedDate', dateOne, dateTwo) ); }
I have the code below and it doesn't work:
export function datePicker1_change() { $w('#dataset1').setFilter(wixData.filter() .eq('fechaDeIngreso', $w('#datePicker1').value)); }
My table just won't populate after selecting a date.
Help please. :(
Hi,
Welcome to the Wix Code forums.
How are you adding the dropdown items? Please show your code and dropdown settings.
Yisrael