The Dropdown question type lets people select an answer from several choices. This question type is ideal for presenting a long list of options without cluttering your form.
Add a Dropdown and Set Up the Definition Properties
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click on the form you are working with.
3. Click Add Question. The Add Item window appears.
4. In the Unique ID field, enter an identifier for the dropdown.
5. From the Type drop-down pick list, select DropDown.
6. In the Text field, enter and format the label you want to use to describe the datepicker.
7. Text is automatically added to the left of the datepicker. Use the Text Position options to move it to the top or right.
8. If you are grouping fields, enter the group name in the Group field. Each question being included in the group must have the same group name in this field.
9. If you are using a collection grid:
a. Select the grid you are associating the datepicker with from the Grid drop-down.
b. Select the appropriate Grid Function from the drop-down.
10. Click Save.
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click Manage Forms. The Manage Forms page appears.
3. Click on the form you are working with.
4. Click on the tab you want to work with.
5. Right-click on the question/field and select Properties. The Edit Item window appears.
6. Click the Settings tab.
7. The question is automatically added to the left of the form page. Use the Alignment options to move it to the center or right.
8. To adjust how wide or high the dropdown appears, enter the size you want the button in the Width and Height fields. You can use the percentage of 100 or use px, pt values. For example, if you want the dropdown to be small, enter 50% or 50px.
9. If you wish to apply a CSS class to the drop-down, enter a known CSS class in the Input control CSS classes field.
10. Set up the attributes:
a. If you want to require users to select an option from the dropdown, select the Required check box.
b. If you want the dropdown to be shown to users, but unavailable to them to select from, select the Read Only check box.
c. If you want to make a question/field only visible in the report view or J1 FormFlow - Workflow, select the Show Only in Report checkbox.
d. The Hide On Load setting can be used to hide a question on the form until another action takes place. * This setting will soon be discontinued. To show/hide a question, use the Rules tab.
e. If you want the option the user selects to be included in the form report, select the Include in Report Grid check box.
11. To have a drop-down option automatically selected when the form user accesses the form, enter it in the Default Value field. Form users can update what is selected.
12. If your drop-down options include a value amount mapped to a selected Payment Profile, and you want to double the final balance amount, select the Add Double Value to Final balance check box.
* It is recommended that you use the Balance Calculator to modify the final balance as this setting will eventually be discontinued.
13. If your drop-down options include a value amount mapped to a selected Payment Profile, and you want to multiply the amount by the Fee Amount in the Payment Profile, select the Multiply Balance by Double Value check box. For example, an event participant is registering for an event and they have 3 guests attending with them. There's a fee and when they select the number attending this will multiple the fee of the event by 4.
* It is recommended that you use the Balance Calculator to modify the final balance as this setting will eventually be discontinued.
14. From the Map to Payment Field drop-down, select the data to appear in the payment portlet.
15. If you are associating the drop-down with information in J1 Web Events, select the appropriate event field from the Map to J1 Web Event Field drop-down options. If you are using this drop-down with a multi-part event that allows invitees to select the events they are attending, see Build a Multi-Part Event Registration Form.
 |
This option is only available to schools with a J1 Web Events Management license. |
16. In the Help Info Text field, enter additional information or brief instructions for form users. Help information is shown next to a help icon that shows your text when the user hovers over or clicks on it.
|
This option is only available to schools with a Candidate license. |
17. Click Save.
Set Up Static Options for a Dropdown
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click Manage Forms. The Manage Forms page appears.
3. Click on the form you are working with.
4. Click on the tab you want to work with.
5. Right-click on the question/field and select Properties. The Edit Item window appears.
6. Click the Options tab.
7. Select the Static Options option.
8. If you want the options to be randomized, select the Randomize Options check box.
9. Click Add Option.
10. If the dropdown options impact a final balance on the form, use the Dbl Value field to enter the numeric amount used in the balance calculator.
11. Use the Value field to enter the value that will be stored in the database and displayed in the email/report.
12. In the Text field, enter how the option will appear to the form user.
13. If you want a particular option to be automatically selected when the form user first accesses the form, select the Selected check box.
14. Click Save.
Set Up Dynamic Options for a Dropdown
|
Dynamic dropdowns will not work in form setup mode. To test your dynamic dropdown, you must access the form as a user. |
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click Manage Forms. The Manage Forms page appears.
3. Click on the form you are working with.
4. Click on the tab you want to work with.
5. Right-click on the question/field and select Properties. The Edit Item window appears.
6. Click the Options tab.
7. Select the Dynamic Options option.
8. From the Options Source drop-down, select the datasource you want to use to populate the options available for the form user to select from.
 |
