Rule using value in a calculated field

[Gerard Graham]

Hi there

I’d like to use the value of a calculated field when deciding if a rule should run or not., but I see the calculated fields are not listed in the If this trigger drop down. I also tried to see if I could set a field to the value of a calculated field on load, but I get the name of the field instead of its value (e.g. {repStatus} is the set value)

Any suggestions please?

Thanks

Gerry

[Alexander Bautz]

Hi,
Calculated columns are available in DispForm only. This is not a DFFS issue, but how calculated columns work in SP.

You can however make this work if you use the trigger “Custom JavaScript function”, and use a query to get the value from the calculated column.

Here is an example of getting the calculated column value:

function getCalculatedColumnValue(){
	var r = false, v = "", qRes = spjs.utility.getItemByID(
		{
			"listName":_spPageContextInfo.pageListId,
			"id":spjs.dffs.data.thisItemID,
			"viewFields":["YourCalculatedColumn"]
		}
	);
	if(qRes !== null){
		v = qRes["YourCalculatedColumn"].split(";#")[0];
	}
	if(v === "The value you want to compare with"){
		r = true;
	}
	return r;
}

This code is written “free-hand” and not tested, but it should work.

Alexander

[Author]

Posts