topic Re: GetFieldSelections question in App Development

GetFieldSelections question

hammermill21 — Mon, 20 Dec 2021 21:38:40 GMT

Hello!

I am creating a variable for when a building is selected. My expression for my building filter is:

=Trim(Upper(Replace(building, '_', ' '))) & Trim(Upper(Replace(enter_building, '_', ' '))), now I"m trying to create a variable for GetFieldSelctions using my building expression but it doesn't work.

Any ideas?

Thank you!

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 16:23:58 GMT

What exactly do you mean by this

@hammermill21 wrote:
now I'm trying to create a variable for GetFieldSelctions using my building expression

you are using an expression within GetFieldSelections() function? I believe the function only takes field name and not an expression.

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 16:30:27 GMT

Hey Sunny,

Then that's my issue, if the function only takes a field name then it won't work. I'm trying to figure out how I can display the building name that is selected with the current function I have.

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 16:40:26 GMT

Can you show by a mean of an image or example what exactly are you looking for? May be you can use something like this

=Trim(Upper(Replace(GetFieldSelections(building), '_', ' '))) &
 Trim(Upper(Replace(GetFieldSelections(enter_building), '_', ' ')))

or something using Concat.... like this

=Concat(Trim(Upper(Replace(building, '_', ' '))) &
 Trim(Upper(Replace(enter_building, '_', ' '))))

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 18:02:51 GMT

So what I want is when I select a building on the left-hand side, it shows up in my text box:

I tried creating a variable with the GetFieldSelections() but I cna't with an expression. I tried using the one below but that doesn't work.

=Trim(Upper(Replace(GetFieldSelections(building), '_', ' '))) &
 Trim(Upper(Replace(GetFieldSelections(enter_building), '_', ' ')))

And when I use the Concat this happens:

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 18:08:31 GMT

Try this

If(GetSelectedCount(building) = 1,
  Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
  )
)

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 18:10:03 GMT

Nope that doesn't return anything, not even an error.

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 18:36:06 GMT

Have you selected a single building? Without selection it won't return anything. You need to select only 1 building.... for multiple.. try this

If(GetSelectedCount(building) > 0,
  Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
  )
)

If you want to see without selection, try this

Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
)

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 18:45:21 GMT

Thank you Sunny!

Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
)

This one worked 🙂

One last question, if I wanted to add a Calculation condition I can't just write

Concat(DISTINCT
Trim(Upper(Replace(building, '_', ' '))) &
Trim(Upper(Replace(enter_building, '_', ' ')))
) <= 1

Becuase that doesn't work, could I even add a calculation conditionto this?

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 19:05:54 GMT

May be this

If(Len(Trim(
  Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
  )
) > 0

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 19:12:28 GMT

No that doesn't work 😞

It says I'm missing ")", I add it then it gives me an error in expression if takes 2-3 parameters.

Thanks for your help with all of this!

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 19:26:08 GMT

My bad, try this

Len(Trim(
  Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
)) > 0

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 19:33:15 GMT

Still not working, I feel like this shouldn't be so hard LOL

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 19:44:58 GMT

I think I am still missing a parenthesis... try this

Len(
  Trim(
    Concat(DISTINCT
      Trim(Upper(Replace(building, '_', ' '))) &
      Trim(Upper(Replace(enter_building, '_', ' ')))
    )
  )
) > 0

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 19:58:51 GMT

Still not working, I've attached the file to see if it's maybe something else I've done wrong?

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 20:03:57 GMT

Where exactly are you trying to do this in your dashboard?

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 20:07:22 GMT

In the "Select Building" KPI.

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 20:15:01 GMT

I am confused... what exactly are you trying to do? Are you only looking to show something when one building is selected? what happens when nothing is selected or when more than one building is selected?

Re: GetFieldSelections question

hammermill21 — Fri, 08 Mar 2019 20:28:25 GMT

I need to just show when one building is selected. When no building is selected it will say "All buildings are reflected in the data below unless a building filter is selected".

Re: GetFieldSelections question

sunny_talwar — Fri, 08 Mar 2019 20:32:03 GMT

Try this

If(GetSelectedCount(building) = 1, Concat(DISTINCT
    Trim(Upper(Replace(building, '_', ' '))) &
    Trim(Upper(Replace(enter_building, '_', ' ')))
), 'All buildings are reflected in the data below unless a building filter is selected')