v1.6.0

teableio/teablev1.6.0Feb 5, 2025by tea-artist

AI Summary

A major update introducing Table Trash, Duplicate Views, Personal and Locked Views, AI integration, and search index optimization.

Key Highlights

  • Table Trash feature allows recovery of deleted records, views, and fields.
  • Duplicate Views support enables quick copying of existing views.
  • Personal views for local modifications and Locked views for protection.
  • AI Integration with support for custom large language model APIs.

New Features

  • Table Trash for recovering deleted items.
  • Duplicate Views functionality.
  • Personal and Locked Views.
  • AI Integration with custom LLM APIs for formula generation.
  • Search Index Optimization for large tables.
  • Email Verification during Registration.
  • Drag-and-Drop Attachment Upload.
  • Forced OAuth2/OIDC Login via environment variable.
  • API Token Permission Quick Selection.

Full Release Notes

## Highlight 🎉
1. **Table Trash**  
   - Introduced a table trash feature, allowing users to recover deleted records, views, and fields. (#1141)
   
 
<img width="485" alt="image" src="https://github.com/user-attachments/assets/9c99b12a-a402-453a-be7f-ba193ff668e5" />

<img width="974" alt="image" src="https://github.com/user-attachments/assets/87ed7a32-bbac-4669-9e74-06857e943046" />


2. **Duplicate Views**  
   - Added support for duplicating views, enabling users to quickly create copies of existing views. (#1147)

3. **Personal and Locked Views**  
   - Introduced **personal views** for local modifications and **locked views** to prevent collaborators from making direct changes. (#1250, #1256)
<img width="879" alt="image" src="https://github.com/user-attachments/assets/ec4fab68-a90d-46c5-98d6-9c4b505e7e21" />

4. **AI Integration**  
   - Added support for custom large language model APIs, enabling AI-generated formulas. (#1117)

Admin Panel / Settings / AI settings
<img width="855" alt="image" src="https://github.com/user-attachments/assets/efdfd601-a7c8-4242-ab83-49786b5c11d3" />


5. **Search Index Optimization**  
   - Implemented search indexing, significantly improving search speed for large tables. (#1245, #1193, #1205)
<img width="624" alt="image" src="https://github.com/user-attachments/assets/7f352c7f-4431-4f89-b4fb-ea4566379332" />

6. **Email Verification During Registration**  
   - Added email verification support during user registration for enhanced security. (#1252)

Admin Panel / Settings / General settings
<img width="798" alt="image" src="https://github.com/user-attachments/assets/38a46f93-6888-48c6-acce-ed1d9fdedaaa" />

7. **Drag-and-Drop Attachment Upload**  
   - Users can now drag and drop files directly into cells for quick attachment uploads. (#1255)
<img width="659" alt="image" src="https://github.com/user-attachments/assets/ad838444-2905-43bb-a7df-213fd98d5f88" />

8. **Forced OAuth2/OIDC Login**  
   - Introduced a ENV to enforce OAuth2/OIDC login for improved authentication control. (#1131)

`PASSWORD_LOGIN_DISABLED=true`

<img width="917" alt="image" src="https://github.com/user-attachments/assets/f6847d87-4675-433e-8cb8-9f4c4954f6e3" />

9. **API Token Permission Quick Selection**  
   - Streamlined API token permissions with quick selection options for easier configuration. (#1116)
<img width="598" alt="image" src="https://github.com/user-attachments/assets/ae12abfc-41d3-466e-8712-b5a06254944b" />

10. **Custom Physical Field Names During Creation**  
    - Allowed specifying custom physical field names (`dbFieldName`) when creating new fields. (#1244)
<img width="359" alt="image" src="https://github.com/user-attachments/assets/160d0e94-e89a-4b79-ad16-ce3aeb5d98c4" />

11. **Quick Filtering via Field Name Right-Click**  
    - Added support for quick filtering by right-clicking on field names. (#1135)
<img width="357" alt="image" src="https://github.com/user-attachments/assets/051a434b-29f5-4212-bd6f-ede1ff5ceea0" />


12. **System User Display Enhancements**  
    - Improved the display of system users, such as "Anonymous" roles. (#1128)

13. **No mandatory reliance on HTTPS**
Copy-paste functionality is unaffected without HTTPS, except when copying large amounts of data (over 300 rows), which requires an HTTPS environment (#1247)

## What's Changed
* fix: incorrect filter conditions when viewing more events in the calendar by @Sky-FE in https://github.com/teableio/teable/pull/1115
* chore: drop pgcrypto dependency by @tea-artist in https://github.com/teableio/teable/pull/1118
* fix: system user by @boris-w in https://github.com/teableio/teable/pull/1128
* fix: field dependence update crash by @tea-artist in https://github.com/teableio/teable/pull/1129
* feat: forget password & reset password errors by @kpodp0ra in https://github.com/teableio/teable/pull/1130
* fix: kanban view -> "hide empty stack" on select and user field by @kpodp0ra in https://github.com/teableio/teable/pull/1120
* fix: show table's context menu without table|delete permissions by @kpodp0ra in https://github.com/teableio/teable/pull/1132
* docs: update readme by @tea-artist in https://github.com/teableio/teable/pull/1134
* feat: filter date add quick mode by @caoxing9 in https://github.com/teableio/teable/pull/1119
* fix: filter out deleted bases and spaces when fetching token info by @boris-w in https://github.com/teableio/teable/pull/1138
* fix: handle Windows-style line endings (\r\n) correctly by @boris-w in https://github.com/teableio/teable/pull/1140
* add Alibaba Cloud one-click deployment by @hanans426 in https://github.com/teableio/teable/pull/1127
* feat: support shift+tab hotkey by @kpodp0ra in https://github.com/teableio/teable/pull/1143
* feat: table trash by @Sky-FE in https://github.com/teableio/teable/pull/1141
* feat: duplicate view by @kpodp0ra in https://github.com/teableio/teable/pull/1147
* perf: space collaborators page by @Sky-FE in https://github.com/teableio/teable/pull/1151
* fix: calculate field error with event and fieldKeyType by @tea-artist in https://github.com/teableio/teable/pull/1153
* feat: setting to force oauth2/oidc login & refactor by @kpodp0ra in https://github.com/teableio/teable/pull/1131
* fix: the flickering images in group headers when scrolling the grid by @Sky-FE in https://github.com/teableio/teable/pull/1156
* feat: pageUp/pageDown scrolling support by @kpodp0ra in https://github.com/teableio/teable/pull/1144
* fix: horizontal scrolling by @kpodp0ra in https://github.com/teableio/teable/pull/1145
* fix: filter formula value component adaptive by cell value type by @caoxing9 in https://github.com/teableio/teable/pull/1161
* fix: datetime isNot filter by @kpodp0ra in https://github.com/teableio/teable/pull/1158
* translation: add ja, ru, fr locales to calendar by @kpodp0ra in https://github.com/teableio/teable/pull/1164
* feat: add enterprise related definitions by @boris-w in https://github.com/teableio/teable/pull/1167
* perf: filter relative by @caoxing9 in https://github.com/teableio/teable/pull/1169
* chore: update icons by @boris-w in https://github.com/teableio/teable/pull/1171
* feat: add breadcrumb by @boris-w in https://github.com/teableio/teable/pull/1172
* fix: navigate path in base sidebar active status error by @caoxing9 in https://github.com/teableio/teable/pull/1173
* feat: detailed token permission by @tea-artist in https://github.com/teableio/teable/pull/1116
* fix: base all permission need no resourceId by @tea-artist in https://github.com/teableio/teable/pull/1175
* Introducing Teable Guru on Gurubase.io by @Gurubaseio in https://github.com/teableio/teable/pull/1174
* fix: swagger json schema by @tea-artist in https://github.com/teableio/teable/pull/1179
* fix: rendering error in gallery view with filter changes by @Sky-FE in https://github.com/teableio/teable/pull/1180
* chore: insert contact method by @kpodp0ra in https://github.com/teableio/teable/pull/1184
* fix: illegal path by @tea-artist in https://github.com/teableio/teable/pull/1186
* feat: more context menu actions by @kpodp0ra in https://github.com/teableio/teable/pull/1135
* fix: ability to drag field from form to sidebar by @kpodp0ra in https://github.com/teableio/teable/pull/1162
* fix: insert multiple rows losing anchorId by @caoxing9 in https://github.com/teableio/teable/pull/1189
* perf: adapt multiple language insert button display by @caoxing9 in https://github.com/teableio/teable/pull/1190
* fix: pop-up box positioning in prefilling row editor by @Sky-FE in https://github.com/teableio/teable/pull/1192
* perf: improve search index speed by @caoxing9 in https://github.com/teableio/teable/pull/1193
* fix: missing cross-base link fields when update dbTableName by @tea-artist in https://github.com/teableio/teable/pull/1200
* fix: sqlite search index e2e by @caoxing9 in https://github.com/teableio/teable/pull/1202
* perf: improve search target speed by pagination strategy by @caoxing9 in https://github.com/teableio/teable/pull/1205
* fix: filter link search do not work by @caoxing9 in https://github.com/teableio/teable/pull/1209
* feat: ai by @tea-artist in https://github.com/teableio/teable/pull/1117
* feat: new design for design page by @tea-artist in https://github.com/teableio/teable/pull/1210
* fix: crash when check by @tea-artist in https://github.com/teableio/teable/pull/1219
* fix: removal of AI config on settings change by @kpodp0ra in https://github.com/teableio/teable/pull/1221
* perf: do not get search count temporarily by @caoxing9 in https://github.com/teableio/teable/pull/1222
* feat: add page change disable when search by @caoxing9 in https://github.com/teableio/teable/pull/1223
* perf: do not switch index when search loading by @caoxing9 in https://github.com/teableio/teable/pull/1224
* fix: primary key is multiple cellvalue will leads error by @tea-artist in https://github.com/teableio/teable/pull/1226
* docs: contributing update by @tea-artist in https://github.com/teableio/teable/pull/1229
* feat: text filter ignore case by @caoxing9 in https://github.com/teableio/teable/pull/1231
* fix: avatar upload by @boris-w in https://github.com/teableio/teable/pull/1232
* fix: s3 adapter file upload by file path by @boris-w in https://github.com/teableio/teable/pull/1235
* fix: export should limit by permission by @caoxing9 in https://github.com/teableio/teable/pull/1215
* feat: organization permission by @boris-w in https://github.com/teableio/teable/pull/1208
* fix: database execution error message by @Sky-FE in https://github.com/teableio/teable/pull/1236
* fix: record update events were not merged by @Sky-FE in https://github.com/teableio/teable/pull/1238
* feat: link field integrity check by @tea-artist in https://github.com/teableio/teable/pull/1240
* feat: allowed edit db field name when creating by @tea-artist in https://github.com/teableio/teable/pull/1244
* chore: add integrity support for sqlite by @tea-artist in https://github.com/teableio/teable/pull/1243
* fix: copy paste toast by @boris-w in https://github.com/teableio/teable/pull/1247
* feat: personal view by @Sky-FE in https://github.com/teableio/teable/pull/1250
* feat: support email verify, update email and optimise signin and signup page by @boris-w in https://github.com/teableio/teable/pull/1252
* perf: attachment cells support drag and drop uploading by @Sky-FE in https://github.com/teableio/teable/pull/1255
* fix: frozenColumnCount can not update by @Sky-FE in https://github.com/teableio/teable/pull/1257
* fix: the interaction of drag-and-drop upload of attachment cells by @Sky-FE in https://github.com/teableio/teable/pull/1258
* fix: special characters in passwords by @kpodp0ra in https://github.com/teableio/teable/pull/1262
* feat: trgm index for search by @tea-artist in https://github.com/teableio/teable/pull/1245
* fix: prevent title text overflow in login page title by @boris-w in https://github.com/teableio/teable/pull/1264
* fix: shareview should not set search index relative by @caoxing9 in https://github.com/teableio/teable/pull/1266
* fix: import csv do not update rowCount by @caoxing9 in https://github.com/teableio/teable/pull/1267
* feat: enhance auth page responsive design by @boris-w in https://github.com/teableio/teable/pull/1265
* feat: locked view by @Sky-FE in https://github.com/teableio/teable/pull/1256
* fix: crete new field in big table by @caoxing9 in https://github.com/teableio/teable/pull/1277

## New Contributors
* @hanans426 made their first contribution in https://github.com/teableio/teable/pull/1127
* @Gurubaseio made their first contribution in https://github.com/teableio/teable/pull/1174

**Full Changelog**: https://github.com/teableio/teable/compare/v1.5.2...v1.6.0