Real Life Example: Using Social Software To Reach Customers (Blogs). >>Subject: [siebel-dev-l] Script to set Field on Update >>Date: Tue, 03 Oct 2006 17:31:12 GMT >>>>>>>>I am new to the world on scripting and any inputs would be great. >>I have a requirement where i need to set the user's organization >>in the Address BC upon.

Bookshelf v8.1/8.2: Updating Fields When Siebel CRM Updates Other Fields >>>Updating Fields When Siebel CRM Updates Other Fields The On Field Update Set n user property sets the value of a business component field when Siebel CRM updates another field. The value for this user property must use the following format: ' FieldToCheck', ' FieldToSet', ' Value', ' Condition' where: • Value and Condition are optional parameters. Note the following: • If Siebel CRM updates FieldToCheck, then it sets FieldToSet to Value. • If you do not include the Value parameter, then it sets FieldToSet to the value that FieldToCheck contains. • If you include Condition, then it updates FieldToSet only if Condition evaluates to TRUE.

• Double quotes (') must enclose each parameter. A comma and a space must separate each parameter. Above Ground Pool Liners Installers. For more information, see. You can specify this user property with or without the numeric suffix. For more information, see.

Setting the Value Parameter of On Field Update Set The Value parameter can contain an expression. If Siebel CRM updates the Done Flag in the following example, then it uses an IIF expression to set the Done field: 'Done Flag', 'Done', 'IIF ([Done Flag] = 'Y', Today (), ')' Any expression you use must evaluate to the same data type that the target field uses.

I don't know of any out of the box solution to your needs, however there are many ways to achieve it with a bit of customisation. For example: • Create two new fields, Waiting Time (with predefault value: 0) and Waiting Date. • Create the following BC user properties: • On Field Update Set x = 'Status', 'Waiting Time', 'IIF([Waiting Date] IS NULL, [Waiting Time], [Waiting Time] + (Timestamp() - [Waiting Date])) • On Field Update Set y = 'Status', 'Waiting Date', 'IIF([Status]='Waiting on Customer',Timestamp(),NULL)' Your Waiting Date field will store the last time the service request changed to 'Waiting on Customer', or NULL if it's on another status. Langkah Mendownload Sebuah File Dari Halaman Web on this page. Then, Waiting Time will accumulate the total time the request has been in that status. I have not tested the solution, it might need some more work, for example, it's possible that Siebel doesn't allow you to use the expression [Waiting Time] + (Timestamp() - [Waiting Date]) directly and you'll have to decompose it using auxiliary calculated fields. Note also that the On Field Update Set user property has changed its syntax from to. If you're familiar with server scripting, you could implement something similar quite easily, on the BusComp_PreSetFieldValue event.