This shows you the differences between two versions of the page.

Link to this comparison view

table [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Tables ======
 +A table is a concept you may be familiar with from other database applications:​ it holds the [[Record|records]] you create. ​
 +==== How to Create ====
 +  - To create at table, click the {{::​table.png?​direct|}} on the [[Block Creator]]. ​
 +  - Name table using the singular form. You can correct the suggested plural version if necessary. ​
 +  - Choose an icon.  ​
 +  - All tables start with a [[Field Type - Short Text|short text]] field called Name that is the default name of the record. (A [[Concepts - Automated ID|unique identifier]] in WorkXpress is created in the background and consists of letters and numbers. The default name is **not** the unique identifier.) The name field can be customized later when you are adding records. For example, you could use a [[Action Type - Save Field|save field]] action to set the value of the name field to be more meaningful, perhaps concatenating other fields such as record creation date and the name of the user who created the record. The name field is also the default field that will appear in a [[Field Type - Selection|drop down selection field]]. You can change this default behavior on the particular field if you wish. 
 +  - You can choose to have the table added as a tab (Application Tabs are different than a [[Form Type - Tabs|tab form]]), as a link on a menu, or you can set it up yourself later. If you are just beginning, putting links for your tables on one menu is any easy way to centralize access to your tables while you are building. You can click on the "​Admin"​ link in the upper right corner of your screen to move to that screen and select a location for the table link. The wizard will reappear at the same step after you click the Admin link.
 +  - Next you will choose how you want to add records. For a simple table with only a few fields, you can choose a list with inline add/edit. However, tables can often become more complex as you develop your application,​ so it is best to select a list page with view/edit details page and an add page. This will make it easier for you to view, edit, and add complex records later on.
 +==== How to edit ====
 +On the [[Block Creator]], click on the [[Handbook]] {{:​handbook.png?​direct|}}.
 +In the section on tables, you will see options for:
 +  * **Create Table**
 +  * **Delete Table**
 +  * **Edit Table**
 +==== Settings ====
 +To change any of the settings on a table, click the Edit Table option from the WorkXpress Handbook. Choose the table you wish to edit and the wizard will guide you through changing any of the below settings.
 +  * **Table Name** - This is the name (singular form) by which this table will be referred to throughout the application.
 +  * **Plural Name** - This is the pluralized form of the table name. 
 +  * **Icon** - The image that represents this table. ​
 +  * **Small Icon** - This icon (small form) will be used throughout the application to refer to this table. Some examples include all [[Form|forms]] (except [[Form Type - Page|pages]]) associated with this table and all automatically created links for this table (search, add, view).
 +  * **Table Title Field** - For any given record, use this [[Field|field]] as its title. For example, on a table called "​Account",​ the system will automatically create "​Account Name" as the default title field. Only [[Field Type - Short Text|short text]] fields can be used as the title field. This is used in four places in the system: 1) the contents of this field is the name by which the WorkXpress platform refers to [[Record|records]] in this table; 2) [[Field Type - Selection|selection]] fields that select records in a table always display the text stored in the title field; 3) it's the default text in the automatically-created view link for the table; 4) when creating lists that don't have view links, the title field gets selected to be displayed in the list by default.
table.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020