Loading

Категории

Новости

Записи

HowTo's

Все посты

• 125 posts

  • 2010 (84)

  • July (1)
  • June (2)
  • May (1)
  • April (5)
  • March (44)
  • February (23)
  • January (8)

  • 2009 (16)

  • December (5)
  • November (4)
  • October (3)
  • September (1)
  • June (1)
  • January (2)

  • 2008 (9)

  • December (3)
  • November (2)
  • October (1)
  • August (1)
  • May (1)
  • January (1)

  • 2007 (8)

  • October (1)
  • September (1)
  • July (1)
  • June (1)
  • April (1)
  • March (1)
  • February (1)
  • January (1)

  • 2006 (3)

  • December (1)
  • June (1)
  • February (1)

  • 2005 (5)

  • August (1)
  • July (1)
  • May (1)
  • March (1)
  • January (1)

We've implemented one more user request called Database Filtering.

Filtering database by column and word

Database filtering is another great addition to Search functionality to improve the way you searching your data. It searches the entries which 'filter by' column value starts with filter character or word.

Please, go to Records menu and find new Filtering link.

Click it and you will see database filters expanded.



You can filter your data by digits 0 - 9, small letters a - z and big letters A - Z. Or you can just type your filter character or word as shown on the screenshot below.



Of course you will be able to select any of your table columns or form fields, call it as you wish.



Once you stop entering your filter word filter triggers, you will see spinner animation at the center of the screen.
Please, make sure to wait while database filtering finished.
Then you will see the result for your combination of table column and filter word.



Same can be done for any other column. Play with it few minutes to understand how beautifull filters are.

Filtering by column and character

For better usability there is a links
0 1 2 3 4 5 6 7 8 9 ~ a b c d e f g h i j k l m n o p q r s t u v w x y z ~ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z.
So you will not need to type anything. Just select column you wish to filter and click on any character or digit. Soon you will find Filtering as a good and quick way to find the data in your table. Point-and-click filtering much easier then Search. However using Search you will be able to combine search criteria, you will have more conditions to find any value in your database.

And you will see all entries, which column starts with a character you just clicked.

Database Widget filtering

DB filtering in database widgets are just the same. Only one difference is that you will be able to select only visible columns.

We need to admit that filtering is our step to implement Views functionality. We will need to add grouping first. And after that you will see how MTH handles Views ;)

We are excited to introduce several new features. They were mostly implemented as per user requests.

• Database Widget Export to Excel
• Database Widget Editing
• Allow End User Edits
• Updated records email notifications
• Sum and Average

Export to Excel in Database Widget

In Database Widget you can enable Excel Export for all web users. Can be very useful if you want to share all database or need to make daily backups without entering MTH site.

Clicking on Export to Excel will send you xls file with your database.

Also, as you remember you can also enable records deletion from database widget.

And here is how your database looks like in Excel.

Database Widget Editing

Sometimes you may need to allow web users to edit your database from database widget. Enable it in database widget setting and you will be able to edit entries like this:

Notice, how your db widget can looks like when you enable export to excel, delete and edit options. Also, please, check out new Sum and Average icons near each column with type Number.

Allow End User Edits

Very often you may allow your users to come back and update their submitted records. For example, when your user submitted CV, but his address were updated. He need some way to come back and update submission. This is when Allow End User Edits will be handy.

Remember, that your form should ask users email. Only if this is true you can get all benefits from this feature. As you most probably understood this is for emailing the link to user's submission. User will receive email and need to save it for future use.

And finally user will be able to update his details.

Updated records email notifications

If you working on your project with a team you will be very interested in the next feature. This is the way to be informed about changes in your database. Once user updates any entry you will get email with the previous and current value of the fields.

Here is how you can enable it in form widget. Make sure to update email recepients list. You can enter as much emails as you need, separated by comma.

And here is how updated records email notifications looks like in action:

Sum and Average

As you may already noticed there is few new methods implemented. Sum (or Total) and Average. This is the way for you to get Total of all column values, or average value for it.

Thank you for all your great feature requests. And we look forward to keep improving MTH for you!

Conditional logic or Field rules allows you to show or hide a field based on what users select for another field on a form.

For example, you might have a field asking users "Are you married?" And if a user selects "yes", you might want to ask user's wife name.

Conditional logic is great for surveys or feedback forms. For example, you can ask a customer how satisfied they are about your service, and you can follow-up with questions relevant to their selection.

Using Conditional logic on order forms is perfect for displaying additional questions based on what a user has selected to purchase. For example, if a user chooses to purchase a computer then you can ask what CPU and Memory they would like to order. Similarly, if a user is choosing between different TV'c, you may want your dynamic web form to prompt the user to purchase stereo systems also.

