Adding prompts to a Salesforce connection
When you create an analysis from Salesforce data, you can configure the analysis to let users select what data to load when opening the analysis.
- Follow the first steps in the help topic Accessing data from Salesforce or edit a Salesforce connection from the data canvas.
In the rightmost part of the
Load data from Salesforce dialog, locate and point the mouse at the column of interest.
This is the column from which you want end users to select values when they open the analysis.
- Click on the icon next to the column name, .
Let end user select values from the pop-over menu.
The pop-over is expanded with more settings.
- Select which Input type to use. Read more in separate section about input types.
- Optionally, add a description to include in the prompt that will be shown when end users open the analysis.
- Repeat steps Step 2 to Step 6 for each column that you want the end users to select values from.
If you have added prompts to more than one column in the same view, you need to consider the order in which the prompts will be displayed. Click on the
Input order button.
In the pop-over menu that is opened, all the columns with prompts are listed.
- Click and drag the columns in the list to the order you want them to be displayed.
The prompts you have added will be displayed in the order you specified in Step 8.
For each prompt that is displayed, specify the values you want to load into Spotfire for further analysis.
The selected data from Salesforce is loaded into Spotfire.
- Use Single selection if the user should only be allowed to select one value from the column.
- Use Multiple selection if you want to let the user select more than one value from the column. The user will be presented with a list showing all the available values in the column. You can also specify how many values the user should select, using the Min and Max fields.
- Use Range to let the user select multiple values between two values. Range could be suitable for dates, and columns containing numerical values. Note that if you use range as input type for categorical values, you need to make sure you write good instructions in the Description field.
- Use Manual input to let the user enter any value to include (for string columns or numeric columns). This input type should only be used if all end users know which values are valid for the column, or if applicable values are shown in the description. For boolean values you get to pick a value using radio buttons (True/False) and for date columns you can choose a date from a calendar.
Input orderIn this example, three columns have been configured with prompts: ShippingStreet, ShippingCity, and ShippingCountry.
The Input order pop-over shows the following order: ShippingCity, ShippingCountry, ShippingStreet.
A better order would probably be ShippingCountry, ShippingCity, ShippingStreet. That way the user would first specify which shipping countries to load data for. The next prompt would show only cities located in the selected countries. And the last prompt would show streets located in the selected cities. To change the order, just click on a column and drag it to the position you prefer.