Skip to main content
O
oludareo0002
January 26, 2022
Question

How to allow record to accept null variables

  • January 26, 2022
  • 4 replies
  • 0 views

Currently getting the error below

Error Evaluating UI Expression

Expression evaluation error at function a!gridField [line 29]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Team Lead"] has encountered an error. Expression evaluation error at function 'user' [line 29]: Null argument not allowed

any ideas on how to solve this issue

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    January 26, 2022

    Sure. You will need to wrap the user() function into a isnull() check

    if(isnull( value ), "--", user(value))

    O
    oludareo0002Author
    January 26, 2022

    Thinking this is what you mean? 

    if(isnull("--"),"--",user(fv!row['recordType!OCSC Nonclinical Service Tracking Entry.fields.{team_lead}team_lead'], "firstName") & " " & user(fv!row['recordType!OCSC Nonclinical Service Tracking Entry.fields.{team_lead}team_lead'], "lastName"))

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    January 26, 2022

    That would make no sense. Try this.

    if(
  isnull(fv!row['recordType!OCSC Nonclinical Service Tracking Entry.fields.{team_lead}team_lead']),
  "--",
  user(fv!row['recordType!OCSC Nonclinical Service Tracking Entry.fields.{team_lead}team_lead'], "firstName")
  & " "
  & user(fv!row['recordType!OCSC Nonclinical Service Tracking Entry.fields.{team_lead}team_lead'], "lastName")
)

    Terms & ConditionsAccessibility statement