Complex web form always looks big and difficult for user to fil in. With long forms you can hide form sections until the user has completed other sections, preventing a scrolling on a form.

You can use conditional logic on registrations forms in many ways. For example, you can create a form with contact information, you can then have a "More details" section. Which can be activated using Drop Down 'Add more details' value 'Yes'. If the user chooses 'Yes' you can show more details (post address etc.).

How to create dynamic web form online

Here is what we are going to talk about. and here is how it looks on screenshot.

To create your first dynamic web form, please, go to Form Builder and create form like this:

Then click on 'Field Rules' link and go to Rules Builder to create your form field rules:

When you are done you should see something like this:

And here is what happens when you will activate all field rules.

Field Rules

Field Rules let you perform two actions if a condition is true. You can show a field on a form or hide a field from the user. You can also show/hide section headings and file upload fields, which is useful for showing detailed instructions for how to fill out your form or selectively asking for files from your users.

What you need to start using Rules

To start using Field Rules, you will need to have at least two fields. You need JavaScript enabled in your browser.

Field rules like contains two parts: a condition and an action.

The show action lets you display fields on a form. The field will be hidden when you open form and will stay hidden as long as the Show rule condition. Once the rule become true the field will dynamically display on the form. This way you have real dynamic web form built online!

The hide action lets you selectively hide fields on a form. When the form displays the field will be shown. As your user fills out your form and the Hide rule condition is met the field will be dynamically hidden. When a field is hidden any rules that use that field will be reevaluated. Any conditions tied to the newly hidden field will always evaluate to false. If a required field is hidden users will no longer be required to fill out that field to submit your form. Hide actions work across pages so they can hide a field on the next or next pages of a form.

The Rule Builder allows you to create dynamic forms that will follow logic that you’ve specified to perform certain actions like showing and hiding fields, skipping certain pages or emailing specific individuals based on the selections the user makes while filling out your MyTaskHelper forms.

Field Rules are very easy to understand in MyTaskHelper. Our Rule Builder was designed to make adding and understanding the logic you want to apply to your forms as easy as creating sentences. Click on 'Field Rules' link in Form builder to see Rules Builder.

Every rule in MyTaskHelper is composed of two components: condition and action. The Condition allows you to specify the field you need to base the your rule off and how you want us to evaluate that field. The Action tells us what you want MyTaskHelper to do if the Condition is true.

Conditions in MyTaskHelper are made up of three parts: the Subject, the Value and the Comparison

• Subject is the field you want the rule to be based off of. It cannot be a File Field, Section heading or Description.
• Value is the choice the user must select or enter to make the Condition true.
• Comparison tells how you want to use the Subject’s value to make the condition true.

Here is a list of the different comparisons available for each field type:

• Numbers: is equal to, is greater than, is less than
• Date and Date & time: is on or is at, is before than, is after than
• Other controls like single text line: is, is not, contains, does not contain, begins with, ends with, is empty, not empty, like

New feature for MyTaskHelper users called Duplicate web form introduced this week-end.

Clone web form

Every user can clone their forms with all fields using Duplicate link in Form Builder. When you click on 'duplicate' it will copy all form settings, both form and database widget settings. Also all fields with their validation options, default values.

You can use form duplication for saving your form before trying something new. If you have many similar forms. For example if you have form with 20 fields for every year in the school - creating new form for each year will be big pain for you. This is why Duplicate Form feature can be very useful for you.

Another way is to reuse year from year your copied forms with saved format, maybe with small changes.

Duplicate your online form and save your time on creating similar forms now!

Ajax bulk import files can be done in MTH in a few clicks. All you need is to have file field in your form and upload multiple files in one go.

Import several files

When you are on the Records page you can see 'Import' link. Previously it only included two options: Create New Records and Update existing records when key data matches. And now you should also see ' Upload multiple files in a time'. However you will see it only if you have at least one file or image field in your form. Select radio button with label 'Upload multiple files at once'

Then select several files from your PC to upload

You will see how this files uploading using Ajax, one by one. Please, wait whiel uploading finished and press 'Import'

You will see that all your files uploaded using bulk files import.

We hope you will find it useful, because this is one more cool feature which you will not find in any other database or form builders in the web.

We've added few very important validation options to all File or Image form fields. You can set file types you wish your users will upload. You can limit the uploaded file size too.

File type validation

You should be able to edit the list of file extensions you would like to allow for upload. Format like '*.ext1;*.ext2;*.ext3' are very important. So, please, try to follow it.

This amazing feature can be useful for you if you need your users only upload files you need, for example - only word documents or only images.

Here is how file type validation looks like in action:

Limit uploaded file size

