Skip to main content
swapnar6405
Known Participant
Mar 31, 2023 9:05 PM UTC
Solved

ERROR while checking recordtype column value is there in an array

Hi,

I am trying to find out key column value and if it contain {3,9}, I want to show the specific column. But, I am encountering below error. Can someone advice what needs to be done.

Thanks in advance.

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 2]: Invalid types, can only act on data of the same type (Number (Integer), Record Field)

sanchitg0002
Inspiring
Apr 3, 2023 2:45 PM UTC

Query the same data which is in data parameter of gridField in a localVariable using queryRecordType() and then apply showWhen on gridColumns like:

 

contains({3,9}, local!data[recordType.fieldName])

7 replies

sanchitg0002
Inspiring
Apr 1, 2023 1:55 AM UTC

Reference the record field like: 

fv!row[recordtype!recordName.field]

swapnar6405
Known Participant
Apr 3, 2023 1:29 PM UTC

I am getting the below error when I try use like fv!row[recordtype!recordName.field]

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 6]: Could not find variable 'fv!row'

stefanhelzle0001
Brainy
Apr 3, 2023 1:41 PM UTC

fv!row is only available inside the "value" parameter. Making a whole column visible depending on the value of an individual cell also does not make that much sense.