How do to check reference field value is blank in UI formula fields?

  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
In UI formula fields on any model, I am unable to check if the reference field is blank or not. The following does not work -

IF( {{refrence__c}} != null, 'Not Null', 'Is Null')

tried this link but does not help - https://community.skuid.com/skuid/topics/how-can-you-check-for-null-and-or-if-the-field-exists-in-a-...
Photo of Sneha

Sneha

  • 624 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Jannik Gysi

Jannik Gysi

  • 594 Points 500 badge 2x thumb
Try to change the formula to:

IF({{refrence__c}}, 'Not Null', 'Is Null')
(Edited)
Photo of Sneha

Sneha

  • 624 Points 500 badge 2x thumb
I have  already tried that and it dint work :(
(Edited)
Photo of Jannik Gysi

Jannik Gysi

  • 594 Points 500 badge 2x thumb
Okai, I'm unable to reproduce that. A few questions for you: 

  • What return type did you specify on your field?
  • Did you check the spelling of your reference field inside the formula?
  • Which version of Skuid are you working on?
Photo of Sneha

Sneha

  • 624 Points 500 badge 2x thumb
Return type is a string only and yes the reference field value is correct. This is what I am trying to do - 

IF( {{Parent__c}} , 'Parent : ' + {{Name}}, 'Child : ' + {{Name}} )

Skuid version is 8.15.4
Photo of Jannik Gysi

Jannik Gysi

  • 594 Points 500 badge 2x thumb
Can you try to update to the latest version? I copied your formula and it is working fine for me.

Photo of Sneha

Sneha

  • 624 Points 500 badge 2x thumb
It works with the latest version. However it was not working in 8.15.4

Thanks :)