Notifications
Clear all
Topic starter
We have dozens of forms that require the user to select a specific providers initials from a drop down list and that selection determines the results of a bunch of other functions. Anytime we add or drop a provider I have to go into each form and edit the drop down list manually. Could anyone tell me of a way to create the list once, maybe in the function library, and then have each form populate the correct drop down options. Thank you!
Posted : September 16, 2016 7:47 am
I've used a text files that is read at the time of form load which populates the dropdown. The text file is on a shared drive. This requires the text file to be maintained only once. Be glad to share the code with you.
The second more elegant approach is to directly query the USRINFO table and retrieve all physicians. This is done by creating an appropriate SQL query and calling an exe via a RunTextProcess() the queries the database and returns the list. The advantage of the approach is that it can be used to retrieve any information from the Centricity database and it does not require any text file maintenance. The disadvantage is that you must be able to create the appropriate SQL statement. The other disadvantage is that it introduces one more element of complexity in maintaining Centricity versions in that the exe must be located in the Client directory. I would be glad to furnish the code to you or demonstrate it. Feel free to contact me directly.
Posted : September 16, 2016 8:06 am
I do something similar in VFE that shows the user a list of login names for everyone who is a Provider. Our login names look like "asmith" so it's easy to see who is who. In this example, the Location of Care is NFWC.
I check the "Dynamic choice list" option in a dropdown list. The MEL expression is
{GET_USER_LIST("NFWC","Provider","comma")}
Posted : September 16, 2016 9:26 am
I would love to see this code John. Would you mind sharing? My email is [email protected]
Posted : September 19, 2016 10:37 am
I would love to see this code too, John. My email is [email protected]
Thank you in advance!
Posted : December 21, 2016 2:41 am
