Hi,
We have a list with three fields which has a combination matrix entries. We have a requirement to auto-populate a form control(Should be fetched from the list respectively) based on the value selected in the other two form controls by the User. Is there a way/workaround to achieve this task? Kindly suggest.
Custom List
Task Form
I would recommend to use calculated value control instead of single line text control.
in calculated value control build a formula based on lookup() function which can query data from other list.
Hi Marian,
I have tried using the same but in lookup function, there's no possibility of getting value based on two fields. Is there any other approach?
yes, make the single dropdowns filtered (cascaded) by each other.
so, user selects label1, label2 would be filtered only to those entries that belongs to selected label1 value. then make lookup for label3 only by label2 value.
see
Three-Tier Cascading Drop Downs: Do Go Chasing Waterfalls!
or search forum for cascading dropdowns
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.