Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

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

87 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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

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

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

Powered by wpForo Powered by wpForo version 2.4.0