Standard Macro flow - no values populated in drop down list

Question

Hi everyone,

I'm running through this tutorial on setting up a standard macro with a drop down option for users.

The macro itself runs fine, but there are currently no list values from the "company name" field populated in list properties and I just can't work out why... (see attached .png).

I'd like to test this approach using some of our local data where we need to look at specific faculties etc. for reporting, but need the drop down option to work. I've checked joins etc. and just can't see why the values aren't feeding in.

Appreciate any advice, very new to this!

Best

Ali

JosephSerpis · Accepted Answer

Hi @AliMc7 as per your screenshot the drop down is set to manual set values therefore you have to enter the values you want in the dropdown tool.

E.G.

Company A:A

Company B:B

danilang · Accepted Answer

Hi @AliMc7

If you want to populate with values from a database or file, change the List Values option to External source and configure the source as if it was an Input tool.  The items from the source need to have a NAME and a VALUE field.  NAME gets displayed in drop down and VALUE is returned by the drop down. A typical example would have NAME=Company name and VALUE=CompanyID.  NAME and VALUE can be the same.

Dan