Patient Database - Help requested !

[drahmad]

This is ahmad, I m working as International Physician Observer at university of miami division of cardiology ,department of medicine.

I am in a process of establishing a registry for Aortic Valve cases, its actually a databases which would be used for research and analysis and following outcomes.

For this we need a solution, that users can enter the data online.

While browsing web, i came across your website, and i have following questions for you.

1. I want to make user interface. i.e. a user has to login to fill in the form, no entries from the public.

2. it will be a multi page forms with over 200 data fields. is form tool going to support such big number of fields. my question is how to link all these fields and entries on different pages, as single patient record.

3. i need different privileges for different users. e.g.
Admin : has all privileges.
Mr X : can view & enter & edit the data on forms he is assigned to.
Mr Y : can only enter/edit the data he is assigned to.

which software is best to design the forms.

what i have figured out is that i have to design the forms priorly before they can be integrated with each other using form tools.

if some one has similar experience please email me at drahmad at live dot com


regards.

Ahmad.

---

also guide me how to make forms like

http://demo.formtools.org/forms/registration/


which html/php web writing tool has been used in making this page.

[drahmad]

i m encountering one more issue, i cannot go and see the properties of modules, whenever i click select to make changes in some modules, it brings me back to forms main page.

[Ben]

Hi Drahmad,

Thanks for the post. Very interesting use for Form Tools!

1. I want to make user interface. i.e. a user has to login to fill in the form, no entries from the public.

Sure, there's two approaches.
1. You could create your forms and add your own security through a separate script.
2. You could add the forms to Form Tools, then set up accounts for everyone who'd be logging in. They could then log in, pick the form and add their own submission directly through the interface.

2. it will be a multi page forms with over 200 data fields. is form tool going to support such big number of fields.

Yes, that's no problem.

my question is how to link all these fields and entries on different pages, as single patient record.

Good question. If you create your own form, of course you can arrange the fields in whatever order and page groups that you want.

If you use Form Tools, you can group the fields into separate tabs. This is a convenient way to simplify the UI for the user so they can enter in the info tab by tab. *However*, note that tabs don't require your users to enter in all the data, nor in a specific order.

3. i need different privileges for different users. e.g.
Admin : has all privileges.
Mr X : can view & enter & edit the data on forms he is assigned to.
Mr Y : can only enter/edit the data he is assigned to.

Sure, no problem! You can create as many client accounts as you want - each one assigned to different forms, and even different "Views" within those forms. Views let you limit what actual fields appear for each client, so one client can only see and edit a subset of all the total form fields.

which software is best to design the forms.

Ah! The $64,000 question! I hand-code all my forms, so I'm not up to date on all the form builder scripts out there these days. But I hear good things about Dreamweaver and the latest version of Microsoft Expression Web.

i m encountering one more issue, i cannot go and see the properties of modules, whenever i click select to make changes in some modules, it brings me back to forms main page.

Hmm... that doesn't sound right... So when you're on the Modules page and click the "SELECT" link for a module, it directs you to the Forms page? I can't see how that would ever occur...

- Ben

[drahmad]

Thanks a lot Ben, it was so nice of you to reply in detail, sorry but i have a question again !!

you wrote " If you use Form Tools, you can group the fields into separate tabs. This is a convenient way to simplify the UI for the user so they can enter in the info tab by tab. *However*, note that tabs don't require your users to enter in all the data, nor in a specific order. "

so is there any way i can make forms in form tools, what i m doing rite now is i make forms in front page and then later configure fields in form tools.

regarding the last issue with modules, i can send you my admin login, you can login yourself and see what i m telling is really happening

thank alot once again for your kind reply!

[Ben]

Hi Drahmad,

No worries! And sure, if you want to create forms within Form Tools, you'll want to download this module:
http://modules.formtools.org/blank_form/

When installed, that adds a button to your Forms page labeled "Create Blank Form". That creates a form that you can configure manually within Form Tools. You won't need to create an actual form *i.e. a form on your site somewhere) that way.

(By the way, 2.1.0 will improve on this by differentiating between "internal" and "external forms... but I'll make a post about that a lot later!)

Hope this helps!

- Ben