October 20, 200223 yr 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.
October 20, 200223 yr 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.
Create an account or sign in to comment