jDropdown()

Estimated reading time: 6 minutes

Function Summary

The jDropdown function returns data from a DataPortal that can be displayed in a dropdown window for the user to select and insert into a designated cell within the spreadsheet. It is typically used to easily insert a valid parameter into the spreadsheet to filter the data returned by a report function after a pull action. When this function is linked to a hyperlink, the user can simply click on the hyperlink to display a list of valid parameters and insert one or more into the spreadsheet.

For an example of this function, see jDropdown.

Function Arguments

Type String/jDataPortal()
Constraints Max 255 char
If Blank Function Error

Type Param()
Constraints The values must match the order of the parameters in the data source (The order can be verified using the [Validation Report](/wTroubleshoot/Reports.html#validation-report-for-pullsave-events) )
If Blank Data is not filtered

Type Boolean
Constraints
If Blank False

Type Range
Constraints
If Blank Function Error

Type String
Constraints Max 255 char
If Blank Function Error

Type String
Constraints Max 255 char
If Blank Uses Value Column Name

Type String
Constraints Max 255 char
If Blank ","

Type String
Constraints Max 255 char
If Blank "Please select the desired options below."

Excel Formula Bar Example

=jDropdown(jDataPortal("NorthwindCustomersDropdown",1),,FALSE,C17,"CompanyName","DisplayText",,"Select a Customer")

Function Composition

Argument Name Example Mapping Explanation
Function Name =jDropdown() The name of this function.
DataPortal jDataPortal("NorthwindCustomersDropdown",1) Uses the helper function jDataPortal() designating the "NorthwindCustomersDropdown" DataPortal. Filters the records to include only those whose CustomerID contains the string "save".
Parameters "" The data returned from the data source will not be filtered.
MultiSelect FALSE Only one entry can be selected from the dropdown window.
Target Cell C17 The entry selected will be inserted into cell C17.
Value Column Name "CompanyName" The selected value for the column "CompanyName" will be inserted.
Display Column Name "DisplayText" ???
Delimiter   Value ignored because MultiSelect is false.
Instruction Text "Select a Customer" The text "Select a Customer" will be displayed under the title in the dropdown window.

Embeddable Helper Functions