Changing Column Titles Dynamically

Column titles can be set dynamically, so that they are assigned when the user enters the form. This option is available for forms that do not have a default design, and which have a value of T in the One-to-many column of the Form Generator.

To change the column title, use a variable made up of the form name, the title name and "TITLE".

Example: To change the title of the TEST column in the MY_FORM form to New Title, write in the PRE-FORM trigger:

:MYFORM.TEST.TITLE = 'New Title';

See also the FRGROUPS_DET form.

In addition, you can set the value of a column to an empty string ‘’ in order to hide the column. This allows you to show or hide columns dynamically.

:MYFORM.TEST.TITLE = '';

For an example, see the MATRIX form.

See also Form Triggers.

More on Triggers

• SQL Variables
• Built-in Triggers
• Creating Your Own Triggers
• Error and Warning Messages
• Sending a Mail Message
• Including One Trigger in Another
• Trigger Errors and Warnings