asked on

FM - Autofill per 3 Different Options

I am trying to autofill the agent's intials based on 3 different related field codes appearing. Below is my calc. If I do any one of these it works, but when I try to use all three, I keep getting a 0 placed in the Agent Initials field. Now each of these 3 related code fields does get an autoenter of a 0 to begin with; however, why would that get entered into the Agent field based on the formula below? Quite the mystery. See also screen shot.

If ( WRCpropcode = 0 or IsEmpty ( WRCpropcode ); ""; WRCPropertySales::ListingAgent) or
If ( WRCleasecode = 0 or IsEmpty ( WRCleasecode ); ""; WR_Vacs4Notes::ListingAgent) or
If ( BusProfileCode = 0 or IsEmpty ( BusProfileCode ); ""; WRCBusinessSales::ListingAgent)
-Autofill.JPG

ASKER CERTIFIED SOLUTION

Will Loving

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rvfowler2

ASKER

Actually, I wan't clear enough. I simply want that if it is empty or 0 to do nothing and if it is greater than 0, then entering the ListingAgent field from the respective related record. There is no hierarchy: I am trying to get the Notes page to autoenter when I enter the record from the portal in these respective layouts.

Will Loving

Treating it hierarchically isn't necessary for it to work. I think my calc will still work for you. Give it a try.

rvfowler2

ASKER

Yes, worked perfectly. I've just been having an off couple of weeks.