Help Centre

Choose a category to find the help you need

Adding tables and fields

When working through the steps below, you might like to flip between management view and data list view. To do this, use the two selector buttons in the toolbar that look like this:

view_buttons

So to start: in a database, information is stored in tables. To be able to store data, create a table and add some fields as follows:

  1. Create the new table
    1. Click on the ‘Build’ section in pane 1 (the left of the screen) to open it up
    2. Click the ‘create a new table’ link and wait a second for the table to be made
    3. To call the table something of your choice, click the Manage tab at the bottom right of the screen and type in a new name, e.g. ‘stock prices’. The name will update as you type
  2. Next, set up some fields (see screenshots below)
    1. Click the Fields tab just to the left of the Manage tab.
    2. Type in a name for the first field, e.g. ‘company’ and choose a type from those given, e.g. ‘Text’. A description is optional. There are some field options listed which you can choose but don’t worry about those for now. Click the Create Field button and your field will be added
    3. Add another couple of fields, e.g. Stock code and stock price, which would be a number
  3. When happy with the list of fields, you can start adding data
    1. Click the Edit tab at the bottom of the screen, then click the plus button at the top left of the screen to add a new record.
    2. Type away in the edit tab and data will be saved as you go. You should see it being saved in pane 2. Click the New button again to add more records

That’s it, you’ve started using a simple table. You could now set up other users and give them access to it using the Administration section in pane 1, or look at creating more complex structures.

Save

Save

Graphical view of adding a field

a - go to admin

b - edit table

c - fields tab

 

Before an end user accesses the data, it’s recommended that an ‘application’ look and feel is set up using modules and reports – these will let users interact with the system using the user friendly tiles interface.

Save

Save

Advanced Options

You can set advanced options on fields using the ‘edit options’ link next to each one. For example, for a text field you can set it to enforce a particular text case, change the size of the data entry box, turn it it I to a dropdown, use tags or set it to be used as the record title.

Sparkline


Not found what you’re looking for?

Please email us at support@agilechilli.com