Skip to main content
Tables and views are the display foundation of AI Table. In a single AI Table file, you can create multiple tables; each table supports multiple views. Tables are independent, but one-way links, two-way links, or lookups let you connect data and compute across tables. A view is one way of displaying data. Every view of table A shows the same underlying data — edit a record in one view, and any other view containing it updates accordingly (depending on filter conditions). A typical AI Table structure:
  • CRM customer management is the entire AI Table file.
  • Customers is one table inside CRM customer management.
  • All customers is one view of the Customers table.
In CRM customer management, you can create multiple tables to hold different kinds of data. In each table, you can create multiple views to surface different slices or use different presentations.

​
FAQ

​
Q: Max tables per AI Table file?

A: 100.

​
Q: Max views per table?

A: 200.

​
Q: Max fields / columns per table?

A: 300. For more limits, see AI Table common limits.