Written on April 6, 2008 at 7:06 am by

SetFieldValue and Calculated Field – Interview Question

Filed under Configuration {13 comments}

Answer of this question I am sure is going to be a surprise for some of you.

The Question is as following.

Can we do a SetFieldValue on a Calculated Field?

Please answer the above poll before going afer the answer part.

Answer of the question is: YES

I know some of you will straight away say this is ridiculous and dismiss the answer as I would have done few days ago.

But the answer is not a straight YES. You can do a set field value provided you fulfil some conditions.

Conditions under which you can use SetFieldValue on a calculated field are as following.

  • There should be a Pick Map defined on that calculated field.
  • There should be a picklist defined on that calculated field

Then a SetFieldValue results in picking of the value which you are trying to set in case if the value doesn’t exist in that picklist then you will get an error.

I hope this post must have resulted in learning something new for you.

Related Questions

neel tagged this post with: Read 39 articles by
  • neel

    No Comments, strange.. I thought this post will raise quite a few eyebrows but it hasn’t :)

    and I wasn’t expecting that many correct answers either … It seems I was the only one who thought this as shocking :)

    Just kidding… but your valuable comments are always welcome

  • NS

    Calculated fields are read only fields…They cannot be edited…

    Neel Can you throw some light on usage of calc fields with picklst with an example

    thnks

  • Sumit

    One question Neel!! Since a calculated field is not based on any column .. what is the use of defining a picklist and a pick map on the calculated field. Do you have any practical example where this situation can arise?

  • neel

    yes, I do.. will be posting it soon

  • Amogh gupta

    Hi plz anyone help me with my query

  • Carlo

    Yes, it’s possible if calculated field has an empty calculated value.

  • http://siebelunleashed.com/calculated-field-and-set-field-value/ Calculated Field and Set Field Value. | Siebel Unleashed

    [...] up with my Previous Post I am back with an example of SetFieldValue on a calculated [...]

  • Jay

    So i happen to fall into a pit of darkness!!!

    And suprised!!!! creating picklist for a calculated field!!! quite intresting but sounds like its not possible. As sumit had mentioned, it (calculated field) cannot be mapped to any lov (or a picklist)!!! am not buying wat you have mentioned here. Pls give us screenshots… May be that will make me not a head strong!!!

  • neel

    If you would have read my follow up post on this you wouldn’t have posted this comment :)

    Here is the link and I have done exactly what you asked for Screen Shots :)

    Hope that will help you not to be a head strong.

    http://siebelunleashed.com/calculated-field-and-set-field-value/

  • Amogh Gupta

    Hi Neel plz help me out , i really need it.
    Iam using a product field in an applet, which uses pick applet.Now when I click that field an empty Order Entry -Line Item Product Pick pops out, and wen I click Go or Cancel button on that applet the correct Order Entry -Line Item Product Pick pops out with all the values populated , so now I want to Remove this empty Pick Applet from in between and get the populated applet Straightaway.Plzz help me in this regard.

  • neel

    Amogh,

    I am not sure if I understand your problem correctly. What you are trying to say is that there are basically 2 pick applets being displayed when you click on pick applet icon ???

    and it will be better if you post your problem in forum instead here as comments as they tend to go unnoticed as everybody doesn’t goes through all the posts so the chances that somebody might answer gets reduced.
    here is the link to the forum
    http://forum.siebelunleashed.com

  • Venkat

    Calculated fields can have BC.SetFieldValue() if calculated field has Picklist and pickmap objects defined for a calculated field. This is mainly used when you have to update conditional read only fields using script(FieldReadOnlyField user propery). Calculated fields drive the FieldReadonlyField user propertly,so if you want update a readonly field you have to make sure calculated field is set to ‘False’ which you can do using setfieldvalue on a calculated field.

  • Gurdeep

    Neel,

    I have performed a Setfield value on the calculated field which has no picklist or a pickmap.
    Surprise, it worked for me.