AnsweredAssumed Answered

Updating Un-Stored Calculations via Server

Question asked by Jason_Farnsworth on Jan 10, 2017
Latest reply on Jan 10, 2017 by philmodjunk

I have a series of date fields that expire (or need to expire). Currently they do not - UnStored

 

I have them set to unstored for two reasons - First performance second I have conditional value lists only grabbing current dates.

 

Not expiring is a big deal -

 

The present idea is to run a server script at night the basically updates each record to grab a new stored value. The dates only need to update once per day to be current.

 

Do I need to troll over each record in the table and copy a field to itself or will updating one record in the table update all of them?

 

Is this the best option to handle this function?

 

Please advise,

 

Thanks in advance

 

Jason

Outcomes