DBTS Form Processor Extension Version 3.01 Required Features

[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.

[Navaldesign]

I suppose that no more features are needed ??

[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

[Navaldesign]

Glad to do so!!!

[Navaldesign]

Hi,

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

[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.

[Navaldesign]

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 ?

[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....

[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.

[gp2727]

Glad I asked....Thank You Navaldesign !

[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 Wonderful extension already, beautifully cared for. Thanks Navaldesign!

[kevinp]

A search facility would be handy to retreive and view records stored within the csv or even mysql dbase.

[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.

[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

[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.

[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.

[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....

[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?

[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.

[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.

[jerryco]

Thanks George. I think this should be default for WB.

Perhaps Pablo is reading along?

[Navaldesign]

Not sure what you mean. Can you take a screenshot pls ?

[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.

[Navaldesign]

Is is obvious that you have set one of the Alternate Rows color to be black!

[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.

[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.

[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

[Navaldesign]

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 ?

[Navaldesign]

Its not added yet, but I believe it will be there in the final version.

[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

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