JZB indicates a Jenzabar-provided datasources. You can also select from datasources your school has set up using the datasources options. |
9. Click Save.
Add a Rule to the Dropdown to Execute an Action
You can use actions to control if anything happens when the form user selects a particular option. For example, your form survey includes a radio button option asking form users to rate their level of satisfaction with the school's facility. If the form user selects Dissatisfied, you can show an additional essay question asking them to detail why.
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
1. Click Manage Forms. The Manage Forms page appears.
2. Click on the form you are working with.
3. Click on the tab you want to work with.
4. Right-click on the question/field and select Properties. The Edit Item window appears.
5. Click the Rules tab.
6. Click Add Step.
7. In the first drop-down, select the If answer value is condition. This tells FormFlow to execute the rule if the answer value matches the value you specify.
8. In the field to the right of the drop-down, enter the answer value that you want to trigger the rule to execute.
9. In the third drop-down, select the action you want to happen. Examples
To show the form user a message, select Alert: Show message. A blank field appears where you can enter text you want shown in a pop-up notification. This can be useful when you want to notify the form user about their choice.
To show or hide other form options based on what the forum user selected, use the group clear, hide, show, and toggle options. See Working with Grids for more information.
10. If you would like to add a rule that executes if the answer value the user enters is a different value:
a. Click Add Step.
b. Select Else if answer value is from the first drop-down option.
c. Enter the answer value in the field that you want to trigger the rule to execute.
d. From the section drop-down option, select the rule you would like to execute.
11. To include additional conditions before the action occurs:
a. Click Add Step.
b. Select Else from the first drop-down option. Selecting Else will execute the current rule if the previous rule did not execute based on the answer value provided.
c. From the second drop-down option, select a rule type to execute.
12. To have more than one action occur when the form user selects a particular option:
a. Click Add Step.
b. Select And from the first drop-down option. Selecting And will execute the current rule in addition to any other rule that is set to execute.
c. From the second drop-down option, select a rule type to execute.
13. Repeat steps 6 - 12 to add as many actions and conditions as needed.
14. Click Save.
Options give the form user a list of items to choose from.
Returns a list of states from the J1 database.
SELECT
RTRIM(VALUE),
DESCRIPTION
FROM
TD_STATE_VIEW
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click Manage Forms. The Manage Forms page appears.
3. Click Site Administrators.
4. From the toolbar, click Data Sources. The Data Source page appears.
5. Click the Add
icon 
to the right of the DataSource drop-down list. The previously inactive
fields become active.
6. In the Name field, enter a name for the datasource you want to create.
7. From the Use Database drop-down, select the database you want to pull the data from. This could your J1 database or another external database you are using with J1 FormFlow - Forms.
8. If you do not want the data source to be executed unless a user is logged in, select the Require Authentication checkbox. This may be useful if the data source contains sensitive information that should not be displayed to a JICS guest user. Jenzabar recommends using string replacers in your data source query to further tailor the results that will display to the user.
9. In the DataSource Query field, enter your SQL query that will select and/or filter the information in your database that you want to make available in your form.
10. Click Save DataSource.
11. Click Manage Forms. The Manage Forms page appears.
12. Click on the form you are working with.
13. Click on the tab you want to work with.
14. Right-click on the drop-down, radio button or checkbox question you are associating the datasource with and select Properties. The Edit Item window appears.
15. Click the Options tab.
16. Select Dynamic Options.
17. From the Options Source drop-down, select the auto-complete data source you created.
18. Click Save.
A look up takes the value supplied by the source question, passes the information back to the database asynchronously, and return values to be assigned to other inputs on the page.
A look up data source can return multiple columns from multiple tables, but the restriction is that a single row is returned from the query. This row is almost always associated with a value provided by the source question. This value can be referenced in the data source query using the parameter "@@LookUpValue".
Sample SQL:
SELECT
NAME_MASTER.FIRST_NAME,
NAME_MASTER.LAST_NAME,
BIOGRAPH_MASTER.BIRTH_DTE
FROM NAME_MASTER
JOIN BIOGRAPH_MASTER
ON
NAME_MASTER.ID_NUM=BIOGRAPH_MASTER.ID_NUM
WHERE NAME_MASTER.ID_NUM
=
@@LookUpValue
|
If the column you are selecting from is a char type or nchar, RTRIM() the column values. Not trimming may result in unexpected effects when interacting with the form. |
1. Log in to the campus portal as an administrator and access J1 FormFlow - Forms.
2. Click Manage Forms. The Manage Forms page appears.
3. Click Site Administrators.
4. From the toolbar, click Data Sources. The Data Source page appears.
5. Click
the Add icon to the right of the DataSource
drop-down list. The previously inactive fields become active.
6. In the Name field, enter a name for the datasource you want to create.
7. From the Use Database drop-down, select the database you want to pull the data from. This could be your J1 database or another external database you are using with J1 FormFlow - Forms.
8. If the data source will be used as a list to control access to the form, select the Is Access Control List checkbox.
9. If you do not want the data source to be executed unless a user is logged in, select the Require Authentication checkbox. This may be useful if the data source contains sensitive information. Jenzabar recommends using string replacers in your data source query to further tailor the results that will display to the user.
10. In the DataSource Query field, enter your SQL query that will select and/or filter the information in your database that you want to make available in your form.
11. Click Save DataSource.
12. Click Done.
13. Click Manage Forms. The Manage Forms page appears.
14. Click on the form you are working with.
15. Click on the tab you want to work with.
16. Right-click on the textbox, drop-down, or hidden question and select Properties. The Edit Item window appears.
17. Click the Look Up tab.
18. From the Look Up DataSource drop-down, select the datasource you want to use to look up information. The table columns associated with the data source appear with corresponding drop-downs.
19. From the drop-downs, select the Unique IDs of the form questions/fields you want to auto-populate with information from the matching table columns. Example
20. If you want your look up to execute immediately when the form is accessed, select the Execute on load checkbox. By default, the lookup will execute when the value of the question changes.
21. If the questions/fields being populated should trigger the question/field's events, select the Trigger After Set checkbox.
22. If you want to save the text a user manually inputs in a field that utilizes a lookup, select the Preserve user input checkbox. If there is a default value in the field, that would also be preserved. If you use the default value setting and pre-populate the field with @@LastName for example, it considers that user input and the value wouldn't be overwritten if this setting is checked. If this is not selected, the text pre-populated by the lookup will overwrite any text that the user inputs.
23. Click Save changes.
Options for Questions with Multiple Selections