Force Update

[Therber]

I'm combining two fields which have information originally entered via a portal. Normally, when information is changed in the portal the information in the related field updates automatically. However, I have found that when two fields have been combined the information will no longer automatically update (because it is now a caluclated field?). Is there a way to force an update when a change is made in the portal without a script - or do I need to just keep the fields separate?

Thank You.

[BobWeaver]

Sometimes you can append something that references the related values with an aggregate function that will force the recalculation Like this:

CalcField = Relation::Field1 & Relation::Field2 & case(count(Relation::AnyField),"","")

The case function doesn't add anything to the result, but it will force recalculation whenever anything in the related file changes.