Data table guidelines for Guided Application Creator

When you create an application in Guided Application Creator, you can optionally create a data table for your application. To ensure that you are within the limits of your subscription and that your application performs as expected, consult the data table guidelines before you create a data table.

Note:

Now Platform application subscriptions include custom table entitlements. You can create custom tables for any purpose, up to the entitlement limit in the subscription. To learn more about how your usage administrator allocates the custom tables that you create to subscriptions, see Allocating your custom tables to a subscription entitlement.

To allocate your custom tables to subscriptions and stay within the entitlement limit, follow the steps in Map your custom tables.

Spreadsheet guidelines

One way to create a new data table in Guided Application Creator is to upload an external spreadsheet. Prepare your spreadsheet beforehand so that you can transfer your data seamlessly and build custom applications faster.

Ensure your spreadsheet is:

Formatted with horizontal columns and a header label for each
Saved as an XLSX file type

For example, format your spreadsheet as follows.

A spreadsheet with horizontal columns and a header label for each

In Guided Application Creator, you would designate the second row as the header row so that Client name and Phone number are uploaded as table fields.

Table extension guidelines

One option for creating a data table in Guided Application Creator is to copy an existing data table and then add more fields to the newly created table. Before you extend a data table, review the extension model for the table so that you can track which database tables are created after extension.

Extending a base table incorporates all the fields of the original table and creates system fields for the new table. If they are in the same scope or if they can be configured from other scopes, you can extend tables that are marked as extensible.

For more information on extension models, see Table extension and classes.

Table creation guidelines

You can optionally create a new table in Guided Application Creator, but it's possible to create more custom tables than your subscription permits. To ensure that you remain within the limits of your subscription, review the custom table entitlements for your organization.

Data table guidelines for Guided Application Creator

Note:

To allocate your custom tables to subscriptions and stay within the entitlement limit, follow the steps in Map your custom tables.

Spreadsheet guidelines

Ensure your spreadsheet is:

Formatted with horizontal columns and a header label for each
Saved as an XLSX file type

For example, format your spreadsheet as follows.

In Guided Application Creator, you would designate the second row as the header row so that Client name and Phone number are uploaded as table fields.

Table extension guidelines

For more information on extension models, see Table extension and classes.

Table creation guidelines

How search works:

Topics are ranked in search results by how closely they match your search terms

Data table guidelines for Guided Application Creator

Data table guidelines for Guided Application Creator

Spreadsheet guidelines

Table extension guidelines

Table creation guidelines

On this page

Data table guidelines for Guided Application Creator

Data table guidelines for Guided Application Creator

Spreadsheet guidelines

Table extension guidelines

Table creation guidelines

Log in to personalize your search results and subscribe to topics