Expand my Community achievements bar.

SOLVED

Drop down list from Database

Avatar

Level 2

Hi All,

New here, I'm trying to populate a drop down list based on a DB column. My dataconnection has a field in it called name, I'm binding the drop down list to the DataConnection and selecting the name from the binding flyout. When I preview the pdf the drop down contains the first name found in the name column of the DB. There is nothing else in the drop down list but that name, when I select the drop down button it doesn't drop down anything?

What I'm I doing wrong?


Thanks,

Todd

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

On the Object palette on the for right side is a fly out menu indictor. Right click on that and choose show dynamic properties. That will change some of the properties on the palette to an underline highlight color. Now on the Field tab you will see that the ListItems is a bindable property. Click on the link and fill out the Dynamic properties dialog box.

Paul

View solution in original post

2 Replies

Avatar

Correct answer by
Former Community Member

On the Object palette on the for right side is a fly out menu indictor. Right click on that and choose show dynamic properties. That will change some of the properties on the palette to an underline highlight color. Now on the Field tab you will see that the ListItems is a bindable property. Click on the link and fill out the Dynamic properties dialog box.

Paul

Avatar

Level 2

Hi Paul,

Thanks, that’s what I was missing, I now have a drop down list.

Thanks again!

Todd

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----