Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Access field value within the same macro
  2. Access field value defined in another macro
Info

The query, database, field names and other values are for demonstrative purposes only. Please customize these values as per your instance.

Anchor
run630_

...

ex01_varInRun
run630_

...

ex01_varInRun
Access field value within the same macro

In this example, let's populate two select list boxes using the Dynamic Select field type in a Run a user form and parameters macro. To do so, the relevant profile and SQL query must be provided. See Field types for more information.

...

  • Rochester is selected in DYNSEL01 and 'Chicago' in DYNMULSEL01 and the form is run.
  • From the first example:
    • The Run variable macros returned the selected options in the lists.
    • The text below the Run variable macros shows how using the '$' sign the variable values can be accessed.
  • From the second example:
    • The selection made in the second select list with ID as DYNSEL01 is shown using the Groovy script.

...