Question

non-unique dropdown values

Forms

Updated May 14, 2019

asked on May 14, 2019

I am making a form that has a drop-down with multiple activities that have some of the same values. When I have the value fill another field I get a modified value that includes a _{n} if the value is attached to more than one activity as shown in the picture. What can I do to not have to combine activities and not have the modified value?

Example.JPG (12.11 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on May 14, 2019

Hi Arron, this is expected behavior, Items listed in a drop down or their Values must be Unique. When it see's two of the same items, Forms add the _x to make them unique.

What would you List look like and how would different their values when you choose one?

If they are different Selectable items but require the same value, you can approach it in a couple different ways,

Add a unique character to the front of the value assigned to the drop down selection (just the value, not the name) and in the other field trim it off using a formula such as =MID(Dropdownfield,2,100). In the case it's in a table or Collection =MID(INDEX(Table.Dropdownfield,ROW()),2,100)

Or, you may have to make a small SQL table and pull the value from that via a lookup

0 0

replied on May 14, 2019

I broke down and did a SQL table for it. Thank you

0 0

Replies

replied on May 14, 2019

That's interesting. Looks like forms has that baked into it. Which, if that's the case you would need to reassign the values with javascript.

0 0

You are not allowed to follow up in this post.

Question

Question

non-unique dropdown values

Answer

Replies

Sign in to reply to this post.