Text Object Change based on Selection

[EvanBarrick]

I have a text object that has the following expression; 

=[Game Description] & ' - ' & eventDATE & ' - ' & Timestamp(TIME, 'h.mm TT')

These change to actual values once a selection is made from a filter pane.

I think it would be a good feature for inexperienced users to have the text object read 'Make  A Selection', which would then "disappear" (change to the associated values) once a selection is made in the filter pane.

Is this possible?

[sunny_talwar · Accepted solution]

May be like this

=If(Len(Trim(GetCurrentSelection())) = 0,
'Make A Selection',
[Game Description] & ' - ' & eventDATE & ' - ' & Timestamp(TIME, 'h.mm TT'))

[EvanBarrick]

I cannot get your solution to be accepted as proper syntax. Would I need to reference the field of 'eventDATE' anywhere near the GetCurrentSelections?

[sunny_talwar]

Is this based on selection in just EventDate field?

[EvanBarrick]

Yes, only based on if a selection is made in that field.

[EvanBarrick]

I was omitting a parenthesis. Your solution functions correctly. Thank you.

[sunny_talwar]

For just selection in eventDATE, you can try this

=If(GetSelectedCount(eventDATE) = 0,
'Make A Selection',
[Game Description] & ' - ' & eventDATE & ' - ' & Timestamp(TIME, 'h.mm TT'))