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 drop down list pull from Txt or external file.

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

79 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Have not used VFE in a while and need help with the function to have a drop down list pull from a list contained on an external text document or a document contained in the document section of CPS.

can somebody help with this?

Thank you.

Posted : September 20, 2016 4:55 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Here is one of mine. Contents of file is something like this: "doc_first_name\, doc_last_name, next_doc_first\, next_doc_last, ...etc"

Code in VFE:

{global doc_list} {DOCUMENT.DOC_LIST}

{! if doc_list <> "T" then local fhnd fhnd = FILEOPEN("\\\\server_name\\share_folder\\external_doc_list.txt", "r") if fhnd <> NULL then DOCUMENT.DOC_LIST = FILEREAD(fhnd) endif FILECLOSE(fhnd) doc_list = "T" else "" endif }

Where DOCUMENT.DOC_LIST is the dynamic document variable for the drop down. I have it set to run every time the encounter is opened (because the list changes fairly often). You could change this to run once when the document is opened by not using the global variable and just checking if DOCUMENT.DOC_LIST has something in it.

Posted : September 20, 2016 5:13 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Glad to help you. I can set up a WebEx to step you through the process. Contact me directly.

Posted : September 20, 2016 6:02 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Thank you mike.

is there is any way to have it pull from a document held inside CPS text component section??

Posted : September 20, 2016 6:04 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Are you wanting to have the Text Component run the code listed above or are you wanting the text that is contained in the Text Component be parsed into a dynamic drop down?

The latter would most likely require a SQL query or custom mldef function created to get to that data. Which can be done, it just isn't an ideal place to keep this information.

Posted : September 20, 2016 6:16 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

text be parsed in the drop down list, the same way it was done on that function you specify earlier but instead of having it pull the list of value from an external files. Have it pull from values contained in a Text component.

Posted : September 20, 2016 8:43 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

You could just add my code to the text component and instead of pulling from a file (FILEOPEN) and reading it (FILEREAD), you assign the drop down items with DOCUMENT.DOC_LIST = "item 1, item 2, item 3."

You could insert the text component with this form with ADD_TEXT_COMP to populate the drop down. The drop down will need to have the checkbox "Make available to other forms" checked. It seems to be a more cumbersome method, though.

Posted : September 20, 2016 10:38 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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