disabledDates in DatePicker from database? [WORKS]

Ask the community
,
1

Hi

Is there a way to disable dates in Datepicker from a new database?

I mean is there an easy way to set disabled dates other than this code?:
let badDate1 = new Date(2017, 0, 13);
let badDate2 = new Date(2017, 9, 13);

$w(" #myDatePicker ").disabledDates = [badDate1, badDate2];

2

What’s wrong with this code?

3

nothing wrong.
but i want an ease way to set multi dates that i have on my database.
this code allow me to enter disable only by edit the code.
i want to option to choose / set disabled dates from my manager form.

4

You don’t need to change the code every time.
Modify the code so it’ll query the database for disabled dates and automatically assign them to the date-picker as disabled dates.

5

ok
so i can i do it?

6

Have an “isDisabled” field in your collection.
Make it Boolean (true if disabled, empty if enabled).
Have another field with the date (hereafter: “date”).
Then query your collection:

import wixData from 'wix-data';
wixData.query("CollectionName")
.eq("isDisabled", true)
.limit(1000)
.find()
.then((res) => {
    let items = res.items;
    if (items.length > 0) {
        let disabledDates =[];
        items.forEach(e => {
            disabledDates.push(e.date);
    })
        $w("#datepicker1").disabledDates   = disabledDates;
        }
    })
7

It’s works!
Thank you J.D :slight_smile:

8

You’re welcome :slight_smile:

9

Hi there! Can I have the exact format that indicates the date in the field you mentioned (Have another field with the date (hereafter: “date”).)? I’m new to this matter. Thank you.

10

@basilicamanaoag I’m not sure I understand your question.
Please open a new post , and add details to your question.