Page 1 of 1

DBTS Form Processor Extension Version 3.01 Required Features

Posted: Mon Feb 08, 2010 11:18 pm
by Navaldesign
Version 3 of the DBTS Form Processor is on its way.

New features include:

Ban IP addresses

Ban email addresses.

Multiple recipients depending on user selection
PHP validation for fields: Required, Text with URLs, Text without URLs, Equal to, Equal to other field (like password / confirm password), Numer =, Number >=, Number >, Number <=, Number <, Email Address, URL, field length min, Field length max, Credit Card, Password Strength, with user defined error messages.

MySQL Datatype definition for form fields
MySQL Storage: update existing record (so you can update existing records)

Field encryption with md5() or sha1() with or without "salt" (so you can create a WB6 based members system with as many fields as you like.

Custom made template for the emails, so you can create and email your own Order Forms, Invoices, Booking Forms etc.

Please use this thread to suggest additional features. I will take them in consideration for the new release.

Posted: Thu Feb 11, 2010 8:13 pm
by Navaldesign
I suppose that no more features are needed ?? :D

Posted: Thu Feb 11, 2010 8:37 pm
by BaconFries
I just looked into my crystal ball and can see a host of requests being made shortly.....looks like you will need to put the coffee pot on....lol

Posted: Thu Feb 11, 2010 8:46 pm
by Navaldesign
Glad to do so!!!

Posted: Sat Feb 13, 2010 4:03 pm
by Navaldesign
Hi,

This is not form processing, this is relevant to the Login script.

Posted: Sat Feb 13, 2010 8:42 pm
by gp2727
Ok, you asked so here goes....A Paypal Payment Gateway
Forgive me if this request is out of bounds, but that is the only component you don't have that I could think of.

Posted: Sat Feb 13, 2010 9:50 pm
by Navaldesign
gp2727 wrote:Ok, you asked so here goes....A Paypal Payment Gateway
Forgive me if this request is out of bounds, but that is the only component you don't have that I could think of.
Not sure what you mean, can you pls clarify ?

Posted: Sat Feb 13, 2010 11:44 pm
by gp2727
I have seen various forms where customers fill out forms, say for product registration and based on form data, be forwarded to payment gateway. Maybe I'm off the mark here, but that's where I'm heading with this....

Posted: Sat Feb 13, 2010 11:48 pm
by Navaldesign
Ah... I see.

Yes, a "Second Post" routine. Which posts further to another script (PayPal or other).

Although this was already possible with the custom includes, I will enhance it so it can be done directly in WB6.

Thanks for the suggestion.

Posted: Sun Feb 14, 2010 12:23 am
by gp2727
Glad I asked....Thank You Navaldesign !

Posted: Fri Feb 26, 2010 9:45 am
by jerryco
Would it be possible to select whether or not you want to recieve an attachment in the auto-response email?
This looks like a huge bonus to me :D Wonderful extension already, beautifully cared for. Thanks Navaldesign!

Posted: Thu Mar 04, 2010 9:57 pm
by kevinp
A search facility would be handy to retreive and view records stored within the csv or even mysql dbase.

Posted: Fri Mar 05, 2010 6:26 am
by Navaldesign
Hi Kevin,

This is scheduled as a separate extension (Just as the DBTS CSV Manager for retrieving, displaying and editing the contents

Regarding CSV files, There is already DBTS CSV Manager for listing, displaying, editing and deleting the contents. I had scheduled the search object but it is a bit complicated due to the fact that I have to write the entire search engine myself.

As for the database, it is also scheduled as separate extension, with the same tools as the CSV Manager one, that is List, View, Edit, Delete, plus Search.

Posted: Mon Mar 22, 2010 7:48 pm
by DarrenH
Hi George

Not sure if this is possible, but you asked for features in the new form processor.

What I would like is this function.

Imagine you have a long form - and the visitor to the site is filling it in - but he wants to come back later to complete the form prior to submitting. (Eg a day later)

Would it be possible for the form to be pre-completed to the point where the visitor decided to come back later. - ie he retrieves his haldf completed form and continues to fill it in, the submits.

I guess this will use a MySQL database.

Just a thought

Thanks for your brilliant work

Darren

Posted: Mon Mar 22, 2010 8:26 pm
by Navaldesign
Hi Darren.

I have made this many times with my pro shopping carts (where users can place draft orders, that they can then come back and transform to real orders any time later) or with multi (10 + ) page forms for l o an applications where users probably miss some details and, in order NOT to lose what they have already typed, they are given the ability to "Save" their already filled in forms and come bacl later to complete.

However implementing this in a generic way, requires an auxiliary table, a "cookie" (so the script will recognize the user when he comes back) and more (deleting temporary data in the DB when final submission takes place as well as disabling the cookie). In other words a rather complicated task for a generic purpose script.

I will consider this for the next update (v. 3.02 ) as I'm now in advanced testing stage for version 3.01 and I wouldn't like to delay it further.

Posted: Sat Jul 10, 2010 8:25 am
by jerryco
Ahoy Navaldesign :)

May I please request a few additional 'features' (if they're not in yet?):
When using default values:
*Click field to empty it,
*Click next to empty field to make the value reappear

Thanks for your consideration.

Posted: Sat Jul 10, 2010 10:52 am
by Navaldesign
?m afraid this is not possible as the user interface is the one provided by Extension Builder (so it should be Pablo to add these features to the Extension Builder).

Unless I have misread your post....

Posted: Sat Jul 10, 2010 2:01 pm
by jerryco
I'm not sure if I specified enough. I meant when a form editbox is drawn inside Webbuilder, and a Default Value is specified for it, then that value keeps in the box when it gets clicked in the browser. I would like the Default value to disappear when a visitor clicks the field.

Is this what you replied to?

Posted: Sat Jul 10, 2010 2:09 pm
by kevinp
You can do this by adding an onfocus event to the edit box as below:

Editbox > Events > OnFocus > Javascript Function > then type in the javascript box

Code: Select all

 this.value='';return false;"
When you click the box the initial value will disapear.

Posted: Sat Jul 10, 2010 2:23 pm
by Navaldesign
Sorry. I though it was regarding the default values in the extension properties, within WB......

For the form fields I use instead to add this code in the field HTML, Inside Tag:

onFocus="if(this.value=='Please type your Name')this.value='';"
onBlur="if(this.value=='')this.value='Please type your Name';"

where "Please type your Name" is the initial value of the specific field

This code helps NOT deleting a value that has already been typed in, if different from the initial one, and to restore the initial value if the field is empty after the user moves to the next field.

I misread your post because the processor has no control over the form fields behavior, so I thought you were talking about the fields in the processor properties.

Posted: Sat Jul 10, 2010 5:02 pm
by jerryco
Thanks George. I think this should be default for WB.

Perhaps Pablo is reading along?

Posted: Fri Aug 06, 2010 11:34 am
by Navaldesign
Not sure what you mean. Can you take a screenshot pls ?

Posted: Fri Aug 06, 2010 12:18 pm
by Navaldesign
I see what you mean.

This is due to the fact that you have set the border width different than 0.

HTML tables, when you set a border width, will assume that for all cells. And since you have also set cellspacing different than 0 it sets two borders.

Solution:

Set the Table background to black
Set cellspacing to 1
Set the Cells background color to white

Publish and test.

Posted: Fri Aug 06, 2010 12:27 pm
by Navaldesign
Is is obvious that you have set one of the Alternate Rows color to be black!

Posted: Fri Aug 06, 2010 1:42 pm
by Navaldesign
No, the extension uses its own properties for defining the hyperlink style. But, from what I see in your code, you have not set it.

Posted: Sun Aug 15, 2010 10:38 pm
by Navaldesign
Hi Jeff,

Thank you for your donation.

The details of new features are those found in the very first posts of this thread.

Your proposal is interesting, I will try to add it in the new version.

Thanks again.

Re: DBTS Form Processor Extension Version 3.01 Required Feat

Posted: Wed Nov 03, 2010 4:10 pm
by neo_webbuilder
Great work Naval.....

Just asking....the new formprocessor has resizable columnwidth ?
and the recaptcha supports, language, tabindex, and themes ?
or is the recaptcha from pablo now included?

Looking forward to your reply,

neo

Re: DBTS Form Processor Extension Version 3.01 Required Feat

Posted: Wed Nov 03, 2010 8:31 pm
by Navaldesign
neo_webbuilder wrote:Great work Naval.....

Just asking....the new formprocessor has resizable columnwidth ?
and the recaptcha supports, language, tabindex, and themes ?
or is the recaptcha from pablo now included?

Looking forward to your reply,

neo
It will support pixel number definition of the first column, the second is automatically the difference between the entire width and the first column width.

DBTS Recaptcha already supports themes as well as customization of the "clean" theme.

Languages will be supported.

Tabindex ? What do you mean ?

Re: DBTS Form Processor Extension Version 3.01 Required Feat

Posted: Thu Nov 04, 2010 6:16 am
by Navaldesign
Its not added yet, but I believe it will be there in the final version.

Re: DBTS Form Processor Extension Version 3.01 Required Feat

Posted: Fri Nov 05, 2010 10:26 am
by neo_webbuilder
Navaldesign wrote:
neo_webbuilder wrote:Great work Naval.....

Just asking....the new formprocessor has resizable columnwidth ?
and the recaptcha supports, language, tabindex, and themes ?
or is the recaptcha from pablo now included?

Looking forward to your reply,

neo
It will support pixel number definition of the first column, the second is automatically the difference between the entire width and the first column width.

DBTS Recaptcha already supports themes as well as customization of the "clean" theme.

Languages will be supported.

Tabindex ? What do you mean ?
Well in you previous formprocessor you had to use your own DTBS recaptcha. This did not support tabindex. So that's why i asked. Recaptcha has 5 variables which can be set. One of them is tab index.

The following fields can be set in the RecaptchaOptions dictionary:

theme
lang
custom_translations
custom_theme_widget
tabindex any integer 0 Sets a tabindex for the reCAPTCHA text box. If other elements in the form use a tabindex, this should be set so that navigation is easier for the user