September 2023 Product Update

The September release is here and it comes with a number of crowd-pleasing, community-driven changes that will improve the app building and access experience:
Retain user & table data when overriding applications
We’ve been asked time and time again for the ability to update an application without impacting the user or data tables. From today, you can import applications, while retaining these artifacts.
User columns now available (and updates to the user table)
The user table as you know today will still exist, but in a read-only format. If you have user assignment needs, please use the new user column.
Support for date-only field types
Previously we only supported DATETIME type fields, requiring users to set a default time for their value. Now we support DATE type values as well.
View and interact with your applications directly in the Â鶹AV portal
We have redesigned our portal experience, allowing you to use your applications directly within the portal view.
Query UI improvements
We have made improvements to the query creation process for data sources allowing you to view your query results side-by-side with your query string and transformer.
New content
Video
Tutorials
Blog
- 10 strategies for simplified data management
- Microsoft Access alternatives
- How to build complex approvals with Â鶹AV
- Admin UI design tips
Bug fixes
- Linked rows, longform text areas, and multi-select arrays do not save when set within an automation #7528
- Delete automations once apps are deleted #7366 It looks like you can add a new user via the table block, but it fails silently #7258
- Google Sheet rowIndex error - off by 1 (or 2?) #7249
- Schema changes in REST queries are overwritten on refetch #7084
- Initial form step binding drawer can crash #7481
- Postgres / SQL: Invalid time value error when saving JSON as text #7476
- Save Row action will attempt to save the image data of the S3 Upload component #7468
- Customers cannot access app backups #7467
- More than filter not working for static number type formula, when changed from a dynamic formula #7449
- Finish and test automation for cron trigger ignores test timestamp when filtering #7447
- Relationship picker incorrectly renders selections, and not all records show in the dropdown #7375
- Data table does not display when table name is matched in a different schema - MS SQL #7269
- Deleting account that hasn’t been verified, or failed provisioning, produces 500 #6973
- The Number 0 cannot be displayed on input number fields, when being pulled in from a data provider. #6922
- Dynamic Filtering on 0 for external sources e.g. mysql, postgres #6781