5.6 Create Check Box Forms in Notebooks

The Check Box Form supports multiple selection of inputs in a paragraph. The inputs are available as check box options in the notebook.

To create a Check Box Form:

1. Open the notebook in which you want to add the Check Box Form.
2. In a SQL statement, define the Check Box form by using the syntax:
   ${checkbox:formName=defaultValue1|defaultValue2...,option1|option2...}
   For example, run the SQL statement:
   SELECT ${checkbox:whichcolumn=OWNER|OBJECT_TYPE, OWNER|OBJECT_NAME|OBJECT_TYPE|CREATED|STATUS} FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('VIEW', 'TABLE', 'INDEX', 'SYNONYM');
   In this example,
   • The Check Box form is WhichColumn
   • The multiple selection options available in the check boxes are OWNER, OBJECT_NAME, OBJECT_TYPE, CREATED, and STATUS
   • The fields OWNER and OBJECT_TYPE are defined as default
   • The table name is ALL_OBJECTS
   • The columns that are configured for display are OWNER, OBJECT_NAME, OBJECT_TYPE, CREATED, and STATUS
3. Run the notebook. The Check Box form called WhichForm is available in the notebook, as shown in the screenshot.