Welcome to the NEW Community Healthcare User Group ( the new CHUG)— your ultimate destination for insights and discussions at the intersection of healthcare and technology.

Please scroll to the bottom for “Centricity” related topics from the previous forum.

Notifications

Clear all

VFE - Pull Service Provider Address and Phone Number

Trading Post

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

104 Views

RSS

angelahunsberger

(@angelahunsberger)

Posts: 290

Reputable Member

Topic starter

Cry Hi CHUG,

I have this form where it pulls a list of all Service Providers from a drop down.

I can't figure out how to pull the address and phone number associated with the Service Provider in the text translation.

Can anyone help me? Here is the DLG file SERVICE PROVIDER DROPDOWN

If it's easier you can email me at [email protected]. I can send you the clinical kit if you need it.

thanks in advance!!

Posted : December 12, 2013 3:59 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

Hi Angela,

Use "_SearchServProvBus" object instead as defined in mldefs3.txt, it gives the same results and has more options including the two you need.

Object: _SearchServProvBus  Table: SERVPROVORG  Refresh: ROrdersSetup  Hidden
Property: Snapshot //=25
Property: Prepare
Field: SERVPROVORGID     Type: ID    Key Hidden

Field: Name        Type: String Length: 45
           Label: "Organization" Labelsize: -1
Field: ListName     Type: String Length: 45   Hidden
Field: Address1    Type: String Length: 32   Hidden
Field: Address2    Type: String Length: 32   Hidden
Field: City     Type: String Length: 24 Labelsize: 25
Field: State    Type: String Length: 50 Labelsize: 10
Field: Zip     Type: String Length: 10 Labelsize: 10
Field: Country    Type: String Length: 50   Hidden
Field: Phone1               Type: String    Length: 15          Hidden
Field: Phone1Type           Type: String    Length: 25          Hidden
Field: Phone2               Type: String    Length: 15          Hidden
Field: Phone2Type           Type: String    Length: 25          Hidden
Field: Phone3               Type: String    Length: 15          Hidden
Field: Phone3Type           Type: String    Length: 25          Hidden

Formula: labelAddress       Type: String      Hidden
                             Args: Address1, Address2,
         City, State, Zip, Country
                             Watch: Address1, Address2,
         City, State, Zip, Country
Formula: primPhone    Type: String    Hidden
         Args: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type
         Watch: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type
Formula: secPhone    Type: String    Hidden
         Args: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type
         Watch: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type
Formula: faxPhone    Type: String    Hidden
         Args: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type
         Watch: Phone1, Phone1Type, Phone2,
           Phone2Type, Phone3, Phone3Type

Field: EmailAddress    Type: String Length: 50  Hidden
Field: contact    Type: String Length: 50   Hidden
Field: ContactBy   Type: String Length: 1   Hidden
        Out: _contactBy2UI
Field: RefFormType          Type: String Length: 1    Hidden
Field: TestFormType         Type: String Length: 1    Hidden
Field: PrintDest      Type: String Length: 255   Hidden
Field: RefFormPath   Type: String Length: 255   Hidden
Field: TestFormPath   Type: String Length: 255   Hidden

Field: KEYWORD              Type: String Length: 255            Hidden

Variable: searchVar1  Type: String Value: '%'  Hidden
Variable: searchVar2  Type: String Value: '%'  Hidden
Variable: searchVar3  Type: String Value: '%'  Hidden
Filter: keywordFilter1,  KEYWORD LIKE searchVar1  Hidden
Filter: keywordFilter2,  KEYWORD LIKE searchVar2  Hidden
Filter: keywordFilter3,  KEYWORD LIKE searchVar3  Hidden
Order:  'Name'

Posted : December 12, 2013 5:12 am

hintona

(@hintona)

Posts: 36

Trusted Member

Hi Angela,

If by chance you still have the clinical kit for this, I would love to see it! My email is: [email protected]

Thank you in advance! 🙂

Posted : December 21, 2016 2:55 am

vhayes

(@vhayes)

Posts: 44

Trusted Member

Hi Angela,

I would like a copy of this ckt if still available. My email is [email protected]

Thanks V

Posted : January 11, 2017 5:23 am

24 Forums
9,943 Topics
39.9 K Posts
6 Online
6,472 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed