Skip to main content
swapnar6405
swapnar6405
March 31, 2023
Solved

ERROR while checking recordtype column value is there in an array

  • March 31, 2023
  • 7 replies
  • 0 views

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)

Best answer by sanchitg0002

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

S
sanchitg0002
April 1, 2023

Reference the record field like: 

fv!row[recordtype!recordName.field]

swapnar6405
swapnar6405Author
April 3, 2023

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
stefanhelzle0001
Brainy
April 3, 2023

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.

Terms & ConditionsAccessibility statement