Solved

SharePoint Auto Validation

Posted on 2013-06-20
8
368 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
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
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
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 (Microsoft MVP / EE MVE) 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
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
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

630 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