cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Get values by several filters

Hello,

could someone give me an advice, which method to use?

Situation:

I have list with several columns:

Product - Company - Type - Group - Adrress ( example)

I build the form with some cascade dropdown's:

Company - set company value.

Type - dropdown

Group - dropdown

Product - in this column I want get values from external list, which filter by values: Company, type, group. 

How to do this thing?

1. Create calculated column in list, which combine company+type+group and filtered by it?

2. Use ajax and send values to view and get product titles?

 

This solution ->  would work for me, but I have only one list, not 3..

So looking for solution!

Mantas

Reply
2 Replies
Workflow Hero

Re: Get values by several filters

I build the form with some cascade dropdown's:

Company - set company value.

Type - dropdown

Group - dropdown

but I have only one list, not 3..

these two statements sounds to be contradicting...

how did you build a cascade if you do not have separate lists of companies, types and groups?

could you post an example how does your data look like and how your cascaded selection is working?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Get values by several filters

Hello,

nice to see You there!

I have a list: 

And this form:

So I would like to do functionality, that when i choose value in all drop-downs (company, type, group) in product drop-down be only values which equals filters. 

0 Kudos
Accept as Solution Reply