Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in a list box same values should be grouped. Can a tree structure be realized with a formula?
AD-K
AD-K (A)
AD-K (B)
AD-K (C)
AD-K (D)
AD-H
AD-H (S)
AD-H (T)
Regards
Stefan
May be this
=If(Len(Trim(Site)) > 0 and Match(Site, 'AD', 'AS') = 0, SubField(Site, ' ', 1) & '/' & Site)
Something like this?
Or this
SiteView:
LOAD * INLINE [
Site
AD-K (A)
AD-K (B)
AD-K (C)
AD-K (D)
AD-H (S)
AD-H (T)
];
SiteTree:
LOAD Site,
SubField(Site, ' ', 1) & '/' & Site as SiteTree
Resident SiteView;
Concatenate(SiteTree)
LOAD Site,
SubField(Site, ' ', 1) as SiteTree
Resident SiteView;
Yes, but it is possible to create this view with a formula in listbox?
May be using this
=If(Len(Trim(Site)) > 0, SubField(Site, ' ', 1) & '/' & Site)
Great. If i have more values like AS and AD in listbox, and only AD-K and AD-H will show in listbox. How is this formula?
May be this
SubField(Site, '-', 1)
What exactly are you wish to see in the list box?
Listbox should be filtered by: AD-K and AD-H
So you don't want to see AD and AS in site listbox?