Using variables
• Variables add flexibility and portability to your database, and can be used instead of global fields in your database schema.
• A global variable can be used in a calculation or script anywhere in a file, for example, other scripts or file paths. The value of a global variable is not cleared until the file is closed. Prefix global variables with $$.