Multiple Selection List: When One is Not Enough

When you add or edit data with DbEasy using the dynamic editor form it will automatically create the input controls you need to link data between two tables. Tables can have two types of links:

  • One-to-many
  • Many-to-many

An example of a one-to-many link is Employees and Departments. An Employee belongs to one Department. A Department has many Employees. The usual way that DbEasy implements this is with a drop-down list. When you are on the Employee editor form you will see a drop-down list for Department. When you click the drop-down you will see a list of all the departments: Marketing, HR, Facilities, Customer Service, IT, etc. When you select one then you will have created a link between that employee and the Department table.

An example of a many-to-many link is Students and Classes. A Student can have more than one Class and a Class will have more than one student. Another example is the Ageless Outings website. Ageless Outings is a guidebook of day trips within the greater Denver region. Each trip has a Destination. Each Destination can have one or more Restaurants nearby. A restaurant can be near more than one destination.

For the many-to-many link between Ageless Outings Destinations and Restaurants the DbEasy multi-select list provides the user interface for selecting multiple Restaurants for each Destination and vice-versa. When you log into DbEasy you will see that the main menu provides access to three main entities: City, Destination, and Restaurant.

Destinations and Restaurants have a many-to-many relationship.

A Destination can have one or more Restaurants associated with it. A Restaurant can be associated with one or more Destinations.

When you are in the Destination editor you can scroll down to the bottom and see the list of Restaurants

There is currently one restaurant selected, “Bridgewater Grill.” If you click anywhere on the button it will open the dropdown list. Notice the “Bridgewater Grill” is checked in the list.

If you click other Restaurants then the multi-select dropdown will add them to the list of selected restaurants.

The multi-select also has a search box that lets you narrow down the list by typing. As you type it will filter the list to just those values that contain what you type. So in our Restaurant example if you type “Br” the results will include “BJ’s Brewhouse,” “Bridgewater Grill.” and “The Olive Branch.”

You also have buttons that let you check all the items, “Select All,” remove all items from the list, “Select None,” or go back to what was selected before you clicked the dropdown, “Reset.”

The multi-select control in DbEasy makes it easy to enter data when your database has a many-to-many relationship.

Embed a DbEasy form in Your WordPress Blog

The DbEasy custom forms editor is how you present your application to your users. In our last post we covered how use create a form:

Create a Custom Form with DbEasy

Once you have your form completed, how you do use it?  You have two options:

  1. Link to your form
  2. Embed your form

A link is just a URL to your form running on a publicly accessible area of the DbEasy website.  Embedding is where you create a window or frame within your own website and the from appears within it.

The DbEasy form editor shows you the correct form for each at the bottom of the page:


If you have WordPress blog then you can embed your form with the following steps:

  1. In the DbEasy form editor select the code for “Embed your form” starting at the “<iFrame” and going to the end “</iFrame>” and copy it into your clipboard by pressing Control-C.
  2. Edit the WordPress blog post where you want to embed the form.
  3. At the top right corner on the WordPress editor there are two tabs, Visual and Text.  Click Text.
  4. Paste the embed code into your blog article where you want the form to appear.
  5. Click the Visual tab and you should see your form appear like the example below.
  6. Publish your blog post and the from should appear and be usable.

Below is an example of an embedded form:

If you enjoy this blog then please subscribe by entering your email in the form below




Create a Custom Form with DbEasy

The DbEasy custom forms editor allows you to open up your database to world.  You select tables and fields from your database, define how they appear and then embed the form in your blog or website.

For example, let’s say that you have signed up for DbEasy and selected Contact Manager for your base application.  Now you want to create a form to let people give you their email address.  Start at your DbEasy dashboard and select “Add a New Form.”


This will take you a screen where you can select one of the tables in your database.


In this example we are going to select the EmailLists table so we can create an email address collection form.

DbEasy will give your form a name based on the table you select.  If you are going to have more than one form for the same table you give them unique names so that you can keep them straight.  The user does not see the form name so it’s fine to leave it as is.  When you click the Save Form then DbEasy will take you to the Form Editor.


The Form Editor gives you a list of fields from your table and other features to control the appearance of your form.

  • Choose which fields appear
  • Specify the order
  • Define the labels
  • Change the text of the submit button
  • Define the text to show your users after they submit their data

Click on any field in the field list to add it to your form:



Then click on the Edit button to change the prompt:


Type your new value and click Update.


You can also change the text that appears on the button your user clicks to send the form.  By default the button will have the dweeby label. “Submit,” but you can have it say anything you want.



The last thing that you can customize is the page that appears after your user submits the form.  For this we give you an HTML editor so that you can create rich formatted text.


