The primary purpose of Table Views is to provide a method for accessing or updating relational data. This data is presented in a dashboard or inside the Excel Add-In. The use of Table Views enables the designer to work in a more flexible environment to design a form or data collection tool.
Table Views are not alternatives to other tools, such as the SQL Table Editor or Grid Viewer, Dashboard Components.
Key Use:
-
Designed to collect records from relational tables, or other sources
-
Present the information in the Spreadsheet format
-
Utilize client-side functionality, found in the Spreadsheet tool, such as calculations and pick-list validation lists
-
Table View Business Rules can be designed to manage the column field records, such as updates, inserts and deletes.
Design Considerations:
-
The current functionality is designed to update records in target tables
-
Controlling elements must be designed into the Table View Business Rule by the creator to ensure data integrity, security and performance
Table View Size Considerations:
-
Table Views depends upon the number of rows and row content
-
Paging is not supported. Therefore, all rows and content must be returned
-
Performance testing and design expectations is to support approximately 8000 KB of data per Table View.