In simple HTML forms impossible to limit uploaded file size. But in MTH you can have many things which other users will not ever have. So no wonder that you can limit uploaded file size now. Just enter the number representing the limit in megabytes for each upload and you are on the go. Limit it to 100Mb and no one will be able to upload 1Gb files. Remember, that by default our limit is 10Mb

Under Browse file button you will always see file size maximum allowed size:

In case your users will try to upload file with size bigger then you allowed he will see next image:

If you have email form field in your form, you can send email confirmation to user who filled your form.

Confirmation email settings

Please, see how confirmation email settings looks like in Form Widget settings. Trigger Send confirmaion email to form submitter? for being able to see all options below.

As you may see from the screenshot above you can setup everything you may need to send automated emails to your users. The most obvious use of this feature is to send email confirmation that you've been notified about their input.

• First and most important option here is email form field. This is from where we will take user's email and to whom we will actually send confirmation.
• Next one is email Subject option - where you can set your confirmation email subject. Good practice to do not leave it blank, please.
• And of course Body of your automated email must be filled in. Because, otherwise, user may think that this is just a spam.
• Another sweet option is From header option. Using which you can set your companies email. So user will see Your Company Name your@company.email sender instead of MyTaskHelper.com.
• Also Reply to option should be widely used. Because it allows your users to respond to your directly. This way you can stay connected with your users.

Say 'Thank you' to Mikie, who requested this feature first.

In our online database builder you can use new feature: Redirect to record widget page. User will see what he just submitted.

You can find new feature on Widget Builder page Please see screenshot After data submission you will be redirected to the page with your record.   If you want get the link to just submitted file please use this feature.

You can block spammers using Ban IP feature as well as require records approve before your users input will be shown on database widget.

Database moderation

We are happy to tell you that your database application can be more secure now. Because in addition to Captcha you can add database moderation or even block spammers IP's forever.

You should use this feature if you using both Form and Database widgets on your site. Because users can submit just anything to your web form. And you should be aware of it.

For enabling database moderation, please, go to Widget Builder and find new Database moderation option.

Enable it and all users input will be moderated then.

When next time you login to see your new records they will be highlighted. And on the right side of each record you should see Approve link. So you can allow or delete this record permanently.

Ban spammers IP to protect your database application

Even if you have enabled both database moderation and Captcha on your form you can't be sure that your data will always be valid. Because spammers always can add bad entries to it. So you may need another way to block them. This is why we added IP ban feature.

Please, notice that at the right side of each record you have More link. Click on it and you can see IP of every user who entered data to your data base. Also below this IP you have Ban this IP link. Click on it and this user will not be able to fill your form any more.

Of course you may want to unban some users. Because some of them can be banned by mistake or maybe they changed their behaviour to better :) In the same More section you should see All banned IP's link. Click on it and you will see the list of all IP's blocked in your application. Near each of IP you can see Unban IP link. Use it if you want to unblock this user again.

Find this feature in widget builder module.
In widget builder module you can find the option Banned Ip's. Click to this link to ban (unban) IP's and see all ban list.

To ban needed Ip enter it into this field.



All banned Ip's list.

Protecting web forms using Captcha is another great way to validate users input. Make sure you choose right security options for your database application!

Now you can add Table to your Form. We added this new field type, which we hope will be useful for you. It can help you to build amazing surveys as well.

Premier League Table widget

We will show you how to add Table field to your form using Premier League Table example. Embedding premier league table to your web page can't be done easier. First of all create form and select Table field type from field types drop down.

Then click on Default link to set your table rows and columns

Enter your rows and columns, one per line.

Updated date and date time pickers

As you may noticed we have updated our Calendar control. See how it was before: and how new date time pickers looks like now.

Okey, you are ready to go. Click on Add Record link and fill your first Premier League Table widget We will add Chelsea, Arsenal, Man Utd, Man City and Tottenham. This is how this table looks like today.

Now you can see populated table on records page

Also you can view it when will click on View link.

You can see database widget with table control in action here

Other exampels of using Table on the Form

There are many other cases which you need to add Table to you web-form. For example you may want to add scores to your gamer personal information form. So you can add Standardised scores Table control to your form. And add Scores column with Reading, Spelling, Comprehension, Math Computation rows.

Table on Students forms

In the same way you can add National Curriculum (NC) Levels table with Most recent NC levels column and English, Maths, Science rows.

You can put Risk Assessment table to your Behaviour web form with Target, Probability, Seriousness, Influencing factors columns and Verbal aggression (incl. threats,swearing) , Physical aggression (incl.kicking, punching, biting, scratching,spitting, hair pulling), Intimidation communicated by physical action, Property destruction, Defiance or non-compliance, Disruption, Self-injury, Sexual behaviour, Stealing, Running away from immediate environment, Running off site, Refusal to move, Use of weapon, Use of illegal substance / alcohol columns.

