dates as drop down

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

Is there an option to show dates as the drop down in a date field? 

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
You could show dates as a drop down if you made a table where you list your dates, and link the date field to that Parent table.  Ie it would be similar to any other relationship where you are choosing a parent record.  This might be appropriate of you wanted, say, to only list Sundays for each week and were only offered good choices which were recently in the last of day several months ahead.  Perhaps a Project "Week of" start date, for example.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. Alternatively, is it possible to show a calender of dates using calendar report.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Dan Diebolt knows how to show a calendar but only allow Sunday's, for example, to be selected.  I think he posted an example once in this forum.  It uses his IOL technique
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,604 Points 20k badge 2x thumb
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks.  This is a great solution.  But i will need some help from you as to how to implement this.  I can see a function in your app.  Does that go to a page? Some steps  will be quite helpful.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Mark, I might just set up the separate table.  I did not quite understand your following point.  Kindly elaborate on this.

This might be appropriate of you wanted, say, to only list Sundays for each week and were only offered good choices which were recently in the last of day several months ahead.  Perhaps a Project "Week of" start date, for example.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Right, so this is pretty low tech.

Use Excel to create say 5 years worth of the valid dates for your drop down.  For example every Sunday for the next 5 years.

Create a table called Project Start Dates pl

(I feel that a good practice for pick list tables that do nothing except be a Pick List to suffix the table name with pl)

Set the Key field of that Table to be the Date field that might be called [Sunday] or [Date].

Then make a relationship between projects such that 1 Sunday has many Project Start dates.

Create a Report to limit the choices to a reasonable time frame.  For example no new Project is likely to start more than say 3 weeks in the past or perhaps more than 1 year in the future.  Set that report to be used in the form to offer up the dates instead of the default record picker which will, of course, offer up all days.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks a lot for your kind help.