Solved

SharePoint Auto Validation

Posted on 2013-06-20
8
337 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to sync from Onedrive 4 46
DataTabe not rendering correctly... 2 50
Moving SharePoint 3.0 role to differen server 7 62
Masterpage unexpected error 7 27
I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 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