Improve your survey with Table control

And it is obvious that you can build much more powerful surveys now. You can ask users to provide information in more advanced way now.

Premier League Table Widget it is just one example how you can use table field web form. So, go ahead and improve your forms with Table right now. And let us now your feedback.

Import excel to web database

We are very happy to introduce Import from Excel functionality in My Task Helper. Previously you were only able to create your database from scratch. But now you can move from your Excel databases to online database in a few clicks.

Please, follow few simple steps:

Signup

Create database

Create form

Copy Excel data

Assuming you have Excel file. Copy it's content and paste to MTH.

IMPORTENT NOTE: if you have any carriage returns in your data cells it will break all import. Please, make sure to do not enter any tabulations or carriage returns in your Excel file. You will be able to do it in MTH then.

Import Excel

Press Import and you are on the go!

Records imported

Please, notice that your columns now represents form fields. All your data located on Records page.

Database widget

And you can easily integrate your data table to your own page with a few clicks.

Add more data to existent database

It is obvious that you should be able to update your data using Import at any time. You may want to add new records or update entries.

Add new records using Import

On Records page you should see Import link, using which you can add or update your data using Excel Import. Procedure is the same as when you migrating from scratch. Just copy your excel file content and paste to import text area. Remember that you should include also first row with column names. The order of fields doesn't matter, but presense of this fields on your form is important. Because if you don't have such fields they will be created. And if you renamed fields in Form Builder but not in Excel you will have twice more fields. Which is not what you want. But using this trick you can update your database structure along with adding or updating records.

Update records using Import

Also you can update existing records when key data matches. Choose column name (Unique field) to use as a key for comparing data. If your new record contains the same value in this column as one of your existing records, the existing record will be updated with the new data. If no match is found, a new record will be created.

Remember that you always can export your updated data back to Excel :)

Database search

Read how database search works in My Task Helper. Remember that the same will affect your integrated database widget. Enjoy searchable databases for Free!

Shortly - you can add more and more parameters, further narrowing your search down. This is useful if you have hundreds, even thousands of records.

Searchable students database

We will show how search works using students database. Here is how student form looks like.

After filling it with a few students we are ready to search through students database.

Initial search form asks you to specify your search.

You have a columns and conditions filters here.

Message at the right side tells you to enter search keyword, because you can't search using blank string. Notice this useful text with the yellow background. it always show you current search options in well readable format.

Once you started entering some search keyword smart search helper tried to read your search.

You can choose any column to search by. For example, let's choose Name. Our search helper asks you to enter search keyword. Sure...

And we will find all records which contains a. Very easy, isn't it?

Let's expan all search filters. You can see that search conditions for Age is different then for string. Let's list all available conditions for different field types here. String, Text, File, Image : is, is not, is empty, is not empty, starts with, ends with, like, contains, not contains. Date, Date and Time, Birthday : is, is not, is empty, is not empty, before, after, between. Number (both Integer and Decimal) : is, is not, is empty, is not empty, less than, greater than, less or equal to, greater or equal to, between For Drop Down, Radio Button, Check box, States, Language, Country, Time Zone controls you will be able to select choices which was added as a default values in the Form Builder. Also we will improve search filters for File and Image fields to include file size and extensions. It will be done along with another tasks for improving files functionality in MTH like: uplaoding multiple files or images, size and file type validations, file link in email notifications.

Remember that it will be the same for any HTML Form.

Back to our students database search. We will specify more search parameters. Will add age range, from 20 to 30 years old people only. Please, notice Add new search criteria link. Which is smart enough and will not allow you to add few search filters with the same column. Fools protection in action.

Join conditions and and or is another unique feature which allows you to build amazing search queries. You can combine them as you wish, there is no any restrictions or limitations. We believe that possibilities which we gave you in our search is good enough for any searchable database.

Finally we can get such a cool search. Our smart search helper reads it as Find records with name contains a or age between 20 and 30 and sex is Male or car is Ford

Was it helpful for you?

MyTaskHelper's users can add Captcha to their forms, change label placement, export files and even more.

As you should already know MyTaskHelper is a great way to upload and store files, music and video Everybody happy with a fact that they can save a lot of data on our servers. But people always wants more. You also need to be able to Export all files. Archived of course. This is why we added Export all files functionality. If you have file or image columns in your database you will see Export all files link on Records page. Clicking on which you will export all your database files archived. It will contain directories with a column name and all files uploaded to this field inside this directory.

