You are viewing limited content. For full access, please sign in.

Question

Question

Recipercating dynamic fields

asked on August 7, 2017

I have a customer that has "Vendor Name" and "Vendor ID" fields that they want to be dynamic.  But they want to allow the user to pick either field and have the other field auto populate.

 

Since you set the parent property to auto filter the dynamic list, I have not found a way to do what the customer is wanting.  Is there a way to configure the dynamic fields to allow them to choose either field and then auto populate the other?

0 0

Replies

replied on August 7, 2017

When we run into this, we generally use workflow. Other times we make a combined field something like VendorID - Name or Name - Vendor ID through a view depending on which they are more likely to know.

1 0
replied on August 7, 2017

Hi Bert,

I don't think this is possible when setting up templates. I know it's not possible to refer to 2 separate external tables within the same template due to simple binding.

The only possible workaround that I can imagine is suboptimal--it basically requires duplicating columns in the same table, so you'd have a [VendorNamePrice] field and a [VendorNumberPrice] field, for example, so if the user begins populating metadata by typing into the Vendor Number template field, it would pull from the relevant [VendorNumber...] fields, and vice versa if the begin populating the template using the Vendor Name field.

~Rob

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.