One big difference that you'll first notice between Ragic and other spreadsheet applications 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.
Entries that are made to the form pages are shown as rows on the listing page, and the fields that you set for the entries are shown as the column headers, with the values of these entries listed in the correlating row of the entry. Clicking on an entry on the listing page will take you to the form page of this entry, where you can see the full detail.
In the example below, clicking on the sales order entry 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.
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.
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.