New Features:

• More Controls: New control types Radio Button and Radio Button SQL have been added to the form editor.
• Parameter based dynamic email notifications.  Great for automatically sending out email notifications based on entered data. 
• New Commands have been added.  These new commands also be executed when the form loads or when the form is saved.
  • Redirect to a specified URL based on the current users Role, Affiliate ID or Region.
  • Grant the user to a new Role
  • Change the displayed name of button controls on H2O forms
• Data Filtering has been improved to allow the use of H2O Tags.  This allows you to automatically filter contents based on the users profile information or portal values.
• New visual options added to hide part or all of the H2O Interface.  By hiding the H2O interface, only your form will be rendered.  This is useful when your form only contains Java scripting or H2O commands.  Such as a form that specifically redirects a user based on their region.
• New Improved Searching
• New Options for Java Script Registration.
• New Step-By-Step User Manual

H2O takes custom forms to the next level by providing...

• File Upload Control:  Provides a file upload control in your forms to have files saved to the server.  Note that this is in addition to the ability to upload multiple files to SQL Server from the forms tab panel.
• Data Grid Control:  Easily add data grids to your form.  Accepts SQL Statements and you can use H2O Script Tags for dynamic SQL Statements to gather data based on the current user and more.
• Script Registrations: You can now register custom Java Script either at the top of the form or at the end of the form.  Download sample H2O forms from the repository on www.OnyakTech.com.  Samples include page load times, visitor details, scrolling text, mouse trails and more.
• New Custom ToolTips: H2O helps you present your forms in a modern professional look by giving you a custom tooltip look.
• More Search Features: Searching on every field in your form is now possible from the master item list.
• Look-Up Tables:  Link to any table to populate a drop-down list using SQL Statements.
• PayPal & DNN User Roles: Add Users to a DNN Role after successful PayPal Payments.
• Hide Form Statistics: You can now hide form statistics from users
• DNN User Registrations Designer:  You can now instruct H2O to treat forms as a DNN User Registration Module.  Use this in conjunction with QuickEntry to create your own custom Registration modules.  Works with both New Users and Existing Users.
• Module Level Filtering and Sorting:  You can now filter and sort data based on specific module instances, allowing you to provide more control over visibility while using the DotNetNuke Security Framework.
• More H2O Scripting Functions Added:
  • Collect Current Date and Time
  • Connect H2O Form Fields to DNN User Registration Profile Fields
   
• Improved H2O Scripting: New scripting options allow you to create forms that collect the following information:
  • Current DotNetNuke User Information: User ID, User Name, First Name, Last Name, Affiliate ID, Full Name, Email Address
  • Portal ID
• Hidden Fields: Perfect for fields you are using the H2O Scripting Engine on or to hide the Primary Key of any forms connecting to existing tables.
• Updated User Manual: Includes tips and connecting to external databases, H2O Scripting details, etc.
• Forms can be saved to files and uploaded to H2O on any site regardless of where they were original created. Visit the repository on www.OnyakTech.com for free H2O forms.
• Stand Alone or External Data? H2O can store it's data in it's own tables and optionally in any Table in your database.
  • Direct data access of existing tables
  • Automatic Data synchronization between H2O and your database Tables
  • Attach and Detach from external database tables at any time without causing any problems
• Choose between displaying...
  • Menu System displaying all form applications in H2O
  • A single form application
  • Single Form and redirect after saving
  • Single Form entry per user
• Ability to limit the user to viewing only entries they have created
• Lock Forms after they have been created to prevent tampering of original data entry
• Role based security of individual fields and forms
• Change your forms at any time without loosing any data or having to go through a complex process
• Customizable result views
• PayPal integration
• Email Notifications to a single user, defined notification list or Teams
• Create Email Templates for an entire module or for a specific project.  Use Tags for dynamic content such as form field values.
• Import/export of data to database tables or excel
• Form entry administration with Team security
• Strong Field Validation using Regular Expressions
• File Attachments, Comments, History Log, Form Relations, Email Notification Lists and more!

KEY FEATURES...

