The Ultimate Cheat Sheet on Database Application Part 1

Ace in sleeve cheating


When designing your database application, there are some tricks of the trade you should know to create the best apps for your business. Here is a list of properties you should be aware of.


Single line text field

This is the most boring field of all, until you learn about these three properties. You can flag a single line text as being an email address, a phone number or a civic address.


Email address

The email address field will allow you to directly send an email without getting out of your application. This eliminates the necessity to manually open your email application (Apple Mail, Outlook, etc.) and copy-paste the email address. With a simple click of a button, the system will do it for you.


Phone number

The phone number field gives you access to make a call with Skype on your desktop or mobile device. It is also allowing you to directly send text messages from your mobile device.


Civic address

The civic address field will show you a map of the inputted address, with just a click of a button. This is especially useful when you are on the road and you need some quick help with your location.



Multi Line text field



What is that? WYSIWYG stands for “What you see is what you get”. Applying this property to a multi line text field will allow you to edit the text in this field with the usual icons, just like you would in a word processor. You can then change the font, paragraph and styling of the text you enter in this field. Advice to the wise though, I don’t suggest you go overboard with the styling of your text. Too many colours, fonts and overall styling will just get in the way of the legibility of your data.


Text editor

The text editor property will simply add an “expand” button to your field. When you will click on it, it will open this field in a bigger new window. This is useful when you need to input large quantities of text such as comments or progression notes but you don’t want to use too much space in your application to keep it brief and easy to use.



Date & Date-Time fields


Calendar default

You may have more then one date and/or date-time fields in one application. When you want to view your data in a calendar, you need to select one of those date fields to display your data. If you know you want to use the same field most of the time, you can simply click the calendar default checkbox to save this specific field as your calendar default.

Created on & last saved

Again with a simple click of a checkbox in your date or date-time field, you can make this field automatically record the creation date or the last saved date for each of your items. I especially like to use the created on property in sections such as a comment section. It allows you to know exactly when a specific entry was made.


For date or for date-time fields, it is sometimes practical to have a range instead of a fixed date and time. This feature comes especially handy when you are dealing with appointments, events or meetings. This also gives you the opportunity to manage your time efficiently viewing your items in a project specific or a multi-projects calendar.



Dropdown field

Separated selection

The separated selection property allows the user to see the values on the left box and move the desired values to the right box with the arrows. This is especially useful for the visual users who need to keep in mind what were the potential values and what are the ones he actually selected.

Inline editing

The inline editing property is great when there are constantly new values added to your list. Instead of having to go back to your application to add the new value, you can simply click the plus icon and enter the new value in the pop op window that just opened. This is a major time saver for regularly edited field values. Note that this property is also available for the tree field.



This entry was posted in Database Application. Bookmark the permalink.