Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I would like to restrict listbox values based on conditions for more than one field.
Please help.
Thanks
What are the conditions? May be use an if statement....
Did you mean the condition is based onthe 2 or 3 fields then you can try this ways on the list box with if condition
Ex:-
=If( Product = 'Product A' and Year = 2016, Category)
Or please elaborate more on the requirement
Regards
Anand
I already have this condition:
=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',
'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',
'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)
But I also want to add another one : Source_={'Business Bank'}
Hi Moses, the code between '{<' and '>}' is called "set analysis", it's a way to set filters to a field, in that part there are fields separated with commas and the values assigned to each field betwee '{' and '}' (many values are checked as an OR, so the field can have any of those values), so you just add a new field:
=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',
'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',
'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}, Source_={'Business Bank'}>}Campaign),Campaign)
The set analysis filters 2 fields: Campaign and Source_
I already have this condition:
=aggr(only({<Campaign={'Business Banking Floor Referral','Business Banking Inbound','Business Banking Wealth Collaboration Leads','FNB Business Banking Call Me Back – Lead Apply','FNB Phone App Lead: Business Call Me Back',
'FNB.Mobi - Business Account','FUSION - BUSINESS ACCOUNT REFERRAL','Lead FNB HR mobi Business','SSA Business Application Lead - CIS Profile Issue','SSA_BUSINESS_CALLBACK','WEBCallBackMultiMembers',
'SSA Business Application Lead - Exit Call Me Back','SSA Business Application Lead - Force Referral','SSA Business Application Lead - SSA Completion'}>}Campaign),Campaign)
But I also want to add another one : Source_={'Business Bank'}