Thursday, November 5, 2009
Custom Views for your Relevant Tools Online Database
You can easily create custom views for your online database. With a custom view you can control which columns are data are displayed and the order of display. This is particularly useful if you have a database with a lot of fields that are used for different functions. For example you can define a contact view, a status view, a performance view, and so on.
To get started click on databases. Make sure your database that you want to define the view for is selected as the current database. Click on 'create/edit/delete' a view to start the process of defining or customizing a view.
To create a new view give it a name or you can select an existing view to edit.
Select the field that you want to use for each column. You can also specify the maximum column width if you want to have some columns be wider or narrower.
In addition to using any of the fields that you have defined for your database you can also include system fields in your view. System fields are fields such as "created on" or "IP address" that are automatically added to each record.
When you display your database you can toggle the view from 'all user defined fields' to the views that you have defined. The fields will be displayed in the order you have specified.
In addition to controlling the view that you see on the screen, views are also used to control what data is exported. When you export your database only the fields that are used in the current view are exported. If you want all fields exported make sure you are using the view 'all user fields'. If you want to export system fields such as the date created and IP address you will need to define a view that includes those fields.
Have fun creating views for your data. You can change your views at any time.
To get started click on databases. Make sure your database that you want to define the view for is selected as the current database. Click on 'create/edit/delete' a view to start the process of defining or customizing a view.
To create a new view give it a name or you can select an existing view to edit.
Select the field that you want to use for each column. You can also specify the maximum column width if you want to have some columns be wider or narrower.
In addition to using any of the fields that you have defined for your database you can also include system fields in your view. System fields are fields such as "created on" or "IP address" that are automatically added to each record.
When you display your database you can toggle the view from 'all user defined fields' to the views that you have defined. The fields will be displayed in the order you have specified.
In addition to controlling the view that you see on the screen, views are also used to control what data is exported. When you export your database only the fields that are used in the current view are exported. If you want all fields exported make sure you are using the view 'all user fields'. If you want to export system fields such as the date created and IP address you will need to define a view that includes those fields.
Have fun creating views for your data. You can change your views at any time.
Custom Views for your Relevant Tools Online Database posted by Jean Christofferson @ 3:40 PM 
