[image] We now have ranges for date picker & date time picker. It still renders a calendar, but dates outside of the range are not clickable.

Hallelujah!!! Mark this one as done! [image] Filter on Date Picker Feature Requests Would be nice to have a filter on date and date/time picker. Users would still SEE dates, but they’d be unclickable given the filter. eg. Filter date picker where date is on or after today = users couldn’t select a date in the past.

A useful extension to this would be to allow for a column value to be used in the range options, instead of just the fixed values that we have now. For example: I might want to allow a date in the future, but no more than one month in the future. I could have a math column that calculates now+1 month, and then use that column as the upper range limit for the date picker.

Hi Darren, But how can I do if let say the Start Date is 20 Oct 2021. I want the End Date can be selected from the Start Date and later ?

You can’t do that with the date picker options, but you could apply some logic in the GDE to force it. Using your example, you could create an if-then-else column: If end date is before Start Date then Start Date Else end date Then use the value of this if-then-else column as your end date filter. This wouldn’t stop a user from selecting an end date earlier than the Start Date, but if they do it will automatically be adjusted to that date.

Of course, I thought about displaying a warning message to user using this trick but I think it would be more comfortable for app builders to have also the opportunity to choose a custom date instead of ‘today’ directly in the range option of the date picker and actually force the user to select an end date after the start date. Because I can’t display a warning because the data row is not created yet when it is in an add form (or tell me how if I can).

You can do that with a custom form. [image] How do I create a custom form? FAQ I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

🆕 Date ranges for date picker & date time picker

Ask for Help

ThinhDinh December 8, 2021, 11:27pm 10

You can do that with a custom form.

Topic		Replies	Views
Date filter for calendar view with ability of picking a date Feature Requests	6	1603	January 10, 2021
How to block date Ask for Help	2	337	October 14, 2022
Date picker - start after specific date Feature Requests	0	118	December 7, 2023
Datepicker question Ask for Help	16	367	November 22, 2023
Filter on Date Picker Feature Requests	3	981	August 13, 2021

🆕 Date ranges for date picker & date time picker

Related topics