Setting field permissions in a sharepoint datasheet 1

[Rob37]

Hi all,

I'm trying to create a datasheet in sharepoint which will display all columns as read-only except for one field which will be editable.

Does anyone know if that's possible??

Many thanks
Rob

 

[Beowulf005]

Not is datasheet view.

However you could create a custome list in standard view and create all the "read-only" columns as calacated fields. When the user clicks on new item they will only have the ability to enter the one editable field. Someone could have a personal view of the datasheet view to export to excel.

Or you can create a link list in excel where you can lockdown any field you want.

HTH

Brian

 

[Rob37]

Brian, thanks for that.

One further question...I created the list but now need to populate all columns as part of a start-of-day process(including the read-only ones).

Best Regards,
Rob

 

[Beowulf005]

What are the columns getting populated with? I am not sure were you are going with you question.

 

[Rob37]

I've now sussed out how to create the linked list in Excel and publish it to Sharepoint as you suggested. The problem is that if I lock any of the columns in Excel, I can't create / publish the list to Sharepoint.

I tried using calculated formulas in Sharepoint but couldn't get this to work either.

 

[Beowulf005]

Can you give an example of you end goal. What is the one editable field(Type and define) that you are creating and what are the calculations based on that field?

 

[Rob37]

The end goal is a payments log displaying:

- Date payment received
- Payment no.
- Payee
- Currency
- Amount
- Who is responsible for actioning the payment

A single administrator will receive payments off a fax machine and enter them into the log. Users will view the log and tick off the ones that they are responsible for actioning.

 

[Beowulf005]

Ok there is one way to do this hopfully I can make it clear and you have the programs.

First the admin must have Infopath. Create a new form with the following data fields
- Date payment received
- Payment no.
- Payee
- Currency
- Amount

Publish it to a sharepoint form libary.

In the form libary add a column for "Who is reponsible"

Go to permissions and make user only able to edit items, (Remove the ability to add items, and remove manage views)

Got to views and within each view remove all execpt for the above fields and who.

Create a default view of datasheet view and again make sure to only have the above fields.

Now that this does is that the admin will have the infopath form and can add items to the list. When the items are displayed in the list users will not be able to change the contents of the cell, (only way to do that is to open the infopath form which they will not have installed on their computer or you remove the links from the views) And have the one added field of "Who" the user will be able to change it from the datasheet view.

This is not a fullproof solution but its the closest I can get. It took me about 1/2 hour to setup on a test machine.

Good Luck
Brian

 

[Rob37]

nice one.

Just got this up and running,

Thanks for your help,
Rob