Form Tools - Modules

Hooks manager for sending info to another database

Thu, 18 Jan 2018 12:05:18 -0800

I'm trying to setup hooks manager to send the data submitted to another database. I want this to grab the values entered and send them all to another database when the form is submitted. Below is the code and I have it set for the

Code:
ft_finalize_form, end

hook with a rule priority at 1:

if ($_POST["timer_container"] > 0)
{
  // Server Vars
  $servername = "***.***.***";
  $username = "********";
  $password = "********";
  $dbname = "********";

  // Form Variables
  $TypeVal = $_POST["TypeVal"];
  $moldID = $_POST["moldID"];
  $last_modified_date = $time_stamp;
  $timer_container = $_POST["timer_container"];
  $q1 = $_POST["q1"];
  $q2 = $_POST["q2"];
  $q3 = $_POST["q3"];
  $q4 = $_POST["q4"];
  $q5 = $_POST["q5"];
  $q6 = $_POST["q6"];
  $q7 = $_POST["q7"];
  $q8 = $_POST["q8"];
  $q9 = $_POST["q9"];
  $q10 = $_POST["q10"];
  $q11 = $_POST["q11"];
  $q12 = $_POST["q12"];
  $q13 = $_POST["q13"];
  $notes = $_POST["notes"];
  $employeeID = $_POST["employeeID"];
  $machine = $_POST["machine"];

  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
  }

  $sql = "INSERT INTO moldpm (TypeVal, Machine, Time_Stamp, Elapsed,
  Q01, Q02, Q03, Q04, Q05, Q06, Q07, Q08, Q09, Q10, Q11, Q12, Q13, Q14, Q15,
  Notes, Employee, Press)
  VALUES($scada_pdo, $scada_sql, $TypeVal, $moldID, $last_modified_date, $timer_container, $q1, $q2, $q3, $q4, $q5, $q6, $q7, $q8, $q9, $q10, $q11, $q12, $q13, 5, 5, $notes, $employeeID, $machine)";

  if ($conn->query($sql) === TRUE) {
  echo "New record created successfully";
  } else {
  echo "Error: " . $sql . "
" . $conn->error;
  }

  $conn->close();
}

Can anyone help me out? Not sure if I'm fully understanding the hooks manager.

Undefined function when using pre-parser module

Mon, 15 Jan 2018 11:38:46 -0800

I receive the following error when trying to use the pre-processor. I am using version 1.1.4 of the module and 2.2.5 of formtools.

pre.JPG (Size: 43.99 KB / Downloads: 1)

SystemCheck: Orphan Clean-Up delivers orphans

Fri, 29 Dec 2017 12:46:45 -0800

As appreciated in the Orphan Clean-Up UI, here a screenshot of the test result.
12 orphans have been detected in TABLE field_settings.

06_OrphanCleanUp_Detail.JPG (Size: 96.11 KB / Downloads: 1)

I'm using FormTools 2.2.6 with SystemCheck 1.0.3.
Let me know, if you need further information.

Greetz, thosau

ExportManager - realizing secure details page

Sun, 17 Dec 2017 06:31:49 -0800

Hi @all,

I'm looking for a solution to realize showing a table (let's call it 'result-table') on a website (outside the FormTools ControlPanel; I get the data with FormTools API). After clicking a field in the result-table, a details page should be shown.
In the FormTools documentation, there is the way shown to realize the details page via ft_api_show_submission() and passing the ID of the data which has to be shown via $_GET.

I don't want to go this way because I want to prevent a user walking through the whole database by manually typing the URL of the details page in his browser and manually changing the ID which has to be shown.

Screenshot_ExportManager_SmartyTable.jpg (Size: 132.71 KB / Downloads: 0)

The above screenshot shows the generated result-table, which guides to the details page by clicking any cell in the table. In a first solution, I added the field 'Crypt_ID' to the database. I used 'Crypt_ID' to link to the details page instead of the numeric ID.
As the access to the database should show a multi-user-ability and for cosmetic reasons I don't want to show the 'Crypt_ID' in the result-table. Thus, here my question: is there any possibility to use 'Crypt_ID' for linking to the details page, but NOT to show it in result-table???

I would appreciate to get a little hint, because I spent hours and hours and couldn't a solution :d
Greetz, thosau

Error when I enable the Swift Mailer Module

Wed, 20 Sep 2017 13:22:19 -0700

Hello,
I am new to this and I am hoping to get some help on solving this. I created a form using Form Builder.
I process the form get to tha thank you page but i never receive hte email so then i enable Swift Mailer. I test it with gmail smtp and i receive the test messages. Back to the form when i click continue (submit) the form goes to a server 500 error page.
Any ideas why? Do i have to make a change some place in Form Builder to indicate that i am now using SMTP?

