- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded
hi there,
in the frontend I want to combine the functions getfieldselections & getselectedcount to dynamically show fieldselections, based on the number of selections.
the problem: both return different fieldcount.
I found out that getselectedcount has the parameter IncludeExcluded, which defaults to false. If set to true() both functions return the same fieldcount so I guess getfieldselections includes excluded values which is quite confusing.
Is there any way to not include exluded values in getfieldselections() ? Or any different ideas for a workaround?
thanks,
alex
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be use Concat() instead of GetFieldSelections?
If(GetSelectedCount() > 0, Concat(DISTINCT FieldName))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be use Concat() instead of GetFieldSelections?
If(GetSelectedCount() > 0, Concat(DISTINCT FieldName))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
well, yeah that might be an idea. the useful parameter in that function was that it automatically switches from concatenation to a summary ("x of y") after hitting MaxValues. But I guess I can rebuild this more or less if there is no other way
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
oh just tried this. concat() also return exluded values, thus will not work
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Concat() includes excluded values, can you share a sample of what you trying to get?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=if(Aggr(Sum(1), FIELDNAME)>0,
'Selected: $(=Concat(DISTINCT FIELDNAME, ', '))',
'Others: $(=Concat({<FIELDNAM=E({$})>} DISTINCT FIELDNAME, ', '))')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
let me try to explain:
I got two boxes. One which is a standard listbox, second is a summary of the selection (works similar to text field). Basically I try that both boxes show the same.
The problem: when extending my selection (to other fields), the selection within the listbox shrinks accordingly to what is really shown. Not so in the summary box which uses now the following expression (GetFieldSelections just got replaced with concat):
=if(GetSelectedCount(Channel)=0,'Channel',
if(GetSelectedCount(Channel)>5,GetSelectedCount(Channel)&' Channels',
Concat(Channel,', ')))
is that clear ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So you are saying that Concat() is showing Channels which are not selected?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
they have been selected before but further selection excludes values from the initial selection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think the best would be if you provide a small example.
- Marcus
- « Previous Replies
-
- 1
- 2
- Next Replies »