nrsmoll
Member
I've been working to create a medical app (CRUD app) to be used for research. You can see the basics at painclinicsofaustralia.com. (Joomla 3.7 and Fabrik 3.7)
I come from the research and analytics field, and have some app development experience in filemaker (though long ago). This is my first web app. I would consider myself inexperienced, but keen as mustard because of the possible uses of this application.
The app is to be used to input patient details (list=main), visit notes and types of contact (list=visits) with several associated outcome measures. I have a textarea element to put in information about each visit using a WSYWYG editor (great module/addition btw), and I would like it to be able to create a printout or pdf form of each visit (with the summary statistics of the outcome measures), and a separate pdf form for each of my procedures.
Question 1) What is the best overall approach to join methods to create the most userfriendly app.
So far, in my main list, I have created a 1:M left join to visit list. And then, I have created multiple joins in the Visit list, one left join for each of the outcome measures.
The joins are:
1) Main List: Main -> 1:M -> Visits
2) Visit List:
Visits -> 1:1 ->
The problem with this method is that I end up creating lots of records (32/64 or 128) when I input a record and fill out all the details. And I have difficulty retrieving a single visit to update the details within.
I have also tried a single list, with the visits and outcomes joined to the one list (list=main).
I am not sure which is the best way of doing this.
2) I would also like to create a list view where I see only the visit records (list=visit) that were searched using info from the "main" list (related records) and then visit records are shown, and I can choose which one to create, update, edit or delete. I imagine it would be using a list view of visits tied to the main menu. But each time I have tried this, I get errors, and I don't have the "main" list info in the "visits" list view to search from.
For you guys, this is very basic stuff, and I have been wasting a lot of time trying different methods, and while that was good to learn the basics of fabrik (have watched all the tutorials), I would like some advice from experienced people to help guide me forward, and get me on the right track.
I'd be happy to organize a formal login to the website if it is required.
Nick
__________
This is a question about a feature
3) Is there a module that creates a "stamp" like function (or auto-complete/enter, but only where my cursor is)? It would be a button (or several buttons) that would "stamp" or auto-input information into the WYSWYG editor (textarea) element? Like a summary statistics from several tables, or a predefined template of free text? The button would be tied to a table of templates possibly.
I come from the research and analytics field, and have some app development experience in filemaker (though long ago). This is my first web app. I would consider myself inexperienced, but keen as mustard because of the possible uses of this application.
The app is to be used to input patient details (list=main), visit notes and types of contact (list=visits) with several associated outcome measures. I have a textarea element to put in information about each visit using a WSYWYG editor (great module/addition btw), and I would like it to be able to create a printout or pdf form of each visit (with the summary statistics of the outcome measures), and a separate pdf form for each of my procedures.
Question 1) What is the best overall approach to join methods to create the most userfriendly app.
So far, in my main list, I have created a 1:M left join to visit list. And then, I have created multiple joins in the Visit list, one left join for each of the outcome measures.
The joins are:
1) Main List: Main -> 1:M -> Visits
2) Visit List:
Visits -> 1:1 ->
Procedure
Outcome Measure 1 (eg. EQ5D or VAS)
Outcome Measure 2
Outcome Measure 3
Outcome Measure 4
Outcome Measure (N), for "N" numbers of outcome measures.
Outcome Measure 1 (eg. EQ5D or VAS)
Outcome Measure 2
Outcome Measure 3
Outcome Measure 4
Outcome Measure (N), for "N" numbers of outcome measures.
The problem with this method is that I end up creating lots of records (32/64 or 128) when I input a record and fill out all the details. And I have difficulty retrieving a single visit to update the details within.
I have also tried a single list, with the visits and outcomes joined to the one list (list=main).
I am not sure which is the best way of doing this.
2) I would also like to create a list view where I see only the visit records (list=visit) that were searched using info from the "main" list (related records) and then visit records are shown, and I can choose which one to create, update, edit or delete. I imagine it would be using a list view of visits tied to the main menu. But each time I have tried this, I get errors, and I don't have the "main" list info in the "visits" list view to search from.
For you guys, this is very basic stuff, and I have been wasting a lot of time trying different methods, and while that was good to learn the basics of fabrik (have watched all the tutorials), I would like some advice from experienced people to help guide me forward, and get me on the right track.
I'd be happy to organize a formal login to the website if it is required.
Nick
__________
This is a question about a feature
3) Is there a module that creates a "stamp" like function (or auto-complete/enter, but only where my cursor is)? It would be a button (or several buttons) that would "stamp" or auto-input information into the WYSWYG editor (textarea) element? Like a summary statistics from several tables, or a predefined template of free text? The button would be tied to a table of templates possibly.
Last edited: