Create a model by designing a Form

Introduction

You create a table model, the add and update form and a default report when you save the form. Therefore you need to have prepared a number of things before before you start creating the model. These are:

• The model or table name - all the major models and their associated forms and reports were created when the system was first installed. You can edit any of the existing forms to add new fields but generally this will not be necessary. You will generally be considering this activity because you are adding something completely new.
• The field names - it makes sense to create another spreadsheet along the lines of that we provide at /docs/Cliqon V9 Data Dictionary. By default, the Redbean ORM database facility automatically creats every field as a variable alphanumeric field (Varchar(255)) and changes and expands this when needed.
• Select and list options - if the form is going to include selectsor radio choices, these should be configured as options. A static list can be entered or a list accessed dynamically.