July 21, 2022

[lizlynch]

Item	Description
Enhancement	Use return values of a Google Apps Script in an automation Use the return value of a Google Apps Script function within your AppSheet automation Apps Script task and pass it to a later step in the same automation process. For more information, see: - Community post - Use return values from Apps Script tasks. This enhancement will be rolled out gradually. Deployed to 50% of free users.
Enhancement	Add ‘No Items Selected’ text to localize options You can now localize the string “No Items Selected”. The “No Items Selected” text will be displayed when a detail view is shown but there is no row associated with the detail view. This can occur when using an interactive dashboard that has a detail view but no item has been selected yet. See Localize: The Essentials.

Bug fixes

None

Rollout changes

Item	Description
Enhancement	Unlinked automation components Previously, when you created an automation component, it was reusable in multiple bots. You can now enable or disable the reusability of a component by enabling or disabling the Linking toggle. For complete details, see: - Community announcement - Reuse automation components New: Deployed to all users. Previous: Deployed to 100% of free users and 75% paid users.

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	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	Detail views Rich text formatting is now available in Detail views. For details, see this announcement in the community.

[okutani_hayato]

“Use return values of a Google Apps Script in an automation”

Fun feature!
I’ll give it a try.
Thanks!

[Fabian_Weller]

@lizlynch

“No Items Selected” text will be displayed when a detail view is shown but there is no row associated with the detail view. This can occur when using an interactive dashboard that has a detail view but no item has been selected yet.

Can you please give us an example? In the case you mentioned, when no row is selected, it would show the detail view of the first row. That’s why we usually do the workaround to add a dummy row to our table in rownumber 2 with text like “Please select an item”.

[PatW]

Hey @Fabian_Weller !

You are correct but that only applies to noninteractive dashboards, in the case of interactive dashboards we previously show an empty pane which is now being replaced with a customizable text.

At the moment it’s still being slowly rolled out so you may not see it until later this week.

[Fabian_Weller]

@PatW Now I see thank you. This is for interactive dashboard views that have a List View (Deck, Table, Gallery, Card) and a Detail view of the same table.

I was talking about interactive dashboard views that have a List View and a Detail view of the Children. Like a List View of Orders and a Detail View of all the Items in that Order.
In this case, if no order is selected, the detail view will show the first row of the Items Table.
If you select an Order, the Detail View will show the first Item in [Related Items].
If you deselect the Order, the Detail View will again show the first row of the Items Table.

I think you should enable the “No Items Selected” also in this case. Because right now we need the workaround as I described above.

There is still an open ticket from 13th September 2021 “The Dashboard is like: Parent | Children | Grandchildren.” Maybe you can help me with this?