Mastering Data Management: Custom Tables in Dubai's Competitive Business Environment

 Custom Tables Dubai provide a convenient way to store data that does not fit in your standard organizational structure or that you want to use for advanced reporting and analytics. For example, you might create a custom table to hold opportunity-specific elements not already included in the Opportunity detail record such as number of visitors or units sold. You can then use these custom tables in a variety of ways, including reports and roadmaps.

Merged or copied table

To create a custom table, select the data module, table (or multiple tables), or package context menu and click New > Table. Then name the custom table and add fields to it. The custom table inherits the properties of the table that you selected first—for example, the Usage or Data cache property—and all columns in that table automatically become columns in your new custom table. You can also create a custom table by merging or copying tables and fields in the data module. Then the fields from each merged or copied table become columns in your new custom table. When you create a custom table, you can specify whether it should be read-only or not, and you can choose the default value for datetime columns—for example, 0 for bit and numeric types or '' (empty string) for character strings.

 Table context menu and selecting Extend Table

You can also extend a custom table by selecting the table context menu and selecting Extend Table. Then choose the scope where you want to extend the table, such as another data model or a view. You can also choose to make the new table scriptable by selecting the Scriptable Table check box.

 The list of available tables

The new custom table is added to the list of available tables in the data module, and it appears in Plans view and UA Picker. The name that you specify for the new custom table will appear in these views, as well as on its diagram on the Custom Tables tab.

Once you've created a custom table, you can access its information in a variety of ways, including viewing and editing records directly through the custom table. You can also use the Custom Tables tab to manage a custom table—for example, you can rename it or edit the column labels.

The custom table definition page

You can restrict which users have access to a custom table by using the Record Visibility settings on the custom table definition page. The settings on this page determine which records are displayed to the people who have access to the custom table, and they apply to both views. 

Conclusion

The options on this page include: Entire account: Displays all records in the account. Workspace and workspace lines only: Displays only the records that are stored in a particular workspace and inherited by its workspace line(s). You can also use this page to create alternative forms for custom tables, as described in Automatically used alternative forms for Custom Tables in Dubai.