asked on
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::ListingA
If ( WRCleasecode = 0 or IsEmpty ( WRCleasecode ); ""; WR_Vacs4Notes::ListingAgen
If ( BusProfileCode = 0 or IsEmpty ( BusProfileCode ); ""; WRCBusinessSales::ListingA
-Autofill.JPG
If ( WRCpropcode = 0 or IsEmpty ( WRCpropcode ); ""; WRCPropertySales::ListingA
If ( WRCleasecode = 0 or IsEmpty ( WRCleasecode ); ""; WR_Vacs4Notes::ListingAgen
If ( BusProfileCode = 0 or IsEmpty ( BusProfileCode ); ""; WRCBusinessSales::ListingA
-Autofill.JPG
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.