The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/showthread.php 26 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/showthread.php 137 forum_permissions
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key "mybb" - Line: 1952 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1952 errorHandler->error
/inc/functions_indicators.php 41 my_set_array_cookie
/showthread.php 629 mark_thread_read
Warning [2] Undefined property: MyLanguage::$ratings_update_error - Line: 5 - File: showthread.php(732) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(732) : eval()'d code 5 errorHandler->error
/showthread.php 732 eval
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 784 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 784 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "invisible" - Line: 1506 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1506 errorHandler->error
Warning [2] Undefined variable $threadnotesbox - Line: 30 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 30 errorHandler->error
/showthread.php 1533 eval
Warning [2] Undefined variable $addremovesubscription - Line: 79 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 79 errorHandler->error
/showthread.php 1533 eval



FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Several New Suggestions
#1
I would like the internal forms be able to be used as public web pages, or the views of internal forms as public web pages. Having said that, There are several things I would love Form Tools to do:

1. Multiple page forms with the ability to add html or text before or after the form page on to the next page of a form.

2. Subforms. Instead of having one form that has event title, event description, contact name, contact phone number... ect.. that you would have a subform for contact name, contact phone number => stored as a separate form. It would be great if subforms were searchable, so everything you add in a subform could be searched and then added on the main form. Permissions could restrict what you can search for by just what you (a single client) entered in previously. Finally, a subform could be single or multiple. Like multiple contacts listed (more than one) or a set limit of subform entries (3) for example. That would be fantastic!

3. Can an option selected in one form, create a new record in another form. A telephone call form if "contact" is selected in turn creates an incident record in the "incident" form. for example.

4. Can an option list be another form? This would allow for dynamic option lists.

5. I found that "Client user" entered in information - form tools does not show or log that Smmedia - a client account entered that record into that form. Interesting. Now when I edit as an administrator account, form tools does not show edited by administrator Dave. Program does not know who enters what on what form, or keeps track of the various form versions of a record. (who edited what and what was the initial submission.) Would be nice to have this level of tracking, could be very useful to know who enters what, and when information changes from version to version of the record.

6. Archive button on view submissions page - send record to an archive/archival database of records. I guess you could do this as an option field.

7. Have views that display on the page (less fields), but when new records are created, all fields of the record are displayed. (Multi-part forms could solve this problem... the view submission page would be a few key fields, and the form would be a longer submission. )

Subforms and being able to create a record in a different form based on an option selection would be wonderful and useful, everything I have said in this post would be used everyday.

Great, thank you. I would love to read your comments and what you think.



Reply
#2
Wow, great suggestions - thanks for the post! Let me just comment on each.

Quote:I would like the internal forms be able to be used as public web pages, or the views of internal forms as public web pages.

This is actually what I've been devoting all my time to - this last month and more. The Form Builder will let you publish any Form Tools form directly on your site with whatever styles you want. (I must admit, it's awfully cool!). I'll have a video demo out in the next few days to show how it will work, so check the homepage for that.

Quote:1. Multiple page forms with the ability to add html or text before or after the form page on to the next page of a form.

You could do this with the Form Builder, but not with what's currently offered. The options to add arbitrary text are pretty limited: only the "Field Comments" option for each field type, which adds some text underneath the field, when it's being edited.

Quote:2. Subforms. Instead of having one form that has event title, event description, contact name, contact phone number... ect.. that you would have a subform for contact name, contact phone number => stored as a separate form. It would be great if subforms were searchable, so everything you add in a subform could be searched and then added on the main form. Permissions could restrict what you can search for by just what you (a single client) entered in previously. Finally, a subform could be single or multiple. Like multiple contacts listed (more than one) or a set limit of subform entries (3) for example. That would be fantastic!

This sounds kind of like Views. Couldn't you create multiple Views within a form that contain those subsets of the fields, and assign permissions etc. accordingly? Each would store the data in the same form, so it's kind of like what you need, no?

Quote:3. Can an option selected in one form, create a new record in another form. A telephone call form if "contact" is selected in turn creates an incident record in the "incident" form. for example.

Ah!! Yeah, this has been on my list for a looong time. What I have planned is a "Extended Field Mapping" module that lets you achieve this, effectively turning Form Tools into a relational database. But it's still a ways off yet. Good to know there's interest, though.

