Forum Discussion

_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago

Does QuickBase Support An Array Of Dates Field?

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
No RepliesBe the first to reply