Table Level

Table level code can be created to automate operations and processes upon creation and/or update of a record in a table and to determine whether or not certain users can see and/or edit the content of a table. These options are accessed via the Table Tools (Data Model) window displayed in the image below.

TRIGGER ON CREATE – The “On Create” trigger is a block of code that executes upon creation of a new record in the table to which the code is attached. It is important to note that the On Create Trigger will execute immediately, every time a new record is create, not simply when the first record in a series is created.

TRIGGERAFTERUPDATE – The “After Update” trigger is a block of code that executes upon modification of any content in the table.

READABLE IF – The code entered into this field must evaluate to a True of False state thereby determining if the contents of the table is readable or not readable by the current user. While any kind of parameter, statement or code snippet can be evaluated, this field is most often used to evaluate the current users rights and privileges as defined by the system administrator and with respect to the contents of the specific table where the code is created. This user-specific evaluation enables system administrators to control the accessibility of each table on a user-by-user, group-by-group basis. If the code block in this field does not evaluate to either a true of false state, the table will remain readable.

WRITABLE IF – The code entered into this field must evaluate to a True of False state thereby determining if the current user can write (create) new content within the table. While any kind of parameter, statement or code snippet can be evaluated, this field is most often used to evaluate the current users rights and privileges as defined by the system administrator and with respect to the contents of the specific table where the code is created. This user-specific evaluation enables system administrators to control the accessibility of each table on a user-by-user, group-by-group basis. If the code block in this field does not evaluate to either a true of false state, the table will remain writeable.