If I want to build 5 similar layout based forms, is there a way for me to first manually build one (add groups/fields), and then duplicate 4 new layout based forms from the initial one? Then I can just go in and selectively modify certain fields in those 4 new layout based forms. This will save me quite a bit of time spending to manually create group/fields for all 5 of them.
If there is no option in openEMR to do this, is there a way I can go to the mysql database and duplicate there? I am not sure which table/row I need to duplicate…
If you are not building NationNotes, there are just the layout_options and list_options tables to contend with.
Take a look at the layout_options table, page 5 and note the last field.
Do the same for the list_options table, page 30.
You want to know where the existing LBV forms end and your new form begins.
Create the first form in 4.1.1. Exclude the fields from the old forms in the new .sql files and export them from phpMyAdmin.
Import .sql file into a test copy of OpenEMR. Be certain to that the .sql files don’t contain information about the other forms; if not, they won’t import properly. If you are going to use a production copy, backup first.
Change the name of the new form in Administration/Lists/Layout Based Forms, modify the form and create .sql files for the new form.
The phpMyAdmin’s in the 4.1.2 and 4.1.3 Demo’s don’t work. If you must know why, we’ll have to find that thread. It has to do with the version of PHP being outmoded. The one in the 4.1.1 Demo tends to be erratic as well. An alternative is to have OpenEMR on 2 different drives.
If you are familiar with MySQL Workbench, I’ve been told it’s a more efficient way to go about this. There are shortcuts in phpMyAdmin, but I’ve not tried them yet.
If you are creating NationNotes, we will elaborate in another post.
fsgl - thanks. There is no nation note involved. Still looks like quite a bit of work. I will spend some time to explore it out. Was hoping there is a simpler way to just make a copy of an existing row in a sql table and rename it.
What is the secrecy? Can’t you make a form in a easy to handle software package like Note-pad and show us what you want… by now you spend so much time on explaining what you think is easy, and OpenEMR users and Developers spend so much time on explanation, it seems to me we are talking in different languages.
BTW Radio buttons are used for the simple YES NO choices to be taken from a list of choices, no typing involved, just make a choice. The OR function used in Basic-DOS for real old timers.
My method is for the folks who don’t know how to code. One does not even have to work in phpMyAdmin if one is a coder. For my part, I can’t visualize the changes in a form without looking at the form itself and the layout. But go ahead and experiment in phpMyAdmin. I’m sure you will be able to figure out a simpler way. If one knows how to code, one can fly. The rest of us will have to be content with just crawling.
One advantage of my method is that should you wish to revert to a previous form, it can be easily accomplished. Sometimes, working in the module and deleting the form, one may find later that the other form was better, after all.
If not successful; come back, post a screenshot and we will try to help.
Hi Pimm,
You’re thinking about Ed Landau’s thread. Thanks for reminding me about the radio buttons again. Actually, you had explained it to me previously when you had that little tête-à-tête with Art Eaton. I had forgotten that the radio button functions like a listbox and that a list must be associated with it to work.
I just made your instructions for “a copy” to the end of LBV-Forms instructions. You are referring to page 5 and 30 but can we make a www referral for these page so they are a clik away?
Will links to the pages 5 and 30 of the tables work given the fact that one has to login to get to phpMyAdmin of the 4.1.1 Demo? If it is not possible, screenshots can be inserted to illustrate the point. Brady had warned us that the Demo’s may keel over and die any day now. With the demise of the Demo’s, the links would lead nowhere.
Your wiki article has grown substantially. Would you consider adding a table of contents at the beginning? There is a little trick involved. If you use 2 equal signs (=) before and after the subtitle, the table of contents will appear automatically and magically.
There is a lot of information in the article. Often readers may need to review a certain section while they are building the form. When a reader clicks on a particular section in the table of contents, the webpage goes directly to that section without having to scroll all the way down.
Additionally, if one is providing a link to a section, the URL will reference that section instead of the beginning of the article. This provides a better experience for the reader.
For the author, editing is much easier as well. One can just edit the particular section without scrolling.
OK - here is what I found that worked for me. It may not worth for building 5 tables but if you have 50 tables with similar structure, you will definitely save some time from doing this:
(1) Find the rows of form1 that you want to copy in the table Layout_options;
(2) Export those selected rows to csv;
(3) Modify the csv file to make it as form2
(4) Import the csv file to table layout_options
(5) Make any further change necessary to the groups/fields of form2
your extra info is also included in the WIKI on Lay-out Based Visit forms.
If you want to make a change in the text, feel free to do it yourself or send me a message
I’ve taken the liberty of inserting the first two links from my prior post as a third way to copy a database and doing a bit of editing.
To give a more consistent look to that section, I used the same formatting for the 2 numbered lists. A quick and easy way to number a list is to use the pound symbol (#) after the indentation formatting. The numbering is done automatically and should the sentence run over 1 line, the balance of the sentence is properly indented giving a neat layout.
I was unable to embed the video tutorial because the website is not a proper service like YouTube, hence there is no way to embed it into the LBV webpage nor in the “Videos and Animations” webpage.
