List selection input

This guide will take you through how to set up a list selection input.

Prerequisite data

No connectors will be used in this example, but data from table steps will be utilized. Please download the file below; it will be used to import into the required table steps

181B

List selection.csv

Open

Add a list selection input

1. Open an existing application or create a new one in an application package and open it in the Designer.

   1. Add a User step.

   2. Add a Table step.

   3. Open the Table step and select Import File.

   4. Choose the semicolon separator and click OK.

   5. Select the "List selection.csv" file downloaded in the prerequisite section above.

   6. Set the table variable name to "Articles" and click OK.

   7. Change the step name to "Articles". It's good practice to name steps after their content.

   8. Right-click on the "Articles" step, select Add data arrow, and connect it to the User step created in step 1.

1. Open the User step.

   1. Add a List selection input.

   2. In the Target Variable, write "article".

   3. Under Data Source, in Table Variable, choose the table "Articles".

   4. Under Appearance, in Prompt, write "Choose an article".

   5. In Large Row Text, write "{Name}".

   6. In Small Row Text, write "{Cost}{" in SEK"}".

   7. Le the Group Rows By be none.

2. Click the Play button in the top right-hand corner to run the application in diagnostic mode.

Add configuration

When working with tables, connect offers a variety of possibilities to add configuration and style to make it look more suiting for your purpose.

1. Go back to the Designer.

   1. Open the drop-down in Group Rows By and choose "Cost".

   2. Run the application in diagnostic mode again.

   

   Instead of displaying the Articles in a list, they are now displayed in a drop down that opens a table.

The articles are displayed grouped by the Cost.

1. You can also display this grouping with colors.

   1. Remove "Cost" from Group Rows By.

   2. In the Item Style, open the editor by clicking the arrows to the far right.

1. Add the code below.

{case
    
    when Cost = '5' then '#65FFFF'
    
    when Cost = '20' then RGB(204,204,255)
    
    when Cost = '30' then 'GREEN'
    
    when Cost = '50' then '#EEA7F6'
    
    when Cost = '75' then RGB(204,255,204)
    
    when Cost = '100' then 'BLUE'
    
    when Cost = '250' then '#FDC096'
    
    else '' 

end}

1. Click the Play button in the top right-hand corner to run the application in diagnostic mode.

The articles with the same cost show the same color.

1. Condition to hide

   1. In the Condition To Hide, write “{userId = “your user id”} (the user Id you log in to Connect with)

   2. Run the application in diagnostic mode again.

The list is now hidden since the condition is fulfilled.