The HTML editor lets you choose text styles H1 – H6 (Heading 1 through Heading 6), text decorations like bold, underline, and strike-through.  You can indent, use bullets, numbered lists, insert images and add links to other web pages.  Basically anything you would find in a web page you can create with our HTML editor.

Now you can view the form and see how it will look to your users.


You’ll be able to see all your customizations.


You can even try it out yourself, entering data, clicking the button, and then you’ll see the response page that you designed.


Now your form is ready to put out on the web.  DbEasy provides you with the URL to link to your form and the HTML code to embed it:




Create an Online Database in Minutes with DbEasy

DbEasy makes databases easy.  We provide database hosting with a dynamic mobile web user interface.  What this means is that we provide you a “database in the cloud” that you can access from anywhere.  Your data is secure, only accessible through your login.  We provide you with basic editors that let you add, view, update and delete data with any of the tables in your database.

You can start using DbEasy right now, for free, and have a database created in minutes.  Begin by going to


Start by clicking the Sign Up button.  Then enter your email address and create a password:


Your email will be your login ID, no need to remember a separate user name.  DbEasy will now send a confirmation code to your inbox:



Click on the link in the email and your account is activated and ready for login:




The first time you log in the system will ask you to select a base application:


DbEasy gets you up and running quickly with a catalog of professionally designed database applications.  We are always expanding and improving this catalog.  Some of the base applications include:

  • Shopping Cart
    • Define products
    • Track orders
    • Integrates with PayPal
  • Contact Manager
    • Collect opt-in email addresses
    • Track opt-outs and bad emails
    • Do email marketing
    • Track responses
  • Registration System
    • Allow people to register online for classes or events
    • Manage instructors
    • Set up schedules
    • Let people pay online for classes or events

When you click one of the buttons the system will do several things automatically:

  • Allocate a SQL Server database
  • Create all the tables for you selected application
  • Walk you through configuration
  • Setup your system dashboard

This is your DbEasy dashboard:


We will cover all of the dashboard functions in a later post.

To get started with your own online database just go to and follow the instructions in this post.

Updated Home Page Shows what DbEasy can Offer

We’ve updated the home page of with a clean, three-column, mobile-friendly layout.  The top of the page features a banner and tag line with three simple options:

  • Sign-up
  • Learn more
  • Log in


DbEasy mobile web application services

The “Learn More” links to this blog because this is where we document all the news, features, and success stories for DbEasy.

As you scroll down you see a grid with icons and text describing some of the applications you can create with DbEasy:

DbEasy sample applications

This layout is mobile friendly.  When you view it on a small view port like your phone it collapses into a single column:


When you scroll down you see more:


As we continue to develop new features and applications for DbEasy we will add to and improve the home page.


Required Field Validation

When you create a new table with DbEasy you can specify that some of the fields are required, meaning that you cannot save a record to the database unless you enter a value for those fields.

For example here are the fields in the standard DbEasy People table:


Notice that First name and Last name are marked with asterisks. This means that those fields are required.  You can have a person without a title, middle initial, suffix, email, or gender.  But the minimum that we need to have is the person’s name, both first and last, for the record in the database to be useful.

DbEasy helps you out with this by providing validation messages.  If you leave out the values in either of these fields and click “Add” then you will see this message:


When you fill in all the required fields then you can save the record.

This is yet another example of how DbEasy makes it easy to create your own custom web application.  You get clear, friendly error messages without doing any programming.


DbEasy Dynamic Input Fields for Enhanced User Experience

At DbEasy we are all about your experience.  We provider simple and easy editors for every table in your database.  They automatically adjust the input to match the field type.  For example, if you have a true/false field then we provide a check box:


If you have a list of valid values for a field then we give you a drop-down list:


And when you have a date field then we provide a popup calendar for easy entry:


This calendar control is part of the Angular UI project.  Remember, DbEasy is built with technology from Google and Twitter and the calendar control is one example.  We find the best technology and learn all the nitty-gritty details so you don’t have to; you can just take advantage so that your website stands out as a great user experience.

The Angular UI calendar has some nice features.  One disadvantage that many popup calendars have is that you can’t easily go to a long ago date, like a birth date, because you have to go month-by-month.  But this calendar has handy year navigation.  Start by clicking the calendar header to get into Year Select mode:


Then click the Year Header to get int Decade Select mode:


Then navigate to your decade:


And select the year and then the month:


And you can easy navigate visually to any past date:


These are just a few examples of the DbEasy enhanced mobile web UI.  We will be continuously seeking out the newest and best mobile web user experience and adding it to DbEasy so that you can use DbEasy to build your own great apps easily.




dbEasy Using Technology from Google and Twitter

We are now about to release a new version of dbEasy™ mobile web database application creator that makes use of two exciting new technologies from Google and Twitter:

  • AngularJs
  • Bootstrap

