Question

Can Data Source Populated Field Display Table Dropdown?

Forms Version 9

Updated February 4, 2014

asked on February 4, 2014 • Show version history

We have a form that a manager will be filling out for an employee. We want to perform an employee lookup by allowing the manager to start typing in the employees name in a field and have it pop-up with possible matches (which can currently be done). Since some employees can have the same name, we would like to be able to show next to the employee name in the pop-up for matches the employee number as well. Is this currently possible?

0 0

Answer

APPROVED ANSWER

replied on February 4, 2014

I don't think having a pop-up that simultaneously displays the value from two different SQL columns is possible. Instead, you can have two fields, one for employee name and one for employee number. When the manager enters the name, the employee number field will conduct a lookup based on the employee name and display a dropdown list of employee numbers that correspond to that name. If only one value exists, which should be the case for many names, the employee number field will be auto-populated and no selection is needed.

0 0

Replies

replied on February 4, 2014

You might need to build your own functionality. It's fairly easy to do using jQuery and plugins such as jQuery UI's Autocomplete or Twitter's typeahead.js. You'd also need to build a back-end service that serves up JSON or something.

0 0

You are not allowed to follow up in this post.

Question

Question

Can Data Source Populated Field Display Table Dropdown?

Answer

Replies

Sign in to reply to this post.