• PayPal Integration:  Accept PayPal payments!
• Direct Table Access: Updates in H2O automatically updates a table directly tied to the form.
• Direct Table Access Extended Fields: Extend a tables fields by using an H2O form while maintaining updates to the connected table.
• Direct Table Access Connectivity and Synchronization:  You can connect and disconnect from Tables at any time.  Allowing you to create snapshots of data.  Upon reconnection, all data in H2O is synchronized.
• H2O Form Files: Create and save your forms to files for use on other servers, as templates or share them. 
• H2O Form Repository: New H2O Forms are being added to the Repository on www.OnyakTech.com all the time. Visit the repository and download H2O Forms for FREE and then upload to H2O for instant forms.   It's easy, just open the form manager in H2O, click browse, select the H2O Form file and click Upload.  H2O reads in the file and re-creates the form on your site.  This is a quick way to get started if your new to H2O. 
• Unlocked Form Editing:  You can change forms at any time, even if they are tied to existing projects/applications. H2O automatically maintains existing records with any changes you make to the form.
• Free-Form Results View:  You've created custom forms, now you can customize how your results are displayed.  You have full unlimited control that's as easy as HTML.
• Role Secured Fields: Secure individual fields to DNN Roles.
• REGEX (Regular Expression) Validation: Obtain every possible validation need by using regular expressions on your forms fields.
• More Control of Form Fields:
  • Required Fields: Easily specify if a field on your form is required input.
  • Easy Form Layout: Easily and quickly alter the layout of your form by use of field sequence numbers and new line markers.
  • Control Properties: Easily create user friendly forms with the use of control attributes.  Tool Tips, CSS Class, Access Key, Height, Width, Color, Attribute Key Value Pairs and Enabled.
•  Form Locking: You can lock forms after they are first created.
• Anonymous users:
  • Only see the data and can not change it
  • Have the option to collaborate on the form by adding files, comments, view history, etc.
• Quick Entry:  Allows you to display a single form to be filled out by all users and then redirects them to the URL you specify in the configuration options.  You can then administer and collaborate on all results through another instance of H2O secured to Team Members or Administrators.
• Form Preview:  See exactly what the form will look like as you build it.
• User Filter:  Displays the user only the forms they have created
• One Form Per User:  Prevents users from creating more then one form while allowing the user to come back at a later date to make changes to that form.  (You can use this feature in conjunction with Form Locking to prevent users from changing the form after they create it.)
• Automatic Form Generation From Existing Tables: Now you can quickly create forms based on existing tables.  Just specify the table name in the Form Name field and click "Generate Form". 
• Import Data From Existing Tables:  Use the Generate Form feature to create a custom form that matches an existing table, then add the new form to a project and click Import Data in the project details to import ALL data from the specified table into your H2O project.
• Export Data to Tables:  Exports all data in the project to a demoralized table.
• Export to CSV: Team Members can quickly export all data in the project to a CSV file.
• Field Types: DNN User List, Calendar, TextBox, Multi-Line Text Box, Password, HTML, Label, Lists, Checkboxes and more.
• Data is stored in Tables, not XML or any other format that's hard to report on with simple SQL statements
• Sub Forms: Custom forms are created at the Portal level and can be assigned to many projects as the...
  • Primary data entry form: This is the form presented when a new item is created
  • Sub-Form of an Item: These are created from the item control panel, you can assign many sub-forms to be used.  Uses may be an incident report, user credentials, meeting minutes, employee reviews, etc.
  • Sub-Form of a Project: These are created from the master item data grid view.  Uses may be project charters,  price list, procedures, etc.
• Team Support: Create teams and assign them to projects.  Teams can be quickly created using DNN Roles or by individual selection.  You also assign team member skills, cost per hour and more.  Teams are used to secure visibility of your data.
• Project Templates:  You can quickly create new projects form existing projects.
• Project Files:  Download your projects as *.H2O files and use them on another site or server.  Or use them as backups for restores.
• Configuration Files:  There are many settings possible in H2O, to make setup easy...you can download H2O configuration files from the Repository on www.OnyakTech.com or save your existing settings for future use.
• Item Control Panel: H2O takes custom forms in DNN to the next level by allowing you to collaborate on entered items by adding comments, uploading files, relating other items and configuring the email notifications of that specific item.
  • Attach Files: Upload as many files as you want to each item
  • Notification List:  Modify who is notified via email when an update occurs
  • Relate to other Items: View and add relations with other items in the current or other projects. Relations can be associated as a Sub Item, Parent Item or Related.
  • Comments: Add comments with an HTML editor
    History: Find out when the item was updated
    Forms: Add/View sub-forms