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/t/how-can-you-check-for-null-and-or-if-the-field-exists-in-a-…
Question
How do to check reference field value is blank in UI formula fields?
+4This topic has been closed for replies.
+3Okai, 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?
+4Return 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
+3Can you try to update to the latest version? I copied your formula and it is working fine for me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.