Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello together,
i have a table with a lot of companies:
Companies |
---|
Company A |
Company B |
Company C |
Company D |
Company E |
I would like to have a Listbox with two expressions :
Listbox |
---|
Company A |
Non Company A |
Do you know, how can I implementate this logic?
Thank you.
Greetings
Jörn
In your script you could add a simple column to the table along the lines of:
if(Companies='Company A', 'Company A', 'Non Company A') as Filter
And then create a Listbox based on this new Filter field.
In your script you could add a simple column to the table along the lines of:
if(Companies='Company A', 'Company A', 'Non Company A') as Filter
And then create a Listbox based on this new Filter field.
Make an variable of companies, otherwise you need to hardcode every company.
So vCompanies = Companies
=if(Companies=vCompanies,vCompanies,'NON '&vCompanies)
Is that how you want it?