Also, please, note that you can change column size now. It may be very helpful when you have a lot of fields, or want to improve your Database Widget

Captcha is a great way to protect your database from spammers. This is why we added such functionality for MyTaskHelper's users. You can enable captcha in Form Widget settings and it will appear on your integrated form immediately. Another great feature is label placement. By default all forms has Top Aligned field labels placement. But we are trying to give our users as much as possible options to customize their forms. So you can change default label placement to Left or Right aligned. Improve your beautiful forms now!

MyTaskHelper grows each day, we have users from all over the world. This is why next new features were very improtant for us. You can change the message text about successfully submitted form now, by default it says 'Successfully created'. The same you can do with Submit button label, just change the name of the button and make it more obvious for your country users!

And finally we applied all new features to our contact form

Please, feel free to contact us at any time with any questions or suggestions. Your comments very important for us!

Auto-complete functionality is a great way to add more power to your forms.

Auto-complete functionality implemented. Long live My Task Helper!

Auto complete from database is very easy to use from Form builder.

We have added one more great feature for MyTaskHelper's users called Auto-Complete. It does mean that you can set some set of default values for your Single Line fields and MyTaskHelper will try to help your users to fill field with auto-complete values by showing the list of possible values. When user enters first symbol in the field we will search in your predefined list of auto-complete values and will show the list of possible field values. Let's show it quickly on a small project. First of all make sure to create new project for testing this feature. Then add new form, it will be very simple form with just a few fields. Create State field with type of Single Line. Set some description text for your users. And now the most important thing - enter the list of auto-complete values, one per line. Click on auto-complete link. And copy and paste the list of US States. Here we are, let's see it in action. Great, it definitely works! Now you can go ahead and improve your forms to add more power and to impress your users! ;)

States field type added

To be honest previous example showed not very good example of how to add States field. Because now we have such field type in Form Builder! Select States field and create new field 'Choose your state'. That's it, see how States field works in action. Enjoy!

Birthday field type added

We keep improving our Free Form Builder. Making it more advanced, giving you new options. And today we are glad to introduce one more field type - Birthday. Yes, it's just a birthday, but I should admit it's so widely used field type! So why to do not add it? We thought the same and just added it. Thanks for My Task Helper's flexibility. Create new database for testing Birthday field. Add new testing birthday web form.

Now just go ahead and select Birthday type for your new Your Birthday field. Now you are free to try it. Click on Add Record link and add your new Birthday field. One more sweet thing to mention. Once you've added record with birthday you should see age in the data table. Yes, we calculating ages automatically for you. We will definitely go further and improve our search functionality to make it more easy for you to search through your databases. Now you know few more tips how to make your amazing web forms more powerful, so go and improve your the most beautiful forms!

New features in Form Builder

• Added new fields: Description text and Section heading. Now you can add some text to your forms and add section break to break some parts of your beautiful forms!
• Change your field size to make it more attractive for users. Previously you couldn't change, for example, 'Post code' field to make it smaller, but now you can do it easily.
• Add field description to help users fill the form.

New features in Widget Builder

• Added new options: Name and Description for both Form and Database widgets. Add text heading to your form or database to help your users understand what your form for. You can change font size and text color for this text.
• You can change font family on your widgets. You may prefer Times New Roman or Comic fonts, so we are bit more flexible now and can bring it to you.
• You can enable or disable email notifications about new submits. We added such option to Form Widget.

Added Blog for My Task Helper's users

We've implemented our own blog engine and integrated to our site. We moving from wordpress blog now.

Saving data online is what everyone think of each day. Web Database builder will help you to make it in a few moments.

MyTaskHelper is the best way to create own database for home business or for your office. To build an online database with this free service is very easy and it takes only few minutes.

New features in Form and Widget Builder:

Form Builder

New design: You can change field size now: Widget Builder

New design solution

New possibilities for your widgets:

1. Set your preferable font size for form description text:

2. And text color of course:

3. Set Logo's sizes:

4. Font size;

5. Font-family always wanted and makes your form unique!:

6. Link for redirect to another web page after data submitted;

7. Notification recipients;

For Database Widget you have new options:

1. Hide or show fields;

2. Allow records deletion;

3.Allow users to see all records;

We improved the way you adding default values and setting validations in the Form Builder

Now we using pop-up dialog to set default value or validation options. Also you creating new form in the pop-up window as well.

Site translated to Russian

We've translated My Task Helper to Russian. To see it in action, please, use link at the bottom of the page. Or click here

We improved the speed of our application, big databases runs very fast now.

Sorting and searching through database was improved as well as loading and opening your database. This changes affected both integrated and personal databases.

More options for your widgets

