I have a list with multiple columns.
This list may include multiple records. I want the value of a specific field to be changed when a special record is read for the first time.
I have a list with multiple columns.
This list may include multiple records. I want the value of a specific field to be changed when a special record is read for the first time.
You could edit the DispForm of the list item and in it have a delegatecontrol (or some other custom control) to count how many times the page has been loaded by unique user id's other than the authors id.
Update
Create a new user/web/delegate control and insert the following code:
var web = SPContext.Current.Site.OpenWeb();
var list = web.Lists["Name of the list"];
var itemId = Page.Request.QueryString["ID"];
var item = list.Items.Cast<SPListItem>().FirstOrDefault(i => i.ID.Equals(itemId));
var isRead = (bool)item["Internal name of the column"];
if(!isRead)
{
item["Internal name of the column"] = true;
item.Update();
}
This should pretty much do the job of updating the items column stating if it's read or not.
You can set the default value for the field in list....
There are several solutions: