Solved

SharePoint Auto Validation

Posted on 2013-06-20
8
324 Views
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.

Thanks
0
Comment
Question by:Jagwarman
  • 4
  • 4
8 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39261913
Hello,

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
0
 

Author Comment

by:Jagwarman
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
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
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.
0
 

Author Comment

by:Jagwarman
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?
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
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?
0
 

Author Comment

by:Jagwarman
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.

Regards
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 39262170
If this has solved your issue, please mark the answer.

cheers, teylyn
0
 

Author Closing Comment

by:Jagwarman
ID: 39262360
thanks teylyn
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

912 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now