Form Tools - All Forums

Submit Form BUT never leave the page.

bwaye — Wed, 01 Sep 2010 17:06:06 -0700

I have one include to collect form information from multiple sub-domains which are not connected. Does anyone know of a way to submit the form , stay on the page and display a message that the form was received.

Filters question

PhoenixISP — Wed, 01 Sep 2010 11:27:57 -0700

I am trying to set a filter so that certain clients can view only their form submissions. The people filling out the forms often make mistakes with the clients' names. What I would like to do is to filter so that the client can view submissions based on their "Name" or "Promotional Code" entered - but it appears that this system only allows "and" and not "or" when filtering.

Have I missed something? Can this be done?

Thanks in advance,

Sonny

Submission Accounts module not letting users in.

bwaye — Wed, 01 Sep 2010 08:44:32 -0700

The Account is being set-up in the "Submission Accounts" module but it is unable to locate the user. I have tried all of the suggested ways to no avail, which includes adding ?form_id=11 on the end of the URL link and in the

rsv validation

bwaye — Tue, 31 Aug 2010 19:51:12 -0700

I have worked this for hours to no avail. I don't like to post code but this all looks correct to me. This is a CODE submission.

Make WGSIWYG default to EXPERT

bwaye — Fri, 27 Aug 2010 12:15:07 -0700

Far the past 2 years I have never been able to use the SIMPLE setting- i get an error when I change it.

Where in the code or mySQL can I make the default EXPERT.

I have looked everywhere to no avail.

Take submission OFFLINE with out deleting.

bwaye — Fri, 27 Aug 2010 10:29:15 -0700

I use form tools as a CMS. Can I take a submission/post off line without deleting?

File uploads in separate folders per form submission

craven — Fri, 27 Aug 2010 05:42:57 -0700

Hi.

Is it possible to have file uploads be sorted per form submission? In other words: creating unique folders for each submission under the form's main folder.

For example: .../formtools/forms/{$FORMNAME}/files/{$SUBMISSIONDATE}_{$TITLE}

(By the way, is it possible to use reference variables outside of the e-mail function? I'm only using the reference variable format above to try and explain what would be a desirable solution.)

Would this be possible without the submission pre-parser or would one have to create a custom script to be used with the pre-parser?

Has anyone done something similar to this?

Hooks Manager / Submission Pre-Parser

tombr — Thu, 26 Aug 2010 01:24:10 -0700

Hi All,

Hope someone can help with this.

Scenario:
I have a multipage (6 pages) entry form with paypal integration and all of this works perfectly. Page 5 contains the register button and page 6 has the thank you details.

Problem:
Now what I wanted todo is use either the Hooks Manager or the submission parser to hook into the form submission at the point where the user presses the Register button. At this point I need to write a text file onto the server that will update an entries page with registrants and a few other bits of information.

Now the problem is I have not been able to find a hook that contains all of the submission data. The ft_get_form hook as well as the Submission Pre-Parser contain data only from the current page.

Question:
Is there a hook available that contains all of the data from a particular submission.

Thanks in advance

regards,

tombr....

Capturing post data from external page (moneybookers.com)

villjam — Wed, 25 Aug 2010 13:33:18 -0700

Cenario:
Customer goes thru and fills in multiple pages of form data. How do I send this data to an external source (moneybookers) via hidden fields?

When the payment is done all the information will be sent back to my site thru post method. How do I capture this to the db and associate it with the original user?

I guess after that I just redirect them to the Thank you page, to clear everything?

Just point me in the right direction or exampel. I think I can figuer it out by my self with just a little bit of help.

Thanks

Import to excel..

conradcliff — Wed, 25 Aug 2010 08:52:13 -0700

Hey guys, it's been a while but I'm wanting to do some new stuff...

So, I'm betting this is very possible but I'm just not sure what the best way to go about it is...or any way really, I'm very green when it comes to this stuff.

I have an excel database that I update manually when someone sends me the appropriate information. What I would love is to send them to a form that they fill out and then be able to import that data directly into my excel sheet using a macro or the API? if possible. (I have no idea where to start with the API..never messed with one before)

So I'm thinking that once they fill out the form, FormTools can email me a csv or excel file that I can download and then import with my macro. Better yet, I could have an FTP sync set to run with the macro and it could first synchronize the folder that the form data was exported to on the server over to my local machine and then take the newest file in the sync folder on the local machine and import it.
Best would be if I could access Formtool directly from VBA using the API (again I have no idea what that would look like) to download the latest file and import it.

Last thing, sometimes people need to send me image files, I noticed an upload section in the Formtools settings...is there a way to put an upload box in a form so that they could send me a file and with one of the methods above I could DL it automagically?
Edit: After reading through the documentation it looks like you can "upload files through a form"...how it's done I still don't know.

Sorry this was so long, thanks for any help you guys can provide!

what causes this error when trying to edit?

bill.mcbride — Tue, 24 Aug 2010 18:33:34 -0700

when trying to edit a submission on the listings page i get:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 5 bytes) in /var/www/htdocs/formtools/global/code/submissions.php on line 602

thanks

bill

Can't add e-mail field as recipient

mrGarvin — Tue, 24 Aug 2010 00:20:29 -0700

Hi guys!

Struggling with a problem here...
I can't make the e-mail field stick as a recipient when I edit an e-mail template.
I have configured an e-mail field but when I add it as a recipient, it disappears from the recipient list on Save. I can add my self and clients as recipients without any problem. No error messages are displayed. I get an "The email template has been updated."

Further more... I can't get the "reply-to" to stick either. I can select a client, but it isn't saved.

Any ideas on what this might be?

