Time Stamp not affected by change of calculated fields.

[Former Member]

Dear Experts,

We have several calculated fields that are depended on values of lookup records or the system-time.

I experienced during recalculation that when the calculated field changes the Time Stamp did NOT change. This change did also NOT trigger the workflow with Trigger Action: Record Update. AND the record is not Syndicated because the syndication map has Suppress Unchanged Records.

Has anyone an idea how to solve this?

Kind regards,

Job Jansen

[Former Member]

Hi,

The field which will update the time stamp should be added in the list of time stamp, so that if there is any change in a mentioned field time stamp is updated.

Regards,

Pramod

[Former Member]

Hello Job Jansen

You can use simple field in main table for save your calculation result

Create assignment which calculate your expression and fill your simple filed

Create workflow with trigger action: record update or record insert and launch immediatly

in workflow call your assignment

Regards

Kanstantsin

[Former Member]

Dear Kanstantsin,

I don't know what you mean by "simple field" but I have 2 calculated fields one is Text and the other is Boolean. In both cases the Time Stamp is not updated during recalculation.

Of course both fields are selected fields in the Time Stamp field.

Kind Regards,

Job Jansen

[Former Member]

Hello Job Jansen

Simple field maybe as time stamp, text, boolean or numeric and that field should be add to main table.

Your expression and result wasn't clear for me...

Regards

Kanstantsin