topic Text Object Change based on Selection in App Development

Text Object Change based on Selection

EvanBarrick — Thu, 17 Jan 2019 18:48:10 GMT

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?

Re: Text Object Change based on Selection

sunny_talwar — Thu, 17 Jan 2019 18:56:10 GMT

May be like this

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

Re: Text Object Change based on Selection

EvanBarrick — Thu, 17 Jan 2019 19:05:03 GMT

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

Re: Text Object Change based on Selection

sunny_talwar — Thu, 17 Jan 2019 19:46:17 GMT

Is this based on selection in just EventDate field?

Re: Text Object Change based on Selection

EvanBarrick — Thu, 17 Jan 2019 20:16:40 GMT

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

Re: Text Object Change based on Selection

EvanBarrick — Thu, 17 Jan 2019 20:20:07 GMT

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

Re: Text Object Change based on Selection

sunny_talwar — Thu, 17 Jan 2019 20:31:08 GMT

For just selection in eventDATE, you can try this

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