Drop Down

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Use the Drop Down widget to provide a list with items that when selected pass context to other widgets.

Drop Down widget properties

Use this property	To do this
General tab
Name	Type an internal name for the widget.
Connection Name	Specify a connection to a data source.
Scope Type	Make the connection public or specify a named session.
Title	Type a title for the Drop Down widget. If necessary, adjust the appearance of the title.
Title Bar Visibility	Specify the visibility of the widget title bar. Choose one of the following: Above Overlay Hidden (outside Designer only)
Context Sensitivity	Specify the context sensitivity. Choose from the following: None Receives Context Provides Context Custom Context provided on the selection made from the drop down list. When receiving context, the drop down list is filtered accordingly. If you want to both provide and receive context, also do the following: Click . In the Context Sensitivity Properties dialog box, select the Receives context check box. Click OK.
Columns tab
Add Statement	Populate the drop down list. Click Add Statement. A blank statement is displayed. Continue to construct the query as necessary. See Statement Editor Functions for a list of available functions.
Add Table Columns	Specify multiple columns to display. Click Add Table Columns. The Select A Table And Columns dialog box is displayed. In the Select a table list, choose the table with the columns that you want to include. The columns in the table are listed. By default, all of the columns are selected for inclusion. Clear the check box for any column that you don't want to include in the grid. Click OK. The specified columns are listed in the statement editor.
Hidden Columns	Prevent the display of columns. This enables you to use columns to provide context without having to display them. Click Hidden Columns. The Select Hidden Columns dialog box is displayed. All of the columns are listed. Select the check box for each column that you want to hide. Click OK.
Context Columns	Specify columns to function as context providers. Click Context Columns. The Select Context Columns dialog box is displayed. All of the columns are listed. Select the check box for each column that you want to provide context. Click OK.
Options tab
Single-Selection Mode	Select the check box to enable single-selection mode.
Auto-width Columns	Select the check box to automatically adjust column width to match the data.
Distinct Records	Select the check box to prevent the inclusion of duplicate records in the list.
K/M/B Summarization (Default)	Select to display large values in summarized notation.
Show Pager	Select the check box to display long lists in paged format.
Tile tab
Background Color	Specify the background color of the list.
Text Color	Specify the color of text in the list.
Show Shadow	Display a shadow on the widget.
Show Title Row Border	Display borders around the title row of the widget.
Font Size	Specify the size of the widget title.
Font Preview	Shows you how your font selections will affect the widget title.
Bold	Display the widget title text in bold.
Italic	Display the widget title text in italics.
Style tab
Column Headers section
Text Color	Specify the color of the header text.
Font Size	Specify the font size for the header text.
Font Preview	Shows you how your font selections will affect the header text.
Bold	Display the header text in bold.
Italic	Display the header text in italics.
General section
Font Size	Specify the size of text in the list.
Font Preview	Shows you how your font selections will affect the text in the list.
Bold	Display the list text in bold.
Italic	Display the list text in italics.
Advanced tab
Conditions	Specify any conditions that must be met to return a value. Click Add Statement. A blank statement is displayed. Construct the query as necessary. See Statement Editor Functions for a list of available functions.
Sort By	Filter the data to further narrow the scope of the query. Click Add Statement. A blank statement is displayed. Construct the query as necessary. See Statement Editor Functions for a list of available functions. Click Sort Ascending or Descending to adjust the order of displayed records.
Only select the top __ records	Specify to select only a specified number of records with the highest values.
Button Visibility tab
Refresh	Show or hide the Refresh button on the widget toolbar.
Filter	Show or hide the Filter button on the widget toolbar.
Search	Show or hide the Search button on the widget toolbar.
Events tab
Add Event Handler	Add events to the widget. For When/On, specify when you want the event to occur. For Then, specify the action that you want to occur.

Last modified: Friday May 12, 2023

Is this useful?

Yes No