Creating a New Page
Before you create a new page, be sure to follow the planning guide Do I Need A New Page?.
To create a new page, you must create fields in your database. You may also need to add foreign keys to existing tables. If you and your team are unsure of how to proceed, please contact your IT SPoC or assistance.
Table Requirements
The following are requirements for tables you add to the Platform that you want to support security roles. If you omit the Domain_ID field, the page pointed to the table acts as a Setup Admin page and is not affected by security roles.
- Primary Key of type int with IDENTITY specification (positive integers only)
- Domain_ID field related to dp_Domains
Once you create a new page, you can reload the system metadata using the About box.
Troubleshooting
Where is my new page?
- Did you assign at least Edit rights to one of your security roles for the new page?
- Is it a system table or page that's only available in the setup area?
- Did you place it within a page section?
- Did you try refreshing your instance by pressing Ctrl + F5?
- Did you try logging out and back in to MinistryPlatform?
- Can you find it using the search bar in the navigation menu?
My page isn't showing any column headers.
- Did you clear your browser's cache?
- Did you try simplifying your default field list in the setup area so it contains only one field that is directly on your new page or table?
I get an error when I try to clear my cache.
- Make sure you have properly designated whether this page is a system table or not.
- If it is not a system table, it must have a Domain_ID field.
- Make sure you have a value in the selected record expression. Initially, this value should be a field directly on your table (not an "_Table" Foreign Key). After your page works, you can change the selected record expression to a value on a foreign key table if needed.
I can't add records to my new page.
Make sure you made the Primary Key of the table an integer value and that Identity Insert is set to Yes with identity seed and identity increment of 1. Make sure you have a non-nullable Domain_ID Int on your table. It does not need to be related to dp_Domains.
I can't see the column on the page grid from my new page.
Try clearing your cache. MinistryPlatform may not yet know one of your new foreign keys. Or, simplify your default field list to where it's just one column from one field on the table itself (not a foreign key table).
I don't see my page or page section in the security roles area.
Your custom tables probably do not have a domain_id (int) required field that is Foreign Key to dp_domains.domain_id. This value puts the table in the security scope. Without it, the table is a system table visible only to setup admins.