# Display Last Modified Date and By

**URL:** https://forums.knack.com/t/display-last-modified-date-and-by/15774
**Category:** Feature Requests
**Created:** [February 26, 2024, 4:28pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774 "2024-02-26T16:28:09Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 4:28pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/1 "2024-02-26T16:28:09Z")

</div>

Is there a way to display Last Modified Date and Last Modified by on a grid?

---

<div class="post-metadata">

### Author: ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)
#### Post date: [February 26, 2024, 6:38pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/2 "2024-02-26T18:38:36Z")

</div>

Good question! [This article](https://learn.knack.com/article/n0ynrptj6m-create-a-version-history-for-records) may come of use to you depending on your set up and needs.

Good luck and happy building!

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 6:52pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/3 "2024-02-26T18:52:25Z")

</div>

The problem with this is when you ask a user to log in to a single page every time they need to add or edit to a record that is not feasible. Knack needs to step up to the plate and give us builders some of these things that are critical

Ed Cooper

---

<div class="post-metadata">

### Author: ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)
#### Post date: [February 26, 2024, 8:27pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/4 "2024-02-26T20:27:56Z")

</div>

Ed

This is quite easy to do.

Create fields for Last Modified Date and Last Modified by and then use submit rules to capture this information.

Dean

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 8:48pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/5 "2024-02-26T20:48:44Z")

</div>

I’ve got the Last Modified Date working fine.  
However, the documentation says for Last Modified By it requires a login to the page where it will be displayed on the grid.  
I can’t ask my users to log into a page every time they need to update a record. Makes no sense.  
I wrote to Knack and told them this but they have no answer.  
Just like when are some of the feature requests going to be pushed out.  
Basic things builders have been asking for for a long time like and/or filters.  
No roadmap that I can see.

---

<div class="post-metadata">

### Author: ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)
#### Post date: [February 26, 2024, 9:11pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/6 "2024-02-26T21:11:51Z")

</div>

Ed

Sorry, we use Record Rules not Submit Rules.

The users only need to login to your app once and Knack will capture the logged-in Account.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/8791bb8d44ba80e828bb4fc6266af8eca46460f6.png)

Dean

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 9:24pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/7 "2024-02-26T21:24:28Z")

</div>

Mmm  
Contrary to the documentation but I’ll try.

Ed Cooper

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 9:43pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/8 "2024-02-26T21:43:16Z")

</div>

I don’t see this option “to the logged in accounts”  
 ![](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/220b9f0548b2399f7019ace02c3e6e7942d0fcde.png)

---

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [February 26, 2024, 9:53pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/9 "2024-02-26T21:53:11Z")

</div>

Hi ed  
If a user isn’t logged in how can Knack know who edits or adds.

Craig

---

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [February 26, 2024, 10:03pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/10 "2024-02-26T22:03:20Z")

</div>

Hi sorry another question

If you don’t have a login that means that anybody can change data in your database does that mean that anybody can see the data as well?

If you want to record who updates a record they must be logged in. I apologise if I’ve missed something but I don’t really understand how you expect Knack to figure it out.

Craig

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:08pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/11 "2024-02-26T22:08:41Z")

</div>

The user is logged into the app.  
The documentation indicated the user must be logged into the page.  
I don’t get it.  
Dean2 sent an image in prior email but when I go into Record Rules I don’t see what his image shows.

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:11pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/12 "2024-02-26T22:11:28Z")

</div>

It would be valuable if someone from Knack or the community could jump on a Zoom session and help me with this.  
The email threads on this are very confusing.

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:16pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/13 "2024-02-26T22:16:15Z")

</div>

All my users are internal employees maintaining a CRM.  
They log in with their creds to access the CRM app.  
Isn’t that logging in?  
None of the individual pages are password protected.  
Anyone who logs in can access the CRM app.

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:17pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/14 "2024-02-26T22:17:21Z")

</div>

and edit records

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:31pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/15 "2024-02-26T22:31:23Z")

</div>

However, the documentation says for Last Modified By it requires a login **to the page** where it will be displayed on the grid.

---

<div class="post-metadata">

### Author: ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)
#### Post date: [February 26, 2024, 10:33pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/16 "2024-02-26T22:33:53Z")

</div>

Hi Ed,

Our support team would be able to take a look at your app’s setup and share info on how you can accomplish this workflow in your app. If you haven’t already and you would like this, you can reach out to them [via this form here](https://www.knack.com/contact-support/). Being able to view your app can help remove the confusion and prevents guessing/blindly providing advice that we’re not quite sure will work with your current setup.

You can also [schedule office hours time](https://pages.knack.com/office-hours) with our onboarding team to discuss features available to accomplish your goals as well.

Sorry for the confusion this has caused you, and thank you @CSWinnall for the help here! 🙂

---

<div class="post-metadata">

### Author: ![EdCooper15510](https://avatars.discourse-cdn.com/v4/letter/e/9de053/32.png) [@EdCooper15510](https://forums.knack.com/u/EdCooper15510)
#### Post date: [February 26, 2024, 10:34pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/17 "2024-02-26T22:34:18Z")

</div>

### Requirements

The following are the requirements for implementing this workflow:

- Your database includes a table that stores records that you want your users to be able to update. In this example, these records are referred to as leads.

- Your app has **[user logins activated](https://learn.knack.com/article/o7zqrvduj7-about-users)**. The settings allow you to have logins for different user roles.

- You have a page **[protected with a login](https://learn.knack.com/article/iqyr40dmbz-logins-and-registrations)** for your users to log in and access.

- Your page has a **[form](https://learn.knack.com/article/m4py8btnyh-forms)** that either adds or edits a record.

So, you would need a page protected with a login for this workflow to work. I am sorry if this causes any hassle.

---

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [February 26, 2024, 11:04pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/18 "2024-02-26T23:04:47Z")

</div>

Hi Ed

As soon as the user is logged in then you are good to go.

When you click in the drop-down where the arrow is pointing to what do you see?

Craig

---

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [February 26, 2024, 11:10pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/19 "2024-02-26T23:10:06Z")

</div>

You should see these options

 ![Screenshot_2024-02-26-23-09-05-747-edit_com.android.chrome](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/eb5d2054d22503a6cc007e1895202393e5dea4ea.jpeg)

Craig

---

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [February 26, 2024, 11:16pm UTC](https://forums.knack.com/t/display-last-modified-date-and-by/15774/20 "2024-02-26T23:16:55Z")

</div>

The edit form only needs to be a descendent of a login page so as long as they have logged in at some point previous to the edit page and you are updating a connection to an account in the record rules you should see this option.

If you are still not seeing it then either contact Knack Support or I’ll be more than happy to set up a zoom tomorrow and take a look with you.

Craig

[Next page](https://forums.knack.com/t/display-last-modified-date-and-by/15774.md?page=2)
