topic Automatically have a field date chosen in App Development

Automatically have a field date chosen

roxys373s — Fri, 22 Jul 2022 14:48:14 GMT

So I have this sheet that does daily reports, but whenever I open the sheet, the date is set back to

and I have this setting applied to it:

How can I make it so that when I open the sheet, it will automatically show the latest date (which is always the previous day, so today it would show 7/21/2022)

Re: Automatically have a field date chosen

Or — Fri, 22 Jul 2022 18:16:06 GMT

Click the field's search option (from Selections or a filter), and use something along the lines of:

=batchdate2=date(Max(all batchdate2))

You may need to modify this a bit depending on the formatting and such - it may not need the date() part, or you may need to format it - but you should be able to get it to work so that only the max date is displayed. Once it is, hit "Enter" on your keyboard to select this date. After it is selected in this way, create a bookmark, and make that bookmark your default bookmark for this document. That will always set the batchdate2 field to max(all batchdate2).

Re: Automatically have a field date chosen

roxys373s — Tue, 26 Jul 2022 14:23:54 GMT

How do you make a default bookmark?

Re: Automatically have a field date chosen

Mark_Winter — Tue, 26 Jul 2022 14:46:49 GMT

Right click on it to set it as default