Compare fields from two different models in a ui-only field

Hi Tami

I created a page using 2 models.  I created a Ui Only Field in the first model and set the display type as formula and the Formula Return Type = checkbox.

I created a second Ui Field and chose the Display Type as Reference and pointed it to the Object that I want to compare fields with a filter to drill down to the record.

I used the following formula for the first Ui Only Field:

IF( {{field_1}} != {{UiReferenceField}}, false, true)

Hope this helps?

Hi Greg,

Thank you for the great directions, you pointed me in the direction I needed to go! 


I had to change the reference ui-only field to a formula field looking to a model. I needed to lookup to a model and not an object because I needed the conditions set in the model to be taken into consideration. 

I am using this to render an icon on a drawer icon to only show if there is data in the drawer.


Explanation:

1. Created a page using 2 models, but the ui-only fields are on the same model.

2. Created a Ui Field and chose the display type as formula and the Formula Return Type = Text. The formula will pull in the results from the second model so I can compare fields.

3. Created a Ui Only Field and set the display type as formula and the Formula Return Type = checkbox.
 


Here is the final result:

Ui-Only field 1:
MODEL_LOOKUP(“Model that I want to pull results from”,“field”,“field”,{{field}})

Ui-Only field 2:
IF( {{field__c from model}} == {{Ui-Only Formula Field 1}}, 1, 0)

Hope this helps someone!