Forum Discussion

sfountain's avatar
sfountain
Qrew Cadet
5 months ago

Grabbing value between 2 fields

Hi, I'm trying to create a text formula field that would compare 2 text lookup fields for an employee name. So if there isn't a value in field A, it will pull a value from field B or vice versa. For...
formulas
  • sfountain's avatar
    sfountain
    5 months ago

    Thanks for the quick response, Mark! That seems to work!! I was over complicating it to say the least.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

To check a numeric field type for blank, you can't compare to empty quotes.  That only works for a text field type.

 

Set the field properties fir that max Recird us field on the relationship to not treat blank as zero.

 

then change yiyr furnuks to this

 

If(not IsNull([Sensitivity Check - Max Record ID]), [Sensitivity Check - Max Record ID], [Med Eval Questionnaire Intake - Maximum Record ID#])

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 months ago

To check a numeric field type for blank, you can't compare to empty quotes.  That only works for a text field type.

 

Set the field properties for that Max Record ID field on the relationship to not treat blank as zero.

 

then change your formula to this

 

If(not IsNull([Sensitivity Check - Max Record ID]), [Sensitivity Check - Max Record ID], [Med Eval Questionnaire Intake - Maximum Record ID#])