Differences between Detail Table and Spreadsheet

Introduction

Both detail tables and spreadsheets can display and manage data in form. The two charts differ from each other in usage.

Differences in Data Source Selection

Detail tables and spreadsheets are different in selecting data source:

Chart Type	Differences in Data Source
Detail Tables	Forms (including cross-app forms), data stream, or aggregatable tables.
Spreadsheets	Only forms in this app.

Differences in Data Management Permission

Detail tables and spreadsheets are different in configuring permission settings:

Chart Type	Access	Action
Detail Table	Members’ access to view data: Same As Member or All Form Data	Actions to export data and single record need to be set separately.
Spreadsheet	Access to view and manage data: Same As Member (It is default and cannot be updated, so only forms can be selected as data source.)	No settings are required. Actions to export data and edit a record depend on members’ access in the data source form.

1. Access

In a detail table, you can select All Form Data or Same As Member, while in a spreadsheet, you can only select Same As Member.

Access to detail tables is to acquire the permission to view data and the actions need to be set separately. Spreadsheets allow members to acquire all permissions.

2. Action

You can set processing permissions in two ways: on the data detail page and in the form.

Action Type	Detail Table	Spreadsheet
In the data detail page	Set Use member permissions on handling single record.	Same As Member in the data source form by default
In the form	Only support Export.	Same As Member in the data source form by default. Actions such as exporting and adding records are included.

In detail tables, members need to set actions so that they can have data processing permissions, but in spreadsheets, actions are the same as those in the data source form.

In the form, detail tables can only support Export, while spreadsheets support actions same as the form, such as adding and exporting data.