May 30, 2024

Deployment Time: 1:30 PM PST

Features & enhancements

None

Bug fixes

None

Rollout changes

Item Description
Feature Track changes made to a row in an AppSheet database

The Update Row Timestamp column data type specifies the last time data in a row of an AppSheet database was changed through the AppSheet database editor or the app. The value is displayed using the local timezone and is read-only. For more information, see Track changes made to a row in an AppSheet database.



New: Deployed to 100% of free users and 50% of paid users.
Previous: Deployed to 100% of free users and 25% of paid users.

Enhancement When setting the column order for detail, form, and table views, AppSheet now displays all of the columns in the order set automatically by AppSheet. If you change the column order, you can now click Reset to return to the order automatically set by AppSheet.

Similarly, when setting the order of the actions in the action bar for a deck view, AppSheet now displays all of the actions in the order set automatically by AppSheet. If you change the action order, you can now click Reset to return to the order automatically set by AppSheet.

New: Deployed to all users.
Previous: Deployed to 100% of free users and 50% of paid users.

Preview announcements

Preview feature releases enable you to try out new app features that are not yet fully supported. See Product launch stages.

  • No new preview features were released today.

The following tables summarize the preview features that are currently available.

Item Description
Feature AppSheet apps for desktop users (Preview)

The new desktop design, currently in preview, is optimized for desktop browsers, presenting a more complete view of information with a consistent organization and structure. The new desktop design lets users navigate their apps more easily and access information in context, and provides an efficient way to edit existing records without losing context. The legacy desktop design, enabled by default, provides an experience similar to the mobile and tablet device.



For more information, see:

- Community article
- Optimize the user experience using the new desktop design (Preview)

In addition, the AppSheet preview program lets app creators try out new app features that are not yet fully supported. For more details and to opt-in, see AppSheet preview program.

2 Likes

I posted in other thread, but this new feature cause disruption for existing apps.

If you have app with slice and made view (table view) with “Auto” column order, it used to order the view column in line with slice settings, including SHOW column. But this new feature (it is allegedly the expected behavior, but not work like before) would ignore the slice settings in terms of column order if the view column order setting is selected as 'Automatic".

Definition and behavior of “Automatic” option is obviously changed.

I assume many app creator need to visit their exising apps to change the view setting “manually” to match with what they want and what it used to look like.

For me, this is a bug, but AppSheet teams not. So no option for me to alter their decision, even though this is critical platfom function changes.

3 Likes

Until now (before) we create the slice to make the column order to match with what we want. For instance, VC is appended at the bottom of the source table, so we need to re-order it using Slice, which is fine. Then we create view out of slice where we could see all the column is in order of the slice. But onwards, our productivities are getting worse I expect.

Even after we create slice with own column order, we need to do the exactly same works on each VIEW level, as column order in slice is not respected.

This gets our experience with App Editor worse, for sure.

This is another reason, it is better to roll back to the old one, as old one is provide us better user experiences. So all in all, this is not enhancement at all, as it makes our experience “down-graded”.

Not sure how other creators feel about it though.

3 Likes

I m so sad, the same point was highlighted when initially this new feature was released. And after my comment, the feature was rolled back.

Then it came back to the same states, (errors from app creators point of view). No improvement, and user voice was not reached out to the dev team… Very much sad for me… :sad_but_relieved_face: :sleepy_face:

3 Likes

I never care for AppSheet Database Stuffs (like other thoughtful AppSheet creator do). I make it a rule not to use ASDB for various reasons. (I m with AppSheet Enterprise Plan to use this with max limitations)

See this thread.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/CSV-Import-proving-impossible/m-p/757921#M245261

Obviously another bug.

But no proactive reaction from AppSheet team to admit this is a bug.

whenever we claim there is a bug from users and community members, then the response back from AppSheet/Google is not making sense at all. They just “protect their own interst” rather than listening to the voice from the users.

I stop to say such, as all of my voice sounds “nagative” to the Google, while I expect something more POSTIVE back from Google team…

When we started to use Appsheet before Google aquisition, the discussion and dialogue here was so fun. I really dont want me to post such messages here in this community, but I need to do that to help other community members.

