How to only show a specific field from imported CSV in dropdown list ?

Whoops shared this question 3 years ago
Answered

I imported a CSV file with a few fields. Would like to create a dropdown showing only 1 field (for instance only the name). But I'm only able to create a dropdown with all the fields displaying with a comma separation. Could someone please tell in detail how to proceed ? I just want to be able to define which field to display. Thank you in advance ! Jean-Marc

Comments (7)

photo
1

I found this explanation where you have a descriptor functionality which enables you to select the field(s) you'l like to show in a drop down.


https://www.youtube.com/watch?v=yzG6A...


But in the latest release that functionality vanished. Where was this functionality moved to and how does it works ?

photo
1

Hi,


This functionality was removed. To do this in the newest version you must use an OnPageLoad event with a setValue action.


The value should be calculated and select the column you want from the datamaster.


If anything is not clear please let me know.


I've seen that the video you posted is almost 4 years old. For updated tutorials take a look at justinmind.com/support .


Best,


Marc

photo
1

Hi Marc, Thanks a lot for your feedback. btw, I watched all the tutorials, but I don't think there is a tutorial which explains how to do this. And honnestly, ... the number of tutorials is actually too restrainted for people who only have experience with html and ASP like myself. But, will try to sort it out on my own and if it doesn't work I'll come back to you ! :-)

photo
1

Hi Marc,


I don't seem to get further than this. :-( please help me out:


I created an on page load event with the set value action. There choose calculated value. But then I can choose either screen or variable. When clicking on + I'm able to create as many variables as I want, but that's not what I want. I would like


So I pushed add expression and use a select function, then selected the table depot as master and name as attribute. But it's not showing me the list of depotnames.


It's still show me option 1, option 2, option 3, ...


e12c689fed73ca0f4ef1b506f5d3151a

photo
1

Hi,


You have two options to do this.


Option1:


remove the fields in the dataMaster that you don't want to use, select the Checklist, click on "Edit values", Check the "Data Master" option and then select the desired Data Master.


OR


Option2:


1)Select the Checklist


2)Click on "Add Event"


3)Select "on Page Load" from the dropdown


4)Click on "Set Value"


5)Check the "Calculated" option


6)Click on "Add Expression"


7)Drag the "Select" option from the Data Functions


8)Go to the Data Masters tab (in the same window, next to Variables)


9)Drag the desired data Master to the first blank


10)Drag the desired field to the seccond blank


I hope this helps you achieve what you are trying to do.


If anything is unclear please let me know.


Best,


Marc

photo
1

Hi Marc,


Thanks for your patience ! ;-)


I now understand the principle and as you will see in previous screen, already applied option 2: sel( depot, name), but the problem is that when simulating I still don't see any master data. It's still show me option 1, option 2, option 3, ...


So I'm still forgetting something.


7c355749d322e401d3ba60d764ea97b1

photo
1

Hi,


In the screenshots I can't find anything that tells me why it is not rendering propperly. Could you send the prototype to jim.support at justinmind.com so we can review it in detail?


Please make reference to this post in the email.


Best,


Marc