Hi, I’d like to create a dropdown list sort of _createdDate. Can you please help me to verify the code? $w.onReady(function () { uniqueDropDown1(); }); function uniqueDropDown1 (){ wixData.query("All_Votes").descending("_createdDate") .contains("_createdDate", $w("#datePicker2").v…

@jankucera I think i see the problem :smiley: $w.onReady(function () { uniqueDropDown1(); }); function uniqueDropDown1 (){ wixData.query("All_Votes").descending("_createdDate") .contains("_createdDate", $w("#datePicker2").value) .limit(1000) .find() .then(result…

so: $w("#datePicker2").value = buildOptions(uniqueTitles); i think it should be $w("#yourDropdown").options= buildOptions(uniqueTitles);

@volkaertskristof unfortunately, this use case works for non system value (like title) , but not works for system collection record (field): _createdDate…:frowning: here is a code: import wixData from 'wix-data'; $w.onReady(function () { uniqueDropDown1(); }); //----------------------------…

@jankucera This function works for the table, but I’d like to but the result of created date to dropdown menu. User can select from dropdown list specific date! Is it feasible? As you already mentioned it. If it works in tables, why not use the table to select your wished VALUE? :wink: (using ta…

Hi, any idea hot to show the dates in dropdown menu? It seems that only string can be in dropdown menu. What do you think?

@jankucera try it like this .then(results=>{ console.log(results) getUniqueTitles(results.items) .Then(res=>{ $w("#dropdown1").options =buildOptions(res);}); }) And maybe change this aswel return{label:curr, value:curr}; To return{label:curr.toString(), value:curr.toString()};

Try the second part after you tried the first part.

@volkaertskristof unfortunately it doesn’t works wixData.query(“All_Votes”) .ge(“_createdDate”, $w(“#dropdown1”).value) .limit(1000) .find() .then(results => { console.log (results) getUniqueTitles(results.items) .than (res=> { $w("#dropdown1").options = buildOptions(res);}); …

Did you also tried the part to adding to it?

[SOLVED] Search a database based on date: _createdDate

Ask the community

jankucera February 18, 2021, 3:39pm 15

@russian-dima The reason why I need to have the date in dropdown menu is that I want to sort of the meetings based on date or month.

Topic		Replies	Views
[SOLVED] Search a database based on date: _createdDate Ask the community code , question	0	77	March 4, 2021
Changing the order of dropdown items in list connected to CMS Ask the community code , cms , wix , question	7	674	December 19, 2024
Create a default filter value Ask the community code , cms , wix , question	15	120	July 22, 2024
How to Create a Search for Your Database Show and tell code , tips	110	41915	May 8, 2020
Remove duplicates from connected dropdown options Show and tell code , wix-members-area , tips	50	11012	April 3, 2020

[SOLVED] Search a database based on date: _createdDate

Related topics