topic Re: Dynamic String Find in Field - Frontend Calculation in App Development

Dynamic String Find in Field - Frontend Calculation

zwilson_borg — Wed, 12 May 2021 02:25:42 GMT

I'm looking for a way to dynamically search a field on the front end to see if all the values have a shared sequence. I don't want to provide it to search but rather it is found dynamically. For example, if I had the below data and the application is filtered to 'A' on [Grp] it would return 'SMTH - ' but unfiltered it would return '' or Null().

Grp | Text Value

A | SMTH - 1E

A | SMTH - 2W

B | WPQV - 2A

B | 5N

Thanks in advance for your help/thoughts.

Re: Dynamic String Find in Field - Frontend Calculation

MayilVahanan — Wed, 12 May 2021 03:01:30 GMT

Hi,

Do you want to display the text value in the KPI?

If so, try like below

=If(GetSelectedCount(Grp)=1, Concat(Distinct [Text Value], ','), '')

Re: Dynamic String Find in Field - Frontend Calculation

zwilson_borg — Wed, 12 May 2021 03:11:50 GMT

Mayil,

I need it to return the substring that is shared across each possible value in the field. In the example, I need the KPI box to just show 'SMTH - '. Your expression instead returns 'SMTH - 1E,SMTH - 2W'

Re: Dynamic String Find in Field - Frontend Calculation

marcus_sommer — Wed, 12 May 2021 09:34:29 GMT

Just taking a subfield-information maybe like this:

If(GetSelectedCount(Grp)=1, Concat(Distinct subfield([Text Value], ' - ', 1), ','), '')

- Marcus