Does QuickBase Support An Array Of Dates Field?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Doesn't Need an Answer
  • (Edited)
Does QuickBase Support An Array Of Dates Field?

Yes of course it does through script. In the same fashion that the Chessboard Field worked you can use a text field to store some type of data structure such as a list of dates and maintain its state through edits and views using script.

Here is the Chessboard Field example where the entire chessboard position was stored in a multiline text field:

Chessboard Field ~ Edit Record
https://haversineconsulting.quickbase.com/db/bmpbjbbxx?a=er&rid=2

Here is a new demo where an array of dates is saved in text field although the selection of the dates is done through a calendar widget:

Date List Field ~ Edit Record
https://haversineconsulting.quickbase.com/db/bmpewercv?a=er&rid=1

Note that you can only select upto four dates - that is just a random option I selected to highlight one aspect of the library I am using - it is not a limitation of the library or the technique I am demonstrating:

jQuery Datepicker
http://keith-wood.name/datepick.html

You will notice that the calendar does not display properly although the demo does work as advertised from a data perspective. There is some weird CSS issue that I have not fully debugged but I have run out the amount of time that I wanted to spend on this demo. This occasionally happens when embedding libraries within QuickBase pages. If there is a production need for this feature I would put the additional time into fully debugging it. For now this is what you get.

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=572
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,994 Points 20k badge 2x thumb

Posted 2 years ago

  • 0
  • 1

Be the first to post a reply!