1 Like

This text has been translated from Japanese into English by a translation tool.
Please excuse any reading difficulties.

We would like to additionally report that there is a bug here regarding this change.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Cannot-add-RowNumber-columns-after-changing-to-the-new-column/m-p/755460#M244764

| Enhancement | When setting the column order for detail, form, and table views, AppSheet now displays all of the columns in the order set automatically by AppSheet. If you change the column order, you can now click Reset to return to the order automatically set by AppSheet. |> | - | - |

This may be a personal opinion, but I too do not feel that the above updates have made it easier to use at all.
Rather, the previous UI was more intuitive and easier to understand.

To be honest, there was no need to make it so highly functional just to rearrange the columns, and I don’t feel that it has become convenient at all.
Rather, there are too many functions that I don’t need and it feels complicated.

1 Like

@Anonymous_478d6581f48c37c1d61edec72928d0ca

Thanks for your follow up comment.

Your are right. This is another newly introduced bug I admit. In addition to Row_Number column, key (ID) column is also not available and disappering.

This is like “corona + influenza complications (コロナとインフルエンザの合併症)”

But Google may say “This is what we intended”. If so, hopeless… We need someone in Google team capable to listen to our voice more seriously.

1 Like

Due to new column order features, my cristal ball is saying, “hey AppSheet admin, my app view is presenting view/column order differently as before!!! What is happening!” This is highly likely possible story, and all the appsheet creators (admin etc) will get embarrased due to number of queries.

Then need to ask all the app creators to let them visit the editor to manually re-order the column in trouble one by one.

Further, those who create views with the desired column order, they need to spend hours to re-order number of the column (10 , 20 or more columns) manually as AppSheet new feature (automatic) will RE-ORDER the column as YOU DON’T WANT.

Complete chaos is ahead of us… . :sleepy_face: :sleepy_face: :sleepy_face: :sleepy_face: :sleepy_face: :sleepy_face: :sleepy_face:

As far as I see the latest response back from the team, this story is possibly and highly likely to happen…

We all the app creators need to get ready to get your hands dirty and work hard!!!

I hope my nightmere woud not happen in real world. Just pray to the god.

Koichi_Tsuji_0-1717163575351.jpeg

lizlynch
Staff

4 hours ago

Hi @Koichi_Tsuji,

Thank you for reporting these issues.

We would appreciate it if you would contact AppSheet Support with these issues. I ran them by the AppSheet dev team and it would be helpful if you might share your app with the team so that they can debug what is happening. The Show type column may be expected behavior, but you can explore this more with the team as well.

@Koichi_Tsuji

(英語が苦手なもので、日本語で失礼します…)
辻さん

私は英語が苦手で、毎回このコミュニティーに投稿するのも一苦労ですが、
私もできるだけ頑張って投稿していこうと思います。
辻さんには諦めないで欲しいです。(日本のAppsheetのリーダーなので)

(こんなところでアレですが…)
宮井さんからお聞きになられているかもしれませんが、
そもそも私がAppsheetのポテンシャルを感じられたのは、Appsheet道場さんのYoutubeのおかげでした。
今私が発信しているYoutube(ご存知ないかもしれませんが)でも、パクらせて頂いている箇所がたくさんあります… :sweat_smile:

本当に感謝しているし、リスペクトしているし、応援しています!

1 Like

@Anonymous_478d6581f48c37c1d61edec72928d0ca

コメント有難うございます。 :grinning_face_with_smiling_eyes:

私も帰国子女でも何でもないので、英語は単なる2nd Languageで得意の部類ではないですよ!

私がこのように連続して投稿しているのは、「GlobalのAppSheetの成長に取ってまずい!」と感じた際にアグレッシブに投稿してしまいます。

別に誰(含むGoogleチーム)に期待しているわけではありません。独り言に近いです。誰かに認められたい、とかそんな希望も願も全く有りません。日本の政治家の言葉を借りると「明鏡止水」の心境で日々過ごしています。

