One big difference that you'll first notice between Ragic and a spreadsheet is the concept of listing pages and form pages. This distinction is extremely important for developing or using Ragic.
A Listing Page is a table that contains the summary of many entries.
A Form Page is the full detail of a single entry as a page.
Usually listing pages only need to contain some of the fields from the form page that can be used to identify a record visually, or some fields that are often used to filter for records. A form page can contain hundreds of fields in larger applications, and you can go to the form page to see the full detail by clicking on a row on the listing page.
The form page is also more often the place to create new records, since it will always contain all the fields of a record.
In the example below, clicking on the sales order record in the listing page takes us to the form page of that particular sales order, where the ordering customer and a detailed breakdown of the ordered products can be seen.
While designing your sheet, you can also toggle between the listing page and the form page in the design mode with the arrow icon on the right.
When you design a Form Page, remember that you should start with lining up the fields' headers vertically as a form. Lining up the fields horizontally means that you would like to create a subtable (like the products that were added to the sales form above), and a form page cannot start with a subtable in Ragic.
Remember that the Listing Page serves as a table, where field headers are lined up horizontally as the header row of the table. A listing page must have all its fields in one big table, and cannot have any other fields lying around that are not connected.
This is all pretty easy when you are designing your own application, because the listing page is automatically generated after saving your form page. Therefore, the normal process of designing your database application starts with creating a form page, which is covered in the next section, and you only have to choose which fields that you would like to have on the listing page.
After creating and saving your form page, you can click the back button in Ragic to go back to your listing page to see the automatically generated listing page derived from the form page that you just created. You can enter the design mode for the listing page, and use the listing page field picker to choose the fields that will be displayed in the listing page, as well as the order of display.
In the form page, when you change the name of one or more fields that are also displayed on the listing page, a pop-up window will prompt you on whether you would like to update the field name(s) on the listing page as well.
Note: If you choose not to update the field name(s) on listing page, the pop-up window will no longer show up when you would like to edit the same field name(s).
One thing that you should notice is that once you changed the design of the listing page, the change is saved, and Ragic will no longer auto generate the listing page from your form page so that it will not overwrite your design. You should add new fields in your form page, and if you would like it to be displayed on the listing page too, you will need to add it manually using the listing page field picker in the listing page design mode.
To have a clearer idea on how listing and form pages will make using your Ragic database easier, you can watch the short video tutorial below.