topic Re: Get field Value based on selection(Field Value) with current selection in App Development

Get field Value based on selection(Field Value) with current selection

Micki — Thu, 01 Apr 2021 13:49:09 GMT

Hi folks,

I have a table :

And i want select value from second column and put in KPI

If you User select A: then in one KPI should be value 1 and in another 2

FieldValue() works but i don't know how to connect it t current selection.

Thank you in advance

Micki — Fri, 30 Oct 2020 18:03:26 GMT

Almost did it, but my code not working fully

Count({<[LastResultOutcome]={'Passed'}, [Level 2] = {"=SubField(concat(distinct Level2, '@'),'@', 7)"} //[Level2] = {'OEE'} >}distinct [Id])

Hi , @sunny_talwar, could you please help me how to put SubField(concat(distinct Level2, '@'),'@', 7) in set expression, thank you

Micki — Fri, 30 Oct 2020 18:16:21 GMT

Ok, it's done

[Level2] = {"$(=SubField(concat(distint Level2, '@'),'@', 7))"}

laacib — Mon, 30 Oct 2023 10:38:36 GMT

Hi,

I have similar requirement. I want get the value of field based on selection of another field value.

Could you please explain the above solution? Thanks!