- theanhdbtAsked on March 23, 2012 at 04:47 AM
How can we create same ID for different form? (not automatic ID, but type-in ID instead)
IDs I use in my form is somewhat special (combination of ext and number), thus,
they all will be typed in by the users by hand (cannot be automatic)
a) You may ask me why don't I use one form instead of many forms.
My answer is that because I use total function which belongs to payment tool
(payment tool not allow to create more than one field of payment in one form).
b) Then, you may ask me why don't I use grading tool which also has total function.
My answer is that I cannot use grading tool, because we cannot control value for each
option in grading-tool field (it can only control value of total)
c) In my previous question, jotform used to recommend me to use matrix table and then multiply by each column by an assign number, but I see this is not convenience
(regarding my form (questionaire) the form will have lots of question (option) correspondent to each row, and four column (options) with different score assigned for each column)
All my recent questions have relation, and I try to sought out a way suitable with design of my form.
(It is a scientific questionnaire comprising of four tables (matrix table) to assess psychology of clients who come to a clinic. Each table comprise set of questions counselor of the clinic use to ask their patients (on each question, patient has same set of answers – set of options; correspondent to each option is an assigned score) base on the answer each set of question, counselor will be able to give scores to patients (I made it automatically using payment tool) and diagnose his symptoms to draw out appropriate treatment (I made it automatically using Hide/show function).
Thanks for support,
- JotForm SupportjonathanAnswered on March 23, 2012 at 04:53 AM
Hi The Anh,
It seems you wanted to create your own Form ID. Will the Hidden Box in Power Tools enough to your need? You can put the Hidden Box of similar value on all your Forms.
- theanhdbtAnswered on March 23, 2012 at 05:10 AM
I don’t think that what my form require.
For example, I have form1 with an ID field.
I also have form2 with an ID field.
For each patient we meet, we have to fill in both form (which would be only one form, because of some reasons I described above) ID of the patient. Then, the requirement is that ID in two forms for each patient should be only one ID. Question: instead of inputting ID for the second time, do we have some way to make somewhat like “relation” in access database to make it understand that these both form were completed for the same patient?
More (but not important) about ID we use: it is an ID that medical staff in my clinic has to fill in to help identify our patient.
Many thanks for your all kind and well-done support service.
- gori-mathewAnswered on March 23, 2012 at 05:35 AM
There may be aworkaround on this but it may require some knowledge on PHP to link the two forms.
I have some links of previously answered question to guide you on this issue;
Kindly go through this links and feedback to us if this helps out!
- JotForm SupportjonathanAnswered on March 23, 2012 at 05:41 AM
Ok, now I understand. It is not Form ID, but an ID field.
I think for what you wanted, you will need to have a repository for the data records. You already mentioned database, this could be a requirement because you need to store data, which JotForm doesn't have. To achieve this you might need some PHP application to pull data from the database and display it in your Forms. The similar thing that JotForm can do is like this : Prepopulating the fields to your JotForm via URL parameters. But this is only between 2 Forms, not from a recordsets or database.
You may also want to check the JotForm Reports. For your submitted Forms you can generate a Report. There are several types of reports, but I think what is ideal here is the Excel type. As you can use an Excel as a data source. If you can find means to put your Excel on a web page(there are several ways), you can then design your Form to filter the records from Excel (use the ID field) to display related informations on the Form.
Hope this help you in any way.
- theanhdbtAnswered on March 23, 2012 at 05:50 AM
Thanks all for your kind help. Jotform are the best web page I see up to know regarding the friendliness it offer in its' tool and support service (As this is my first time asking so many question on a forum, I really really appreciate all your prompt help). The tool available on Jotform also the best tools I can find on web up to now (easy to use and nice platform).
I think all will be work out more easy if I have a bit knowledge on web language...
Thanks so much,
- gori-mathewAnswered on March 23, 2012 at 05:52 AM
Thanks Anh for your compliments, on behalf of support team kindly know that we treasure our clients so much.
Looking forward to work with you more and thanks for choosing Jotform!