Quote:4. Can an option list be another form? This would allow for dynamic option lists.

Yes, absolutely. For radio buttons, checkboxes, dropdowns and multi-select dropdowns, you can choose the data source to be from the field in another form. This was added in 2.1.0. You can find that setting in the Edit Field dialog window on the Edit Form -> Fields tab.

[quote[Program does not know who enters what on what form, or keeps track of the various form versions of a record. (who edited what and what was the initial submission.) Would be nice to have this level of tracking, could be very useful to know who enters what, and when information changes from version to version of the record.[/quote]

Have you checked out the Client Audit and Submission History modules? They track the activity of client accounts and track changes to the submissions.
http://modules.formtools.org/client_audit/
http://modules.formtools.org/submission_history/

Quote:6. Archive button on view submissions page - send record to an archive/archival database of records. I guess you could do this as an option field.

Yeah, I've toyed with the idea of adding some sort of archiving option for a while. I'd like to see it implemented in a number of ways. First, be able to archive an entire form, which would take it offline & hide it from the main Forms page. Secondly, I'd like to archive old submissions - like you suggested - which prevent them from showing up. All archived information should be exportable and de-archivable. But honestly, it all comes down to priority - this is too low a priority to focus on right now. But again, good suggestion!

Quote:7. Have views that display on the page (less fields), but when new records are created, all fields of the record are displayed. (Multi-part forms could solve this problem... the view submission page would be a few key fields, and the form would be a longer submission. )

I don't quite follow this one. Would this be for the initial "Add Submission" page? So the database record wouldn't be created until those (fewer) fields have been entered? e.g. you could have a first name + last name field, which after submitted, would take you to the Edit Submission page containing all the fields? Hmm.. maybe a dialog window for the Add Submission step containing the fewer fields. Neat. That would actually be pretty useful & I know the current way it works confuses some people. Right now when you click add, the submission is created even before you've added any values. Despite the message that's displayed, some people don't read it & don't realize the submission is already created.

Great idea.

- Ben



Reply
#3
(Nov 17th, 2011, 12:01 PM)Ben Wrote:
Quote:4. Can an option list be another form? This would allow for dynamic option lists.

Yes, absolutely. For radio buttons, checkboxes, dropdowns and multi-select dropdowns, you can choose the data source to be from the field in another form. This was added in 2.1.0. You can find that setting in the Edit Field dialog window on the Edit Form -> Fields tab.

Wait, so you're saying that a checkbox in Form #1 could actually be a separate form with it's own process?

Not a FT employee, just a FT user lending a hand. If I've been helpful, please rate.

[Image: giraffe_long_85.gif]
Reply
#4
(Nov 17th, 2011, 8:51 PM)michatmaster7 Wrote:
(Nov 17th, 2011, 12:01 PM)Ben Wrote:
Quote:4. Can an option list be another form? This would allow for dynamic option lists.

Yes, absolutely. For radio buttons, checkboxes, dropdowns and multi-select dropdowns, you can choose the data source to be from the field in another form. This was added in 2.1.0. You can find that setting in the Edit Field dialog window on the Edit Form -> Fields tab.

Wait, so you're saying that a checkbox in Form #1 could actually be a separate form with it's own process?

I would love to see subforms, where you have a form called forum, and the subform called topic (a form) --- so you could have a list of forums, and each forum has a listing of topics, subform of topics could be a poll forum, commment forum.

Also would love to have subforms made from existing records in other forms. If you have a Telephone Call Form, the Contact is from the "Contacts" Form, so for every telephone call you log, your not writing down the contact information every time. (relational database .... so cool... thanks! I need some of your features ASAP!)

Also, How does form tools scale? Can it scale?

Finally, Mr. Ben, is there a way to export the form creation data so you can export creation of the form to another form tools installation (if you have TEST and PRODUCTION versions of Form Tools on your system, or export your Form to a 3rd party application that would read the Form Tools Form, and create the database tables in the other application.

Thank you. I do not know programming well enough to create what I want, but I know a little bit here and there. I would like to use form tools as the basis for my website, and I think form tools will do a fantastic job once I figure out how to get it all done.

At some point I would like to have additional capital from the business to pay a programmer to expand what I can offer. The fact FT is GPL'ed is helpful. Thank you so much.

I am still trying to learn how to use form tools. Smile Pardon for some of my stupid questions!


Reply
#5
(Nov 17th, 2011, 8:51 PM)michatmaster7 Wrote: Wait, so you're saying that a checkbox in Form #1 could actually be a separate form with it's own process?

Not sure I follow you, actually! What I mean is that the values that are entered in a checkbox in form #1 can be used to populate the contents of another Option-List driven field (checkboxes, radios, dropdowns, multi-selects) in form #2. I touch on it here:
http://docs.formtools.org/userdoc2_1/ind...ultiselect

Quote:Also, How does form tools scale? Can it scale?

Yes, but not in all respects. For example, you can populate the database with as many submissions as you like. Things will get slower eventually (of course), but submissions can keep pouring in without any noticeable hit to speed. However, aspects of the script - like the Export Manager, especially, which lets you export the entire database table content, will get VERY slow fast. But that's easily remedied: you'll just need to export subsets of the data at a time.

Also, you can currently run Form Tools in a server pool (i.e. multiple servers) by using database sessions instead of PHP sessions.

But in all honesty, I haven't ran Form Tools with massive data sets - only up to 10's of thousands of form records. That covers 99.9% of our user requirements right now, so I have to focus on what's needed.

Quote:Finally, Mr. Ben, is there a way to export the form creation data so you can export creation of the form to another form tools installation (if you have TEST and PRODUCTION versions of Form Tools on your system, or export your Form to a 3rd party application that would read the Form Tools Form, and create the database tables in the other application.

Just "Ben", not Mr. Ben. Smile

Unfortunately not - not yet, at least. You'll need to do a manual copy of the database tables + content.

However, I do have something like this planned. I've been working on a "Shared Resources" module, alongside the Form Builder module. This module will allow Form Tools users to share Form Tools-related information via the website. Initially, it's just going to support sharing of Option Lists (so you can just import them rather than having to type them out yourself), then later, Form Builder Template Sets - which are used to control the appearance of forms generated by the Form Builder.

But later on, I'd like to add in entire form configurations to allow people to share their entire form configurations.

But this is MUCH later on!

- Ben
Reply
#6
(Nov 17th, 2011, 12:01 PM)Ben Wrote:
Quote:2. Subforms. Instead of having one form that has event title, event description, contact name, contact phone number... ect.. that you would have a subform for contact name, contact phone number => stored as a separate form. It would be great if subforms were searchable, so everything you add in a subform could be searched and then added on the main form. Permissions could restrict what you can search for by just what you (a single client) entered in previously. Finally, a subform could be single or multiple. Like multiple contacts listed (more than one) or a set limit of subform entries (3) for example. That would be fantastic!

This sounds kind of like Views. Couldn't you create multiple Views within a form that contain those subsets of the fields, and assign permissions etc. accordingly? Each would store the data in the same form, so it's kind of like what you need, no?

Subforms.... on a new record of a form with form id of 5, then on your add record form you have another form in the form that references id=5 so contacts are a separate form, but all have and id =5

My Form
My form id = 5
my form name
my form description... addtional fields...
contacts form
with form id = 5, contact1 name + additional fields of contact form
with form id = 5, conact2 name + additional fields of contact form
with form id = 5, conact2 name + additional fields of contact form

.... as many contacts as you have
Sub-forms!
second subform locations
with form id= 5 location one

forms within forms when you need more than one of something. like multiple phone numbers to a single record.


Do you understand now?

How are you coming with the new module?





Reply
#7
Slowly, but well! It's pretty amazing, but there's still a great deal to do. I just got back from my trip yesterday and I'll be spending the next day or so taking stock of where we're at and scheduling work for the next few weeks.

I see what you mean with sub-forms now. I really like it! That's actually a really nice way to tie multiple forms together. I was originally thinking of approaching it from the opposite direction, to let you create an entry in the "sub-form", then map it to the original by identifying it somehow (e.g. via a dropdown of all entries in the first form). But your approach is actually much more intuitive - starting with the original form.

Thanks for the idea!

- Ben
Reply
#8
(Dec 4th, 2011, 1:50 PM)Ben Wrote: Thanks for the idea!

- Ben

Thank you for your great program!



Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)