Has anybody manged to extract the component parts of the ClientName & ClientAddress Fields?

Comments

5 comments

  • Avatar
    Mark Williams

    Hi Brian, not sure on the Client Name but Client address works as follows (CorrespondenceAddress is the question name):

    [CorrespondenceAddress_AddressLine1_Value]

    [CorrespondenceAddress_AddressLine2_Value]

    [CorrespondenceAddress_TownCity_Value]

    [CorrespondenceAddress_County_Value]

    [CorrespondenceAddress_Postcode_Value]

    You may or may not need the _Value depending on what you're doing with it.

    Hope this helps.

    Mark

    0
    Comment actions Permalink
  • Avatar
    Brian Traynor

    Not sure about this Mark, as we use the system field Client.Address which is populated from an external lookup (E-Postcode). The same principle should apply so i will give it a try.

     

    Thanks for your suggestion, it is appreciated.

    Brian

    0
    Comment actions Permalink
  • Avatar
    Mark Williams

    We also use postcode lookup and Client.Address fields and it works for us. Let me know how it goes.

    0
    Comment actions Permalink
  • Avatar
    Brian Traynor

    Mark...  your guidance got me to the right place. Our system has it stored under [MainAddress] as opposed to [CorresponenceAddress], but the same principles you outlined work.  just got to sort out ClientName now !! :)

    Thanks again

    Brian

    0
    Comment actions Permalink
  • Avatar
    Mark Williams

    I would try Firstname, Lastname and Title i.e. if your field name was ClientName then access these by using:

    ClientName_FirstName_Value

    ClientName_LastName_Value

    ClientName_Title_Value

    Let me know

    Mark

    0
    Comment actions Permalink

Please sign in to leave a comment.