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

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 ?

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

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 ! :-)

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, ...

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

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.

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

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

1) Change the field type to category

2) Select it and click the 'gear' icon

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

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

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?