My PHP version is 5.5.38.
Swift Module v1.1.2
Thanks in advance.

Calculating time Difference with Submission Pre-Parser

Fri, 25 Aug 2017 12:10:28 -0700

So i been trying to get this going calculating time difference of my for form.

Below is my code.

if (isset($_POST["checkin"]) && $_POST["checkout"]) {
$tcheckin = $_post['checkin']; $tcheckout = $_post['checkout'];
$tdiff = date_diff("$tcheckin","$tcheckout")->format("%H:%I:%S");
$_POST["inandout"]=["$tdiff"];
exit;

I am not sure what i am doing wrong.

Data Visualization change % to total nº

Wed, 23 Aug 2017 08:14:36 -0700

Hi,

Well I have a problem, on my graphics the display info it all with % (examples 25% and 75%), how can I change to the default display be like 100 and 300, display with the total?

Thanks in advance

Extensions Translation german

Mon, 21 Aug 2017 04:05:31 -0700

Hi
the file is wrong. Contain only a folder.
Can every one give me the correct file?
thanks
Thomas

File submission module comment field not showing

Wed, 05 Jul 2017 20:27:25 -0700

I am using the file submission module and I typed some instructions in the comment field, but this comment field does not show up in the form below the file upload field

I un-ticked the box to enable the comment field in the settings (i.e. not using the default empty comment).

How can I fix this?

How do I setup "submission account" for new Form?

Tue, 06 Jun 2017 07:16:09 -0700

The probelm is in
Modules » Submission Accounts » Configure New Form

When I choose Form value I get the message:
"Error: Not Found".

Then I can select Form, View and Theme. After the "Add" action I got:

"• Please select the field which will act as the username.

• Please select the field which will act as the password."

But I can not select them. They are always disabled.
Where could be the problem?

Newbie here, bit confuse regarding emails and forms

Tue, 06 Jun 2017 00:55:20 -0700

Hi,

I am new to the php stuff. I have a website that has three different forms as part of the website. ContactUs, Orders and Feedback. They are all essentially the same type of form except that they are all going to email addresses that are redirected to a hotmail address from GoDaddy, it is set up this way so that the person who runs the business gets the emails and I get a copy of the same emails, especially the feedback one so I can put these into the website as testimonials and it cuts the need to have the business owner forwarding especially if she is away.

I also have on the Feedback form the ability to upload a photo. I had it set up before getting a hold of Form Tools, which I may say I'm impressed with the ease of using my forms that are already made and putting the necessary script into them.

Here is my problem. I have done so much reading, that my head is swimming. I know what I want to do, just need the program to help me do it. The bottom line is why isn't the emails going where they are supposed to, they are being stored on a database and not forwarding. I think the database is great for the recording of what people have written, but my friend has no idea about that side of the workings, she is happy to get the emails and read, whereas I can use the database to process the testimonial page.

Do I need to put some script into the page which directs the information to be emailed and if so, how do I put the email address into the code. I have previously used 'mailto:' which I am itching to get rid of as it is.

Yes I have read through the tutorials, but I am the type of person who learns best from an example which can be altered easily to achieve the desired result.

Any assistance in this regard will make this 'reading weary' person very happy.

Kind regards,

pixie1964

System Check Module 1.1.0

Mon, 05 Jun 2017 14:13:44 -0700

I just ran the system check on one of my installations. I got errors in two sections:

1) Hook Verification: "Extended Client Fields: ERROR, too many hooks". I clicked repair... not sure what it did, but it runs as "pass" now.

2) Orphan Clean-up: Getting a few errors.. haven't run the repair on it yet, want to double check I'm not deleting

TABLE: ft_email_template_recipients
- num orphans: 3
- error description:
1. invalid template ID 2 being referenced by the table's Primary Key ID 3
2. invalid template ID 1 being referenced by the table's Primary Key ID 8
3. invalid template ID 3 being referenced by the table's Primary Key ID 9
_______________________

TABLE: ft_email_templates
- num orphans: 8
- error description:
1. Invalid email_from_account_id: 0 for email_id = 5
2. Invalid email_from_form_email_id: 0 for email_id = 5
3. Invalid email_reply_to_account_id: 0 for email_id = 5
4. Invalid email_reply_to_form_email_id: 0 for email_id = 5
5. Invalid email_from_account_id: 0 for email_id = 7
6. Invalid email_from_form_email_id: 0 for email_id = 7
7. Invalid email_reply_to_account_id: 0 for email_id = 7
8. Invalid email_reply_to_form_email_id: 0 for email_id = 7
_______________________

