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.checkbox_form