SharePoint Auto Validation

Posted on 2013-06-20
Medium Priority
Last Modified: 2013-06-20
In Excel I can build a checkbox that when checked will automatically populate cells with the user name and time. Is it possivle to do the same in SharePoint and if yes can someone provide me with the code and procedure of how to do it.

Question by:Jagwarman
  • 4
  • 4
LVL 50
ID: 39261913

SharePoint already records the modified date/time and the person who modified an item in the ModifiedBy field.

You can use these fields to keep track of who last modified an item in a list or a library.

If you want to keep track of the time and user who changed a particular field in an item, this will require a much more complex approach.

Please provide some more detail on what you want to accomplish.

cheers, teylyn

Author Comment

ID: 39262004
Hi teylyn,

The user [Manager] wants it so that when someone inputs a new item they tick a box and their name is then automatically displayed. He also wants it so that the inputters name remains with the item so that whenever anyone opens it, they can see who input it.

Is that possible
LVL 50
ID: 39262034
It depends on the context. If the item is a list item in a SharePoint list or library, then yes, that is automatically captured.

SharePoint captures the author and date stamp of when an item was created, and it also captures the name and date stamp of the last modification.

I'm not sure where ticking a box comes in.

What are we dealing with here? Is it a SharePoint list? Are we talking about items in a list and who/when they were created and modified (by)?

Or is it more complex? You really need to provide more detail.
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Author Comment

ID: 39262055
It's a list. The list contains various fields from Date to text to choice etc.

When the user goes in to enter a 'New Item' they fill in all of the relevant boxes. Although SharePoint captures the author and date stamp of when an item was created, and it also captures the name and date stamp of the last modification, The User wants the initial user name to be automatically created in the Input form and not for the user to enter their details manually or from a drop down box.

I am not sure how more specific I can be. Maybe my question is:

Can I create a [column] field that will take the information from the name and date stamp that Sharepoint captures?
LVL 50
ID: 39262075
You don't need to create any fields. SharePoint automatically captures four pieces of information for each list item

Created (date/time)
Created By (original author)

Modified (date/time)
Modified By (user who changed the item)

If this is not what you need, can you explain what you would like instead?

Author Comment

ID: 39262133
Ah ha, I thought that the original created by disapears when modified but it doesn't.

Thanks and sorry for wasting your time on this one. I am sure I will have lots more questions for you as I am a newby to SharePoint.

LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 39262170
If this has solved your issue, please mark the answer.

cheers, teylyn

Author Closing Comment

ID: 39262360
thanks teylyn

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question