TABLE: ft_field_settings
- num orphans: 28
- error description:
1. invalid field_id: 396
2. invalid field_id: 396
3. invalid field_id: 397
4. invalid field_id: 397
5. invalid field_id: 427
6. invalid field_id: 427
7. invalid field_id: 428
8. invalid field_id: 428
9. invalid field_id: 458
10. invalid field_id: 458
11. invalid field_id: 459
12. invalid field_id: 459
13. invalid field_id: 537
14. invalid field_id: 537
15. invalid field_id: 538
16. invalid field_id: 538
17. invalid field_id: 551
18. invalid field_id: 551
19. invalid field_id: 552
20. invalid field_id: 552
21. invalid field_id: 565
22. invalid field_id: 565
23. invalid field_id: 566
24. invalid field_id: 566
25. invalid field_id: 580
26. invalid field_id: 580
27. invalid field_id: 581
28. invalid field_id: 581
_______________________

Submission Pre-Parser error when selecting

Tue, 30 May 2017 09:26:13 -0700

I installed lthe Submission Pre-parser module downloaded from here. Install went fine, but when I attempted to select the module, I got the error below. I'm using FT 2.2.6.

Fatal error: Call to undefined function handle_error() in /home/points/public_html/formtools/modules/module-submission_pre_parser-1.1.4/library.php on line 44

Can't load Hooks Manager module

Thu, 20 Apr 2017 14:58:23 -0700

Long time user of Form tools here.
Been using it for several small web sites and the forum has been a great help whenever I ran into different issues. Finally need some specific help now.

I installed the Hooks Manager module (v1.1.3) and whenever I try to select and load it, I get the following error message:

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 '' at line 5

Screen shot 2017-04-20 at 5.54.07 PM.png (Size: 40.89 KB / Downloads: 5)

Can someone pinpoint where I'd correct this issue? I'm not all too familiar with PHP so I'm lost on where to begin looking!

Thank you so much!

FILE DELETE BUTTON still doesn't work

Fri, 14 Apr 2017 13:06:30 -0700

uploading files to my server is fine but if I want to delete that file it doesn't work contrary to the report that it does and that it was fixed. I must go in and manually delete the file from the folder and then manually delete the file reference from the mysql data base.

Screenshot at 2017-04-14 16:05:05.png (Size: 125.14 KB / Downloads: 1)

Report builder install

Tue, 07 Mar 2017 02:11:04 -0800

I'm having an issue with the Report Builder module. I'm following the instructions to install, and the report builder appears in the menu, but only the configuration link is shown. No link to reports or any way to create them. I've used System Check to see if I can id the problem and hook verification fails on report builder. Table verification shows no report builder tables (I'm guessing it should). I'm using v2.2.6 of Form Tools and Report Builder 1.0.3 on a hosted server. Everything else works fine. Any pointers gratefully received.

export manager problem (solved)

Sun, 05 Mar 2017 11:40:00 -0800

Formtools 2.2.6
Hi,
I'm having an annoying problem, need to create an csv file to migrate data to a word press installation but:

Can't access export manager, can't uninstall it either. for both options I'm getting a 500 error page. so uninstall/reinstall is not an option..
Other modules work fine, did the system check, all fine....
Moved the module temporarily to another directory . on the module page export manager changed form "select" to "upgrade" but nothing happens when clicking upgrade...

Hope someone has a solution for this issue!
Thanks in advance...

Solution: moved the faulty export manager to backup directory and then copied the export manager from another site into the module directory on the server

Excel Export Manager

Mon, 06 Feb 2017 04:49:23 -0800

Hey I'm new here
I'm from Germany sorry for my bad englich.
Ok now my question.
It's possible to use a
in the {foreach} Loop
to create more lines in the Excel sheet ?

{foreach from=$display_fields item=column}

{/foreach}

{foreach from=$submissions item=submission}
{assign var=submission_id value=$submission.submission_id}

{foreach from=$display_fields item=field_info}
{assign var=col_name value=$field_info.col_name}
{assign var=value value=$submission.$col_name}

{/foreach}

{/foreach}

{$column.field_title}
{smart_display_field form_id=$form_id view_id=$view_id submission_id=$submission_id field_info=$field_info field_types=$field_types settings=$settings value=$value escape="excel"}

Make Export form look like submission Form

Tue, 10 Jan 2017 10:04:09 -0800

Is there a way to make my export form look like my submission form. The submission form looks very nice and professional, but the html export form not so much. Any help I can receive with this would be greatly appreciated, thanks.

Hooks Manager and Extend Client Field

Mon, 26 Dec 2016 20:51:19 -0800

Hi guys, I'm new to PHP coding and Form Tools and I'm having a hard time getting the three data from the Extend Client Fields to the form. My reference was:

http://forums.formtools.org/showthread.php?tid=1902

I have three extend client fields namely:

Area
Department
Section

I want these three to automatically go into the form upon creation.

Thanks!