Automatic date input

Question

Hello,

I have a sharepoint list and what my aim is, is for when the user re-submits their form through my edit form request, then it will input the time and date of their second submission for the same ID

Any help would be appreciated.

Billy

Answer 1

Hi @Billy Morley ,

According to my research and testing, you can set the "Resubmmited date 2" column to the ** Calculated ** type, then enter the following formula in Formula : =TEXT(NOW(),"dd/mm/yyyy hh:mm") , select Modified in the "Insert Column". Please refer to the screenshot below:

Hope it can help you. Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---