Question

Forms - Lookup, How do I populate the alternate values?

Updated March 9, 2015

asked on March 6, 2015

When creating a drop down with alternate values and populating the values using a lookup I don't see an option to populate the alternate values. Do alternate values still need to be manually maintained? How would they even see them if the values are being populated at real time?

0 0

Answer

SELECTED ANSWER

replied on March 6, 2015

One workaround might be to just use a hidden field with a standard lookup process.

If your table contains both columns (for the drop down list and for what you want to use as the alternate value) then after configuring one rule that populates the drop down field with the values from column 1, you can set up a second lookup that populates the hidden field with the corresponding value from column 2 based off of what gets selected in the drop down.

Then you can use the variable of the hidden field if you want to work with the alternate value of whatever is selected in the drop down.

0 0

replied on March 9, 2015

That sounds like it should work. Thanks!

0 0

Replies

replied on March 6, 2015

The alternate values cannot currently be populated when doing a database lookup.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms - Lookup, How do I populate the alternate values?

Answer

Replies

Sign in to reply to this post.