Filtering data using date picker

Ask the community
,
1

Hi everyone! I am a beginner at using wixcode and trying to set up a website for my residency’s schedule. My database has a “date” field and then a column for each role. The rows have the residents assigned to each role. I’m trying to accomplish the following:

  1. Use date picker to allow users to select a date and see which resident is assigned to each role
  2. Default to display today’s values

I would really appreciate any help. I’ve been trying to figure it out myself for days but am getting nowhere.

Thank you!!!

1920×987 318 KB

2

@Hopkins - would you mind sharing the code you currently have so we can take a look?

Tiaan

3

I actually don’t have any code yet. I can’t figure out how to write it :frowning: Please help!!

4

Hi,
In order to get the record for a selected date you can use query, check it out here .
You can get the current date using Date() and then get the records with another query.

Good luck :slight_smile: