topic Re: Set date range picker to default in App Development

Set date range picker to default

kdaniels-obrien — Sat, 16 Nov 2024 03:42:57 GMT

Hi,

I am using the Date Range Picker in my sheets. I would like to set the date range picker to default to today's date... But I would also like to allow users to select different days if they chose to.

So I expect that when the user opens the sheet, all of the data is filtered to today's data. The user can also select another day's worth of data by selecting new days in the date range picker.

Right now, I have set vDefaultDate in my load script to today():

Let vDefaultDate=today();

In the sheet edit mode, I set the date field to =$(vDefaultDate) but it doesn't seem to apply the filter and I can't select another set of days... Can someone help me with this problem? Thanks in advance!

Re: Set date range picker to default

lorenzoconforti — Fri, 27 Dec 2019 18:35:11 GMT

In your Date Picker object under Field, enable Advanced Setup then set Start date and End date to:

=vDefaultDate

It will default to the date you are defining in the script and will allow the user to change it

Re: Set date range picker to default

kdaniels-obrien — Fri, 27 Dec 2019 19:25:07 GMT

Nice, that worked! Thank you

Re: Set date range picker to default

lorenzoconforti — Fri, 27 Dec 2019 19:37:25 GMT

Glad it worked

Please set the thread as solved