Solved

SharePoint Auto Validation

Posted on 2013-06-20
8
357 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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
 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

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…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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