This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

June 28, 2021

Posted on 06-29-2021 06:53 AM
and filed in appsheet-releasenotes
willwitman
Staff

Deployment Time: 11:45 AM PST

Features & Enhancements

Item Description
Feature A new button that lets you copy individual tables was added to the Editor. Deployed to 100% free users.
Feature A new welcome modal was added to render app preview or app template suggestions when creating a new app. Deployed to 100% of free users.
Enhancement Enhance CSV Import and Export to allow the CSV file's locale to be specified.

Previously, CSV Import required that the input CSV file be in US English format. For example, date values were required to be in MM/DD/YYYY format. Decimal values were required to use period as the decimal separator. Input data values were always delimited by commas.

Also previously, CSV Export always wrote the CSV file in US English format. For example, date values were written in MM/DD/YYYY format. Decimal values were written using period as the decimal separator. Output data values were always delimited by commas.

You can now specify the locale for both CSV Import and Export. For example, if you specify locale "English (United Kingdom)" imported and exported dates are in DD/MM/YYYY format and data values are delimited by commas. If you specify locale "German (Germany)" imported and exported dates are in DD.MM.YYYY format and data values are delimited by semicolons.

The application author specifies the locale on the Behavior > Action page of the "import a CSV file for this view" or "export this view to a CSV file" actions. You can either select the locale from the CSV file locale dropdown or you can supply an expression that yields the locale identifier such as en-GB or de-DE. The locale dropdown allows you to select any of the supported locales listed here https://help.appsheet.com/en/articles/4671936-supported-locales.

The locale expression allows you to compute the locale identified. For example, you might store the locale identifier for each user in a field in that user's UserSettings. Alternatively, you might store the locale identifier in a normal table and retrieve it using a LOOKUP expression.

Existing "import a CSV file for this view" and "export this view to a CSV file" actions are automatically updated to use locale en-US for backward compatibility. You can override these default locale settings using the Editor.

The CSV field delimiter is taken from the Windows CultureInfo.TextInfo.ListSeparator for the specified locale. For example, for "English (United States)" and "English (United Kingdom)" the delimiter is comma. For "German (Germany)" the delimiter is semicolon.

Import and Export are symmetric. If you Export in a locale you can (and should) Import in that locale.

Deployed to all.

Feature Use Locale en-US (English-United States) when the client device is using an unsupported locale

Application users can set their mobile device locale to unorthodox values such as nb-PL (Norwegian-Poland). The client includes this locale in the 'locale' property of the Sync request. The server attempts to retrieve and use this locale when evaluating expressions such as those for virtual columns.

Previously we reported a fatal error when the locale was unsupported. Now we use the locale en-US instead. We believe that this approach is better because it avoids fatal errors.

Bug Fixes

None.

Rollout changes

None.

Preview announcements

The AppSheet Preview program lets app creators try out new app features that are not yet fully supported. Learn how to participate in the AppSheet preview program for app client features.

  • No new preview features were released today.

What's currently available in the Preview program?

Item Description
Feature Google BigQuery data source

For details, see the official announcement on the AppSheet Community.

Feature Table view

Table View now supports freezing the first column while scrolling horizontally. For details, see Freezing the first Column of a Table View - in Preview Program.

Feature Chart Editor

App Creators can now make use of our new chart editor and the new and improved charts it can create. Learn more.

Feature Filters in AppSheet applications
  • App users can now filter items from a collection of records based on column values. The feature is available both on mobile devices and desktop computers. Learn more.
  • In the Search box, you can now filter by label.
  • Strings in the filtering interface, such as Done, Clear, Contains, and so on, can now be localized under UX > Localize.
  • In filtering, Yes/No attributes now support custom Yes/No display values.
  • App users can now search by columns of type EnumLists.
3 9 343
9 Comments
3 9 344