• Now you can change your forms and databases font size.
• Also it is possible now to change Logo size on both New and Database widgets. So we giving more and more options while implementing our users requests.
• If you have Email field (check Email validation in Form Builder) it will be linked in your database. It mean you can click on email and your email client will be opened, so you can start composing email to your email recipient.

Records module design improvements

We changed the look and feel of our Records module. Main functions hidden now with links Search, Export to Excel, Pagination, Delete Multiple. We believe it makes interface less messy and looks much better.

Pagination completely reworked to have select control instead of multiple boxes with page numbers

Interface is more ajaxified. All Sort/Search/Paginate actions will be supported with spinner image, so you can track the time of performed operation and to do not click on links while operation runs.

We have changed the structure of main page and updated articles page

Please, find the HowTo or article you need on Articles page

We have successfully upgraded our servers and updated site design

• Selecting fields sometimes can be difficult, when you have form with many fields. This is why you can select field and it will be highlighted now.
• Online database feature list updated on the main page.
  May be very helpful for new users.
• Facebook group created to help our users to comunicate and share thoughts and news.

No Duplicates option allows you to validate uniqueness of your columns.

Please, see below simple example of how to use this validation option

How to create simple database with validation No Duplicates

1) Create new project Validation Uniqueness 2) Create new form Validation Uniqueness (Enter form name into the field) 3) Add just one field to your new form "ID Number" with Number type Under field you can see link Validation 4) You will see various validation options in the pop-up window. Check No duplicates   5) Then Add record link 6) Now you have first record with "777" 7) If you will try to enter another record with such value you will see Validation Uniqueness in action This field have validation 'No duplicates', so you can add to database only one original record. Hope it helps!

We working on users suggestions and implementing them

• Search/Sorting and even pagination
  added to the any integrated Database Widget
  So your integrated database now can be searched and sorted by your users.
  For example, you can create the Shops database,
  on the first page you will integrate "Enter your Shop" form
  and on the next page you can integrate Shops widget,
  which will show the table with all shops, entered by your site visitors.
• Enabling/Disabling of form fields in the integrated Database widget implemented
  From the Shops example - your Shopw owners may want to leave
  login/password/any other confidential info about their Shop.
  So we need to have a way to hide this info from integrated widget -
  and now you do it from Widget menu for any form
• Sometimes you integrating your widget and entering some fake data to it.
  Then for deleting this rows you will need to login to MTH and delete this data.
  But in some case you may want to have delete link directly in integrated widget.
  This is why we added such option under the Database Widget in the Widget Builder menu.
• The view of records table was improved, duplicated Delete links etc

Thank you for all of this very valuable suggestions, and you should see that we implementing all of them.
So, please, continue sending us your suggestions and we looking forward to implement it.

We working on Widget builder now.
Thank you all for your help and support,
Your suggestions very important for us!

Site redesigned, upgraded, simplified user experience and, of course, added new features!

Please, check out new MyTaskHelper.com's design.
Changed color schema and menus, relaxed color schema.
We are trying to keep design very simple, so it's a pleasure to work with it every day.
Please, if you have any suggestions, just let us know.
Also we upgraded our servers, because we noticing growing of our users base.

• Now you can delete multiple records,
  we restyled list records tables, also see More link on each record row
• We moved all widget specific functions to separate menu Widget Builder,
  because we are going to improve it very much
• Restyled Form Builder, hidden forms tree, instead just just table view
• Restyled fields list
• Fixed several defect and many speed improvements

We working on Widget builder now, also going to add Edit Multiple features,
to being able to edit multiple records. Thank you all for your help and support,
Your suggestions very important for us!

Happy New Year! Google make big surprise for us.
We assigned PageRank 4!
We very appreciate about it.
Thank you all, it was very good year, next will be much better,
our users the best!

We very proud to be reviewed on KillerStartups.com http://www.MyTaskHelper.com - is not the first project we working on, but the first who was successfully reviewed on KillerStartups.com It was a good day at all ;)

Today was a new release of My Task Helper

Added possibility to get Total and Average for number fields, such as integer and float. Enhanced fields sorting. Improvement of records sorting and searching. Design changes. Currently we working on design improvement, new menus and help messages will appear soon. Thanks for your feedbacks and questions!

What's new

• Standardized interface, especially for Entities Page
• A lot of improvements for speeding up the whole system
• Design changes, standard icons created and added
• All email notifications runs asynchronously

Currently we working on database examples, database templates, interface, and other sweet things!

What's new

• Added possibility to get Total/Average for number properties
• Enhanced sorting of objects/entities/properties hierarchy
• Improvement for sorting/searching through objects
• Design changes

We are happy to announce that you can manage your database applications with your Team. Yes, you can add Team Members and Promote/Demote at any time.