P.s. I tried to replace all the files with fresh ones from FormTools.org, but it didn't solve the problem. d.s.

generate an ID every time a user submits a form

sumanguj — Mon, 23 Aug 2010 13:29:13 -0700

i'm gonna use this script for registration of an event.

the user needs to complete the form and when he/she submits the form, a unique ID has to be generated and shown to him and the same be sent to his/her email provided.

the form needs to be saved to a database for viewing later.

is this possible using this script?

Updating form after response from payment gateway

Aluwe — Mon, 23 Aug 2010 09:28:48 -0700

Hi All,

I need your help in solving this problem.
The scenario:
1. Students fill enrolment form - form 1 (Form)
2. Enrolment data displayed for students with a unique transaction reference number. - Form 2 (Confirm page)
3. This takes the student to payment gateway and form finalised - redirection page and Form 3 (Process page) Form finalised

4. Payment Gateway payment processing

5. After payment, a response is sent to the response page having this code. (response page/thankyou page)

$hostname = "myhost";
$username="my_form_tools_database username";
$password="my_password";
$dbname="my_database;
$usertable="ft_form_99";
mysql_connect($hostname,$username,$password);

mysql_select_db("my_database") or die("Could not select database");

if(isset($_POST['ce_transref'])){
// the following are the parameters returned by $_POST
$ceresponse = strtoupper($_POST['ce_response']);
$cetransref = $_POST['ce_transref'];
$ceamt = $_POST['ce_amount'];
$cedata = $_POST['ce_data'];
$cememo = $_POST['ce_memo'];
if($cedata=='datacode')
{
$query="UPDATE ft_form_99 SET ce_response='$ceresponse', ce_transref='$cetransref', ce_amount='$ceamt', ce_data='$cedata', ce_memo='$cememo',
WHERE cetxref='$cetransref'";

mysql_query($query);
mysql_close();

}

else
{
// terminate because this transaction was not initiated from your store; it's a fake
}
}
?>

5 (a) After payment, a response page is displayed to the students as thank you for your payment. But with the above php on top.

In my database, the following field supposed to be updated by filling data from the response from the payment gateway:
ce_response
ce_transref
ce_amount
ce_data
ce_memo

I have tested the form, all other data are ok, and the forms are finalised. The only snag is that I cannot update the above data in red.

Please advise if there is another way, I can get the response to work and update the submitted finalised data with the response from the payment gateway.

Multiple submit buttons..

villjam — Sun, 22 Aug 2010 15:42:53 -0700

Hi everybody, and thanks for a superb script!

I have done a lot of experimenting and searching the forum but could not come up with an answer so I hope one of you can help me.

How do I set up multiple submit buttons on a page? ..

My front page has 3 different choices and it would be so much easier for the user to just click on the one they choose and then get directed to the next page. Without the need to fill up a checkbox and then click the submit. Is this possible?

Thanks

Submission Account Login SQL Syntax Error

nickanthony — Sat, 21 Aug 2010 15:10:23 -0700

When I try to login as a user to the Submission Account, I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY list_order' at line 4

Does anyone know what this means; and how and where I might address the problem?

I did find the 'ORDER BY list_order' code in /global/code/admin.php; but not sure what to do with it.

function sa_get_form_menu($form_id)
{
global $g_table_prefix;

$menu_query = mysql_query("
SELECT *
FROM {$g_table_prefix}module_submission_accounts_menus
WHERE form_id = $form_id
ORDER BY list_order
");

$menu_items = array();
while ($row = mysql_fetch_assoc($menu_query))
$menu_items[] = $row;

return $menu_items;
}

My server has MySQL version 5.1.47-community-log;
and here is the ORDER BY in the manual -
http://dev.mysql.com/doc/refman/5.1/en/o...ation.html

Thnx for any help, Nick

how to change printable view

sulemanz — Sat, 21 Aug 2010 04:18:53 -0700

i need to change printable view the way my form looks
http://www.youthparliament.org.pk/joinus.html

where to edit?

ill paypal someone $10 today if they can help me fix my issue

sydoc — Fri, 20 Aug 2010 08:47:43 -0700

Cant get my form to go pass prosses.php and it also wount read all fields in my form
I have set it up Both ways now I am having issues both ways.

Direct Method

Once I get through the process of setting everything up. I test the form and not all my Fields show up only a portion. I put it through anyways and when I hit submit on the form It will not take me to the thank you page.

API Method

So I tried to install this method everything seems to work right but on step three I can not get past test submission.

Here are the web files

Direct Method
http://www.lendingpub.com/prequalify.html
http://www.lendingpub.com/thankyou.html
Api Method
http://www.lendingpub.com/prequalify.php
http://www.lendingpub.com/thankyou.php

Please help Im not super familiar with setting things up but I do have a good idea how they work.

Check Init field value on validation

Shylock — Fri, 20 Aug 2010 08:10:31 -0700

Hi Ben/All

I am sure I am missing something really obvious but here is my problem.

I like to have a set of initial values in my form so that people filling in the form can't go wrong. This is especially important on long lists on several columns of the same thing. However the JS validator see the example data as correct data.

E.g.
I have a three column form for prescriptions the headings are:

Item name, Item strength, Item quantity

Only the first row are required fields but there are 11 more rows for large orders.

If I put example data in the first row then the JS validator sees the fields as completed and allows submission. Is there a simple way to check if the field matches the example data and if so throw a validation error.

I could write my own validation script but I'd like to use the bundled JS validator.

Thanks
Tim

Hide "TO" in form e-mails

craven — Fri, 20 Aug 2010 05:46:01 -0700

Hi,

Is there any way to hide the recipients of the e-mail with the swift mailer module ?

Thanks