AngularJs is an application development framework, created and fully supported by engineers at Google that is focused on data, especially from a database service like dbEasy. It allows us to create a rich and friendly web user experience.  It provides the most modern user interface capabilities with interactive forms and data elements that will work on any device: computer, tablet, or phone.

Bootstrap is a CSS framework created by engineers at Twitter for designing mobile-first web applications.  It features responsive design that detects the viewer’s device type and screen size and then automatically adjusts the layout to provide the best user experience.

Angular and Bootstrap are part of the latest trend in web development, used by some of the largest and most popular websites and companies.  The bad news is you need to be a programmer or web designer to take advantage of these tools for your website.  If you are a small business person without a technical background or large IT budget then this great experience for your users is beyond your reach.

Unless you are a dbEasy™ member.

dbEasy takes care of the technical details for you.  You choose what information you want to collect and provide through your website, what application features you want your website to have, and dbEasy creates the application for you using the latest web tools.

This gives you as a dbEasy™ member several advantages:

  • Core technology support by the worlds largest Internet companies so that your dbEasy™ applications will be based on secure and stable technology.
  • Fully functional mobile web applications without going through the time and effort of a large software development project.
  • Complete database hosting, application services, and optional website hosting for an affordable subscription cost

Your customers can use your dbEasy™ applications on any device.

  • Personal computer
    • Windows
    • Mac
    • All major web browsers
  • Mobile device
    • iPad or iPhone
    • Droid tablet or phone
    • Windows tablet or phone

Your customers will have the best user experience and you don’t need to hire an IT staff or learn programming.  By leveraging the best available technology we at dbEasy™ empower you with the coolest new technology that frees you to focus on running your business.

Fill out the form below and we will notify you when dbEasy™ is available to help with your business success.

[contact-form][contact-field label=’Name’ type=’name’ required=’1’/][contact-field label=’Email’ type=’email’ required=’1’/][contact-field label=’Website’ type=’url’/][contact-field label=’Comment’ type=’textarea’/][/contact-form]

Don’t miss this opportunity to one of the first members of what’s sure to become one of the most popular websites for business success through mobile web application services.


How a Web Database Can Make You Money

A database is any collection of related information, or data, that is organized for convenient access.  A sorted collection of baseball cards could be considered a database, but usually we think of databases in a computer.  A relational computer database organizes information into related tables with rows and columns.  I’m sure that you probably already knew this, but did you know that a database can make you money?

There three common ways that you can make money with a database on the Internet:

  1. Selling information
  2. Reducing expenses
  3. Enabling customers to take action
The information in your database can be your product to sell.  Or a database can reduce your costs.  Since profit equals revenue minus expenses then savings in expenses mean more money in your pocket.  However, you need customers to take action to gain revenue and a database will help them do that by automating your business processes.

Info for Sale

If you have a collection of information that people would find valuable then a database will allow you organize it for sale. Think of all the non-fiction books for sale in bookstores. Many of these are collections of information that come from a database. Any book or reference resource that has multiple entries, each with similar types of details then this information can take advantage of database rows and fields:

  • Travel guides
  • Repair manuals
  • Business contacts
  • Trading systems
  • Recipes
There are a few ways that you can use a database to sell information. You can sell subscriptions for members to access the information online. You could also compile the information into an e-book. You could give the information away for free and make money by advertising.

Automatic Savings

Do you have an existing business where you have staff to service customers? You can setup your website to allow customers to serve themselves:

  • Check order status
  • Update address
  • Report problems
  • Provide online manuals
  • Answer frequent questions
This will allow you to serve many more customers with the same staff, saving you money.

Robot Workforce

Finally, a web database can make you money by helping you bring in more income.  By automating your order process you can take orders 24/7/365, bringing in income you’d otherwise.  Remember, your website is the same distance from your target market as is your competitor’s: one click. When a customer visits your site you need to be able to close the deal.  If you’re a hotel you need to take reservations, if you’re a service business then your customers should be able to make appointments, if you’re in real estate then your customers need to be able to see your current listings.

A web database can perform these services automatically, acting as robot workforce, turning website visitors into customers, bringing you money.


Welcome to the World of dbEasy

dbEasy is an online web database application creator and hosting service.  This blog, authored by Ray Wampler, creator of dbEasy, will explain what that means and how you can use hosted web applications on your website to make your business or organization more successful.

There are several types of people that can benefit from dbEasy.

  • Anyone who has a website can make it interactive without needing to install, learn and maintain complex and expensive technical systems
  • Web designers can offer their clients applications workout having to do programming
  • Marketers can make money helping businesses achieve their goals

The dbEasy blog will provide helpful how-to articles for each of these audiences and anyone else who can benefit by inexpensive, easy-to-use web database applications.

If there is a topic that you would like to hear about, then please let us know by adding your comments below.