From request:

• Being able to have one Administrator role who can manager,add, delete, edit, view entire database (who can also add users and subordinate roles with limited access)
• Any pre-regisitered user of the general public should be able to have a unique login and usernname to view the database (this would be the front-end of the database and should be capable of logging in an unlimited amount of people )
• Anyone that is not an Administrator or, with have subordinate role,
  can only view the entries in the database

And what you have now: Now on the 'Team' page you can search for any pre-registered user and add him to your database as a Member.

You can Promote to Owner, or Demote to Member at any time,
- if you are the Owner of database.

Members can only view records, and couldn't edit it.

Please, let us know if you see any defects, or have any further recommendation, because this functionality is in Beta stage.

We've implemented our own Forum for MyTaskHelper's users. Please, feel free to post your feature requests, report any issues or just anything there!

My Task Helper's users now have ability to see more information about their records such as:

• Unique id for record
• Created at
• Updated at
• IP-address of user, who added record

From the customers request we implemented

• Profile page, where you can change your details
• Team functionality finished, inviting users added

Thank you all for your help and support,
Your suggestions very important for us!

Teamwork, your colleagues will be happy to meet My Task Helper

Create database in MyTaskHelper and you are the database owner.

Click to Team menu item

One of the main MyTaskHelper feature is Teamwork. You can add people (MyTaskHelper users, your business partners, clients, other people etc). You can edit a database together using only web browser.

Use this form to add or invite team members Search in the Team pagebox Add Registered Team Members with "login or Email" field.

If the user is already in the MyTaskHelper system, you will have the option to select Add from the result list. If you do not find the user in the MyTaskHelper.com, please search by e-mail address. If the user is not found by e-mail address, you will have the option to 'Invite' the user. Click 'Invite', we will send the user an e-mail inviting them to become a team member, with a link to the registration form.

To change team member roles

Team members can be owners or members. Owners have all permissions to change the project configuration, content, and team. Members have the permissions that were assigned on the Admin page for members.

You can promote a member to an owner with Promote, and you can Demote an owner to a member, if there is more than one owner. Every project must have at least one owner.

Check Email validation and your users will not be able to enter wrong email. Choose length validation and you will not be able to enter more then that characters Length option has three parameters (Is,Minimum, Maximum);

Example: How to create simple form "Leave you comment/opinion/feedback" with validation Email, Length

1. Create new project "Validation"
2. On new form "Example form" add three fields "Name" - string type, "Email" - string type, "Comment" - text type Under each field you can see link Validation
3. After you clicked "Validation" will appear the window with validation types. For field "Email" choose Email, for field "Comment" choose Length (Minimum 25 symbols)

4. Next step : click "Add record"
5. Enter your data into the field

In Fields "Name" and "Comment" MyTaskHelper will check entered data. If you entered correct data you will see the record form So, you know how ease to create simple database with MyTaskHelper You can place this form into your site using Widget Builder, more about this service you can read here

MyTaskHelper is the good assistant to your business. By means of the given service is possible to create a database quickly and easily and to place it on your site. Command work above base is accessible. Access to your data is possible all over the world, connection to the Internet network is necessary all. MyTaskHelper guarantees safety of your data; You can read more detailed about a policy of confidentiality here. Today MyTaskHelper became even more convenient in use. By means of new service Widget Builder is possible to edit the forms created by you. By default color of the form of pleasant silvery color, But at integration on sites some users had a desire to change color of forms in a combination to design of their site. Specially for this purpose has been developed Widget Builder. Besides color of the form probably also to set the sizes (height, width), (top and bottom margins, left and right margins), to set borders, scrollbars. Also You can to insert into the form a trade mark (logo) of the firm. Below to be resulted the detailed description of the given properties: After you have created the form in menu Form Builder You can pass to Widget Builder menu for its editing. You can see the table "sites list widget". In column "Description" - the description of changeable parameters, and in column "Value" - their value. Description:

• Background color (Text color) – You can enter a code of color or choose color manually having pressed on the reference Pick;
• Logo – The sizes of a trade mark (logo) for the form 150x55px;
• Height (Width) – You can enter the sizes of the form in pixels or in a percentage parity;
• Top and bottom margins (Left and right margins) – The sizes in pixels;
• Enable scrollbars – You can select: Yes, No, Auto;
• Border – Has two modes: Yes, No;

To update the form press the button Update Widget Settings. Below you can see the form after editing. To integrate it on the site press the reference "This Code", copy a code and place it on the site. Widget Builder has the important feature. You can hide fields on the Records Form from the clients. To define what fields it is necessary to show, and what are not present choose them from the list. Services of search and sorting are accessible to convenience in use on the Records Form. Now your clients can easily find the necessary record in the list.

