• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • Last Modified:

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
0
rvfowler2
Asked:
rvfowler2
  • 2
  • 2
1 Solution
 
Will LovingPresidentCommented:
Randy,

If I read this correctly, what you are wanting is to enter the Agents Initials if one of these conditions is true, and that some conditions will take precedence over other conditions. If that's correct, then you would want to do something more like the following:

Case (
not IsEmpty ( WRCpropcode ) and WRCpropcode <> 0 ; WRCPropertySales::ListingAgent) ;
not IsEmpty ( WRCleasecode) and WRCleasecode <> 0; WR_Vacs4Notes::ListingAgent) ;
not IsEmpty ( BusProfileCode ) and BusProfileCode <> 0 ; WRCBusinessSales::ListingAgent
)

This progressively adds the agent details based each of the conditions. You can change the order if necessary.
0
 
rvfowler2Author Commented:
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.
0
 
Will LovingPresidentCommented:
Treating it hierarchically isn't necessary for it to work. I think my calc will still work for you. Give it a try.
0
 
rvfowler2Author Commented:
Yes, worked perfectly.  I've just been having an off couple of weeks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now