AppSheetに関しては古株の人間ですので、明らかな方向性の誤りがあれば、遠吠えのように叫ぶだけです。その場がこの場と思っています。誰がきいていようがいまいが関係はないので、自分の信じるところを吐露しておこう、程度の話で毎度投稿しています。それが、正しい方向に繋がれば、の願いで、だめだったら「どーしょーもないね。」と諦めて宮井さんと飲みに行く程度です。笑

AppSheetのポテンシャルは無限大であるのは変わりません。ボタンを掛け違うと、日本的に申しますと、糸が切れたタコ(凧)になるのは確実なので、ユーザーボイスで運転手(Google)を目覚めさせることしかできないので、やばいとき(今回のようなケース)には声を荒らげるようにしています。

何事も目立った方が勝ちなので。

「あいつ、うるせえなぁ、毎回」と思われるようにするのが戦略です。前職からそのような活動を心掛けています。笑

1 Like

誰がこの会話を翻訳して検査するかわかりませんが(どーでもよー)、私はGoogleが好きなのではなく、AppSheetが好きで日々活動しています!AppSheet話をすれば一生かかっても終わらないでしょう。

なので、AppSheetには今後もそのような存在でいてほしい(じゃないと私どもも家族を養っていけません・・・)ので、歯に衣着せぬコメントを投稿するわけです。

死に物狂いですね、何事も。笑

1 Like

2017年からこのコミュニティーに投稿していますが、初めて連続して日本語打ちました!ありがとうございます!一度、オフ?オン?ラインで呑み会でAppSheet座談会でも企画いたしませう!このスレッドをご覧の日本の皆様も是非! :grinning_face_with_smiling_eyes:

3 Likes

就寝前に最後に。

Viewのカラム並べ替えの新機能。元に戻るのか、このBUGだらけ(機能低下)の状態が続くのか?

楽しみにみておきませう。

すべては「ゲーム」ですね。仮に、Roll Backされたら、勝ち負けの世界ではありませんが、我々の勝ち? そのまま、放置されれば「しゃーないな。Work Around考えて、別のアプローチ考えよっと。」と方針転換。

とは思いますが、明らかな機能低下については、くじけずに物を言う所存。YES/NOと言える日本人でありたいです。笑

1 Like

@Koichi_Tsuji

辻さん

色々とありがとうございます!
あまり辻さんの日本語の文章をお見かけしないので、凄く新鮮(?)でした :blush:

私自身も実は、自他ともに認める「結構言いたい事言う人間」です。
辻さん自身は、そんな事は気になさらないかもしれませんが、
同じ日本人でハッキリと意見を言って下さる方がいるというのは、
私からすれば、やっぱり心強いですよ :hugs:

それでは、今日はこちらで失礼致します。
おやすみなさいzzz

_0-1717169681768.png

1 Like

For someone who manually rearranges columns in every visible view like me, the new function is really useful and it would make my work a lot easier. But for others who use column order based on slice, may be there should be a 3rd option, “Slice”, in addition to the current “Automatic” and “Manual”. So the Appsheet editor could pull the column order from the slice.

3 Likes

@sak

Thank you for your valuable input.
Of course, I respect the views of others.

1 Like

For sure an update should not change the behavior or the UI of existing apps without informing the app creators enough time before.

I stopped using slices to determine the column order. I rather set it in each view. Why?

  1. For me it’s more intuitive to set the column order in the view.
  2. I don’t need to create a slice just for the one reason to set the column order. So I have less slices.
  3. When using slices, and don’t want to see a column in one view type (i.e. form view), you need to use the expression CONTEXT(“ViewType”)<>“Form” in the Show_if part. This is not necessary if you set the column order in the form view.

@MultiTech What do you think?

1 Like
  • I use slices to determine a special column order, whenever I need to make a special form for something - sometimes.
  • I go the route of Context("ViewType") <> "Form" more often then not
  • I also use view controls to reorder certain special forms too

Having the flexibility of specifying the column order in the slice OR the view is very helpful, provides ample avenues of progress forward no matter the situation.

@Fabian_Weller what seems to be the issue?

2 Likes

Thank you @MultiTech
Please read the first comment in this thread from @Koichi_Tsuji about a reason change in the column ordering.

1 Like