Today I'd like to tell about new validation types: Inclusion, Exclusion.

Inclusion validation (for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text must be carried in field record not allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null):

• Partial match – using this parameter user allows to enter words or phrases, which contains record in field Within;
• Case sensitive – possibility to include/disconnect register;
• Allow null – user can leave the field empty;

Exclusion validation( for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text can not be carried in field record, allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null):

• Partial match - using this parameter user allows to enter words or phrases, which contains record in field Within;
• Case sensitive - possibility to include/disconnect register;
• Allow null - user can leave the field empty;

Example of database creation: “Tow fields ”

Steps:

1. On "My Projects" page create new project “Tow fields”
2. Create new form “Test”
3. Into the form place two fields: string type “one line”, text type “multiple line”

4. Under field click on link Set Validation, then in the window choose for field “one line” Inclusion, for field “multiple line” choose Exclusion.

For “one line” in field Within you can enter words/phrase, which must be included in the list! For “multiple line” in field Within you can enter words/phrase, which must not be included in the list!

5. Next step click "See Test in action" and enter you data

6. MyTaskHelper will check the data that you entered.

When you correct all mistakes click "Create" Now you have first record: Now you see how easy and quickly to create a database with MyTaskHelper.

In common usage, validation is the process of checking if something satisfies a certain criterion. Examples would include checking if a statement is true (validity), if an appliance works as intended, if a computer system is secure, or if computer data are compliant with an open standard. Validation implies one is able to document that a solution or process is correct or is suited for its intended use.

In computer terminology, validation refers to the process of data validation, ensuring that data inserted into an application satisfies per-determined formats or complies with stated length and character requirements and other defined input criteria. It may also ensure that only data that is either true or real can be entered into a database.

With using Form Validation now MyTaskHelper web database builder is a really powerful tool. By means of this service you can greatly increase your database fields. When you making the form in Form Builder module for each field you have link Validation. Click on it and you will see the window, in which you can select required validation type.

Detailed description of the MyTaskHelper validations types :

• No duplicate entries

This option allows to check record uniqueness (in field string); presence in database alike importance (for fields integer, float); checking the files and images are conducted with alike names (for fields file, image); also for fields language,country, time_zone validation uniqueness will allow to check presence such record; for field check_box given option allows to choose concrete element from list only once.

• Validate only on Submit.

Given option is addition to all. Having chosen it user indicates that check by field follows to produce only after striking the button "Create".

• Email

For fields string, text, possible to choose Email validation. Сhecking for presence in field email address.

• Presence

The User installs check of presence record in a field.

• Length

Possible assign necessary length of the field. Length option has three parameters (Is,Minimum,Maximum);

• Inclusion

Inclusion validation(for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text must be carried in field record not allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null): Partial match – using this parameter user allows to enter word or phrase, which contains record in field Within; Case sensitive possibility to include/disconnect register; Allow null – user can leave the field empty.

• Exclusion

Exclusion validation (for fields string, text) enables user strictly to define introduced text in the forms fields. User can indicate what exactly text can not be carried in field record, allowing entering of other words/phrases. The option has three additional parameters (Partial match, Case sensitive, Allow null): Partial match using this parameter user allows to enter word or phrase, which contains record in field Within; Case sensitive – possibility to include/disconnect register; Allow null - user can leave the field.

• Only upload (default value)

Option for fields File, Image. File or image are loaded from Form Builder page and serves importance for base by default.

• Acceptance

Given option is used for field check_box in events if necessary agreement to some information on form.

Today I’d like to introduce new validation types: presence, validate only on submit.

The best way to see how it works – real example.

How to create simple database.

Registration form in 5 minutes

Registration form

Quick and easy way to create a client list.

Steps of creation:

1. Login to MyTaskHelper
2. Create new project “First project”
3. Create new form “Registration form”
4. Now you can place into form fields: name, username, email, address, bio, photo, registration date, etc.

Your form should look like this:

5. Ok, so now we have form with fields. Good. Have a talk about validation. Under fields click on link “Set validation”. Appear new window with all validation types. Choose those needed. To all fields select presence, validate only on submit.

Presence - this option don’t allow for user leaves fields blank. Validate only on submit - if you select this system feature will check all fields only after pressed “Create”. For field "Username" also you can select Uniqueness, more about this option here, and for field Email select Email.

6. Enter you data. It should look like this

If you have done everything correctly you will see first record.

• You can find/sort clients in your database using search/sort functions.

• Now you can place this form into your site using Widget Builder. More about this service please read here.

• MyTaskHelper supports TEAM WORK. You can edit “Clients list” with team.