Working with Databases The Database Manager Our concept of databases (the more advanced user may recognize them as tables) is straight forward. You create databases, define fields, then input data into the databases using forms we create based on the fields you have defined. To access the database manager go to Toolbar > Databases > Database Manager. The Database Manager is a list of the databases you have created. It shows the name, number of records, the class (or group) and edit tools for each. To add a new database, click the blue plus. To edit the fields and other settings for a given database, click the blue triangle. The Database Settings window is used to describe the database and to manage fields and associations to other databases. This window shows settings for the default database "Contact" and lists the fields that make up the database. To add a new field, click the blue plus in the "Define Fields" list. To edit a field, click the blue triangle next to the field you want to edit. Additionally, you can change the order of the fields when displayed in a form, and you can set security on the fields to determine which users can see them. The Database Field Manager is used to manage the properties of the fields in your database. If you're adding a field, you'll have an option not shown here which is the field type. These include text, image, date, number, and many others. Every field type has settings specific to that type. In this example, the text field has "Rows of input." Rows of Input is how many rows the field will have when it is displayed in the form. To view a list of the records in your database, or to create new records, click "View Records" next to the database in the database manager. In this example, we're using the default database named "Contact." To add a new record to the database, click the blue plus. To edit a record in the list, click the blue triangle. As you can see, when adding or editing records in the record manager, we've built a custom form for you to enter data. It uses the fields you created in the database settings window. Using the workflow container, you can embed forms from the database manager into your site to collect data from your users. The possibilities are endless once you understand these tools! Have a look at the Contact page in the Simple One Starting Point to see how it is done.