Using Padsite (A Tutorial)
Once you've completed the setup process, your Setup page should look like this.
From here, you can add new tables and generate reporting and editing pages for those tables.
For example, if you want to add a table for keeping track of your products, click Add A New Table and enter the table name "Products". The table will be created with the table prefix (that you assigned in application.cfm) prepended to the table name.
Click Create Table and the Setup page reloads showing that the new table has been created.
Next, you'll want to create a report page for your Products table. Click on the table you just created and you will see a listing of that table's fields and a representation of the schema for that table.
Currently, the only field that has been created is the ID field which is used as the primary key for that table. Click Add A New Data Field and enter ProductName and select a type of varchar and set a size of 50 characters.
Click Add Column and the window will update to allow you to enter more specific details about the data field.
Here you can assign a subtype for the field, enter a value for the fieldset label (legend) and control other options such as whether the field should be editable, displayed in reports and sortable. Each data type has its own set of subtypes and options - including the option to enter formulas.
Now your products table has been updated with your new ProductName field. Now let's go ahead and create a reporter page and an editor page for our Products table by clicking Add A New Page at the bottom of the "Admin Pages Associated With This Table" section.
This isn't as complicated as it looks at first. Let's start at the top and work our way down.
Page Menu is the Menu that this new page will show up under. Since the navigation supports drop down menus, you can create a drop down menu by simply putting two or more pages under the same Page Menu.
Page Title is the title of the report page. Note that the Page Title and the Page Menu do NOT have to be the same.
File Name is the actual file name for the report page. I generally recommend naming it the plural version of whatever it is to be reporting but since Padsite is not dependent on any naming conventions here, you can name it whatever you want.
Page Subtype currently only supports reporter (I think) but other subtypes are in the works as you can see.
Let's skip summary for now. That's a more advanced feature.
Access Required indicates whether the person requesting this page must be logged in and what level of access they should have.
Record Name is used as a label to refer to individual records.
Editor is the file name of the editor page for this table. I generally recommend naming it the singular version of whatever it is to be editing.
Access is again what level of access is required to access the editor page.
Window Size is the size that the editor window should open up to.
The viewer section is just a read-only version of the editor for detail reporting only - not editing. It is not fully supported just yet.
Now, you click the Update button to save what you've entered so far. The window will refresh and you will see that the Create buttons next to the reporter file name and the editor file name are now active. Click these buttons to create the pages and then you can close this window.
If everything worked, you should now see that the menu has been updated with your new page and if you click on it, you should see a reporter page for your table that is ready to accept new records.
That pretty much covers the basics but feel free to email me if you have any questions.