# User Access Default to Current Date Field

**URL:** <https://community.glideapps.com/t/user-access-default-to-current-date-field/661>\
**Category:** Ask for Help\
**Created:** [September 27, 2019, 5:33pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661 "2019-09-27T17:33:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\
**Post date:** [September 27, 2019, 5:33pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/1 "2019-09-27T17:33:43Z")

</div>

I’m sure this is a function already available?.. When a user inputs data into a list item (touches that record), I need the current date to post to a viewable non-editable “Action Date” field. Thanks!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 28, 2019, 1:51am UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/2 "2019-09-28T01:51:37Z")

</div>

Yep, just add the Current Date/Time Special Value component and point it to any column you want filled.

---

<div class="post-metadata">

**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\
**Post date:** [September 28, 2019, 4:29pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/3 "2019-09-28T16:29:58Z")

</div>

So if I want to make a table for a separate tab that would summarize how many records were touched by whom by date @Jeff_Hager ? Can you tell I’m a Non-Techie but very dangerous improving biz productivity / profits? 😄

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 28, 2019, 5:12pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/4 "2019-09-28T17:12:19Z")

</div>

Just so I’m sure, you want a hierarchy of date -\> user -\> record count, correct?

---

<div class="post-metadata">

**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\
**Post date:** [September 28, 2019, 5:14pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/5 "2019-09-28T17:14:45Z")

</div>

Exactly @Jeff_Hager Table would consist of date/user/record count  
Thanks for your help!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 28, 2019, 5:33pm UTC](https://community.glideapps.com/t/user-access-default-to-current-date-field/661/6 "2019-09-28T17:33:45Z")

</div>

Something like this should work for you. Just paste it in a new sheet. In my example, D=Date Column and E=Email column

=query(Lessons!A1:L, “select D, E, COUNT(D) where D is not null group by D, E order by D, E”, 1)