Ability to configure the month to display in the date-picker widget

Grist Feedback
1

When using the date-picker widget, the month that is offered is always this month. If I have two columns, Start Date and End Date, it is appropriate that the current month is offered by the date-picker when choosing a date. Now, I may, for example, have to move forward many months to choose the correct start date. That is fine. When choosing the End Date, however, it would be wonderful to have a way of telling it which month I would like displayed when it opens. In this scenario, I’d like the date-picker to display the month that I selected for the Start Date so I can choose an End date that is equal to or greater than the Start Date without having to repeat all the scrolling to get from Today to End Date.

I appreciate that there are other, perhaps quicker ways to enter a date in the distant future than to use the date-picker. Nevertheless, this suggestion is what I believe is called a quality of life enhancement just to reduce a little bit of friction.

2

One idea would be to have a simple trigger formula to set End Date to be equal to the Start Date when the Start Date column is updated. I think that does what you’re asking, though it will override the End Date any time you subsequently change Start Date, which could be annoying.

image
image486×330 18.5 KB

3

I’m frequently amazed at how flexible Grist is. This is a perfect solution because the trigger formula can be written to work so the end date will only be set to the start date if the end date hasn’t already been set.

if value is not None:
return value
return $Start

This will prevent a change to the start date from overriding the end date if the end date is already set.

Thank you so much Nick. I’m happy for this request to be closed

1 Like