AnsweredAssumed Answered

Call a script to calculate a field value

Question asked by ericjlawson on Feb 18, 2013
Latest reply on Feb 18, 2013 by nickchapin



I want to set a table value to be a CHAR (2) value representing the invoicing year (eg. "13"). Its not based strictly on calender year so I need to use a script.


Can I call this script from the Calculated Value dialog for Auto Enter of a table field value. If yes and if this is part of a 1 row table defining certain parameters for this application / database, will it execute each day the application is started up, thereby ensuring the correct value isstored for subsequent retrieval when generating invoice codes?


Or should I be defining a script to run at startup time for each session and loading this value into a global variable?