justinmind-logo
 
Upvote 1

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

Answered Victor Conesa 9 years ago

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

Best Answer
photo

Follow these steps to use a specific field in a dropdown.

1) Change the field type to category

777516e02f3a7154355b955d81f58bd5

2) Select it and click the 'gear' icon

3c5e45a3b45c4e6a9f40a95b1cd509e3

3) Add values to the field using the '+' icon

eb7fc867cf413339acd76ddaa3418026

4) Select the dropdown and edit its values. You'll now be able to select a data master field.

d60ea9a9550ed821d54a3b0c49790fef

Replies (9)
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 us so we can review it in detail?


Please make reference to this post in the email.


Best,


Marc

photo
1

Follow these steps to use a specific field in a dropdown.

1) Change the field type to category

777516e02f3a7154355b955d81f58bd5

2) Select it and click the 'gear' icon

3c5e45a3b45c4e6a9f40a95b1cd509e3

3) Add values to the field using the '+' icon

eb7fc867cf413339acd76ddaa3418026

4) Select the dropdown and edit its values. You'll now be able to select a data master field.

d60ea9a9550ed821d54a3b0c49790fef

photo
1

Perhaps it's just me, but this won't actually provide the expected behavior.

In your example, you're choosing "ID" which would provide the user a dropdown with: 1, 2, 3, 4, 5, 6, etc. instead of the Title which would actually be useful to the end user.


Here's my issue, I want to show a dropdown of all names that fall in Category "FOO".


Category    Name
FOO   Car1
FOO   Car2
FOO   Car3
BAR    Truck1
BAR    Truck2
BAR    Truck3


So, I want a dropdown that looks like:

Car1
Car2
Car3


NOT the following (which your example seems to portray):

FOO
BAR


Thoughts?

Leave a Comment
 
Attach a file