Supply Chain Planning Help
Supply Chain Planning Help
Home >

Add parameters or local variables to a macro

  1. On the Navigation toolbar, click Design Studio .
  2. In the Design Studio pane, in the Projects section, select a macro.
  3. Click , and choose Properties.
  4. In the Macro Properties dialog box, on the Parameters tab, click one of the following:
    • Add Parameter
    • Add Local Variable

    The Parameter Properties dialog box is displayed.

  5. For Parameter Type, choose one of the following:
    • User Enter Value
    • User Select From Query-based List
    • User Select From Fixed List
    • Local Variable
  6. For Name, type a name for the parameter.
    Notes:
    • Parameter names must begin with an "@" symbol.
    • Parameter names cannot include spaces or special characters.
  7. For Prompt, type the text that you want to display to the app user.
    The prompt isn't specified for local variables.
  8. For Data Type, choose one of the following:
    • String
    • Integer
    • Float
    • Date
    • Boolean
  9.  For Initial Value, do one of the following to specify a default:
    • For the string, integer, or float data types, type a value.
    • For the date data type, click , and specify a date.
      To allow editing of date values, select the Include Time Value When Editing Dates check box.
    • For the boolean data type, select or clear the Initial Value check box.
  10. If you want to allow app users to not provide a value, select the Allow Nulls check box.
  11. If your app users must choose a value from a query-based list, specify the query:
    1. On the Query tab, choose a connection.
    2. For Value, click , and then construct the query.
    3. For Description, click , and then construct the query.
    4. If you want to specify conditions for the list, in the Conditions section, click Add Statement, and then construct the query.
    5. If you want to sort the list, in the Sort By section, click Add Statement, and then construct the query.
    6. If you want to limit the number of list items, select the Only The First __ Records check box, and then type a number.
  12. If your app users must choose a value from a fixed list, create the list:
    1. On the List tab, click Add Row.

      An empty row is added to the Items section.

    2. In the Values column, click the row to activate the text field, and type a value.
    3. In the Description column, click the row to activate the text field, and type a description.
    4. Add more rows as needed.
  13. Click OK to close the .Parameter Properties dialog box.

    In the Macro Properties dialog box, a box is displayed for each parameter.

    A visual identifier indicates the parameter and data type.
  14. Click OK to close the Macro Properties dialog box.
  15. Click Save.

Last modified: Friday May 04, 2018

Send Feedback