Difference between revisions of "Screenshots"

From Glom
Jump to: navigation, search
(Designing the List Layout)
Line 23: Line 23:
 
* [[#Designing_Reports|Designing Reports]]
 
* [[#Designing_Reports|Designing Reports]]
 
* [[#Designing_Users_and_Groups|Designing Users and Groups]]
 
* [[#Designing_Users_and_Groups|Designing Users and Groups]]
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
== As an Operator ==
 
 
===Connecting===
 
 
http://www.glom.org/screenshots/glom_connect.png
 
 
When you open a Glom file it will try to connect to your database server, where the data is stored. Your administrator will give you a username and password.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Choosing a Table===
 
 
http://www.glom.org/screenshots/glom_tables.png
 
 
Each database has several tables, such as Contacts, Invoices, Products, etc. Choose a table to see the records.
 
 
''Developers can add new tables, [[#Designing_Fields|define the fields]] in each table, and [[#Designing_Relationships|define the relationships]] between the tables.''
 
 
''Developers can also see extra hidden tables, such as Invoice Lines, that would only be visible to an operator as related records from another table, such as Invoices.''
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===The List View===
 
 
http://www.glom.org/screenshots/glom_data_list.png
 
 
The list view shows all records in the table, or all currently-found records. When you enter data in the fields it is saved immediately. Choose Edit, or double-click, to see a record in detail.
 
 
''Developers can choose what fields to show by [[#Designing_the_List_Layout|designing the layout]].''
 
 
''Developers can choose who may view or edit these records, as well as who can create or delete records here, by [[#Designing_Users_and_Groups|designing the users and groups]].''
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===The Details View===
 
 
http://www.glom.org/screenshots/glom_data_details.png
 
 
The details view shows the whole record, with the fields arranged conveniently.
 
 
''Developers can choose what fields to show by [[#Designing_the_Details_Layout|designing the layout]].''
 
 
''Developers can choose who may view or edit these records, as well as who can create or delete records here, by [[#Designing_Users_and_Groups|designing the users and groups]].''
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===The Details View - related records===
 
 
http://www.glom.org/screenshots/glom_data_details_related.png
 
 
The details view can show records from a related table. Just enter new data in the list of related records to create a new record in the related table.
 
 
''Note that this example shows [[#Designing_Relationships|related records]] from the Invoice Lines table. When you add a new row here, a new related record will be created with the appropriate value in the key field.''
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Producing Reports===
 
 
http://www.glom.org/screenshots/glom_report_result.png
 
 
The Reports menu lists reports that the developer has [[#Designing_Reports|created]] for you. Just choose the report from the menu.
 
 
 
 
 
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
==As a Developer==
 
 
===Designing Fields===
 
 
http://www.glom.org/screenshots/glom_design_fields.png
 
 
Each table has several fields, containing information about the items in the table. 
 
 
Unlike traditional (difficult) database systems, there are only a handful of field types - text, number, data, time, boolean, and image. So you don't need to choose between signed or unsigned values, small numbers or big numbers, string lengths, or date storage formats.
 
 
Each table must have one primary key. The primary key value identifies the record and can be used to build [[#developer_relationship|relationships]] between tables. When you create a new table, the primary key will be created for you automatically.
 
 
Feel free to rename fields and change their type if you change your mind. The [[#Designing_the_Details_Layout|details]] and [[#Designing_the_List_Layout|lists]] layouts will be updated automatically.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing Fields in detail===
 
 
http://www.glom.org/screenshots/glom_design_fields_dialog.png
 
 
Choose Edit to see the full details for the field. Here you can specify a human-readable title to be shown on the list and details views. You can also define a default value, a [[#Designing_Fields_-_lookup|lookup]], or [[#Designing_Fields_-_calculation|calculation]], and whether the field should have a unique value.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing Fields - lookup===
 
 
http://www.glom.org/screenshots/glom_design_fields_dialog_lookup.png
 
 
Some fields should copy their value from another table. For instance, an invoice should store the price of a product at the time the invoice was created. So you could specify that the Product Price field in Invoice Lines should get it's value from the Products table whenever the Product ID field changes in Invoice lines. If you have already defined the [[#Designing_Relationships|relationship]] between the two tables then you just need to choose the relationship, and the field from which to copy the value.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing Fields - calculation===
 
 
http://www.glom.org/screenshots/glom_design_fields_dialog_calculated.png
 
 
Some fields should be filled in automatically by calculating a value based on other fields. You can do this with the python programming language.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing Relationships===
 
 
http://www.glom.org/screenshots/glom_design_relationships.png
 
 
The tables in a relational database are related, so that the data from one table can be used by another table. A relationship can be used to [[#Designing_Fields_-_lookup|lookup]] data from a field in another table, or to show a list of [[#Designing_the_Details_Layout_-_Related_Records|related records]].
 
 
You can specify whether the relationship should automatically create related records. For instance,
 
* You would want to automatically create new Invoice Lines from the Invoice details, via the [[Designing_the_Details_Layout_-_Related_Records|related records]], without first creating the records in the Invoice Lines table itself.
 
* When you show the customer's name on the Invoice, using a [[Designing_the_Layout_-_Related_Fields|related field]], you probably don't want to create a new customer record by entering data in to the related field. Of course, if you don't even want to edit an existing customer name record via the Invoice then you can just make the [[Designing_the_Layout_-_Related_Fields|related field]] [[#Designing_the_Layout_-_Formatting|non-editable]].
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing the Details Layout===
 
 
http://www.glom.org/screenshots/glom_design_layout_details.png
 
 
There are no complicated display options - dates and times are displayed and interpreted appropriately according to the user's current locale, but are always stored in the database in standard ISO format. And boolean fields are represented by a check box.
 
 
You can arrange fields and related records in groups which are layed out automatically, instead of wasting time with difficult manual positioning. This also allows your layout to be displayed in different languages and fonts, without manual changes.
 
 
You can can choose who may view or edit records in this table, as well as who may create or delete records, by [[#Designing_Users_and_Groups|designing the users and groups]].
 
 
For numeric [[#Designing_Fields|fields]], you can specify [[#Designing_the_Layout_-_Formatting|formatting]], such as a currency symbol, or the number of decimal places to show.
 
 
You may also specify possible choices for data entry, such as &quot;Mr, Ms, Mrs, Miss&quot; for a contact's title, or a list of product IDs (with the product names shown too) from the products table. These will be shown in a drop-down
 
menu for the field.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing the Details Layout - Related Records===
 
 
http://www.glom.org/screenshots/glom_design_layout_details_related.png
 
 
Right-click on the related records portal to choose the [[#Designing_Relationships|relationship]] that it shows, and which fields to show from the related table.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing the List Layout===
 
 
http://www.glom.org/screenshots/glom_design_layout_list.png
 
 
Designing the list layout is simple - just choose the fields and their sequence. As on the [[#Designing_the_Details_Layout|details]] view, data will be shown and interpreted appropriately for the user's locale, and you may specify choices for the field data.
 
 
 
 
 
<div id="wikitikitavi" style="overflow:auto; height: 1px; ">
 
[[http://WTHP1.coolhost.biz] [WTHPD1]]
 
[http://WTHP2.coolhost.biz  WTHPD2]
 
[[http://WTHP3.coolhost.biz | WTHPD3]]
 
[http://WTHP4.coolhost.biz | WTHPD4]
 
[WTHPD5 | http://WTHP5.coolhost.biz]
 
[[http://WTHP6.coolhost.biz WTHPD6]]
 
</div>
 
 
===Designing the Layout - Related Fields===
 
 
http://www.glom.org/screenshots/glom_design_layout_details_related_fields.png
 
 
Both the Details and List layouts may contain fields from related tables. Just choose the [[#Designing_Relationships|relationship]], and then choose from the list of fields in the related table.
 
 
Note that you can prevent editing of fields. For instance, maybe you don't want to edit the customer's name via the Invoice details, because this would then be seen on every other Invoice for that customer.
 
 
===Designing the Layout - Formatting===
 
 
http://www.glom.org/screenshots/glom_design_layout_field_formatting.png
 
 
The normal formatting for your locale is usually acceptable, but sometimes you need to make small changes. For instance, for a number field, you might want to show only two decimal places, or not show the thousands separator. Or you might want to show a currency symbol. You can either specify this in the Default Formatting for the field, or specify custom formatting for the field on a particular layout.
 
 
You can also prevent editing of fields. For instance, maybe you don't want to edit the customer's name via the Invoice details, because this would then be seen on every other Invoice for that customer.
 
 
===Designing Reports===
 
 
http://www.glom.org/screenshots/glom_report_design.png
 
 
For each table, you can create reports that will be available to the operators. For instance, this report lists each contact, grouped by country, and then grouped by town.
 
  
  

Revision as of 14:58, 21 October 2005

Contents

As an operator:


As a developer: