May 21, 2024

Deployment Time: 12:00 PM PST

Features & enhancements

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. Fore more information, see Track changes made to a row in an AppSheet database.



This feature will be rolled out gradually. It is currently deployed to 50% of free users.

Bug fixes

None

Rollout changes

None

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

Hi, I have seen that the column order, automatic and manual is back to the editor, that is great. It saved me a bunch of time yesterday.

We always complain and request changes (including myself), but it is also true that the editor has improved a lot and we can walk around it faster.

It seem that Appsheet has put a lot ot effort in the creator’s experience rather than the User’s experience.

I think that Appsheet has set a clear scope, and that is simple-to-make apps, less customizable, but way faster in the other hands. My suggesttion for the front-end is, try to make it looks a bit more modern and up to date. Give us some new features and more power of customization.

HOW ABOUT MAKING A VOTE IN THE COMMUNITY FOR A NEW UPDATE? LET US BE PART OF IT!!!

3 Likes

@lizlynch

Sorry @lizlynch for posting a topic not really related with your daily feature note, but this is the place where we can get the eyes mostly from your team.

In terms of “change type” column, sch as ChangeCount, ChangeTimestamp ChangeLocation, this is kinda of glitch for us, and cause the confusions to the app creators.

Let me quickly explain.

We can set kinda of “Trigger” when and where the change type column would update values, like we set automation trigger by “[_thisrow_before].[Col]<>[_thisrow_after].[Col]” type of expression, however, we simply select “Columns” option avaiable Change type column.

However, once we are attempted to select the column out of dropdown, it shows the all the column including VIRTUAL COLUMN. As is Automation, Virtual Column can not trigger the change, as VC will not hold the before/after value state.

To avoid our confusion, the dropdown for this option should not present VC out of the list.

See the sample screenshot below.

The set of columns inside the red rectangle are all either VC or Change type column, which could not trigger the update for this Change Type column.

Better to review your code to avoid any future / possible confusion and mis-understanding to the global citizen developpers.

Cheers, hope you do understand what I mean.

2 Likes

@lizlynch

Additional quick notes.

Not sure when this option became available to us, but I just tested how it would work. (Values option, see the image)

After testing quickly, I did understand how this option could work , but the problem is this option is NOT documented at all. Better to add to the documentation to clarify how this option would work.

2 Likes

Hi @Koichi_Tsuji

About this: just for information, it’s available at least since 2018 when I started working on AppSheet.

I agree it’s not documented though.

1 Like

@Aurelien

Thank you.

I actually never used this change type column before, but I came up with the usage recenlty so started to look into now.

There would be a few quite useful usages.

Hope Google team would change the documentation so that new comers will get lesson learned from dos.

4 Likes

Hi @Koichi_Tsuji and @Aurelien - The documentation was updated recently to describe the Type details for specific column types. See Type detail properties. You can also see Values used in the Change columns sample app.

Will pass your feedback on to the team regarding the triggering issue raised.

@peterson Thank you for the feedback! Will pass along to the AppSheet dev team. It’s always appreciated.

2 Likes

@lizlynch

Thanks!

but I would say nobody would understand what I mean. Yes, English is my second laungage, but the native speakers could not understand what this means…

After testing the actual functionalities, I noticed how it works, but this docs not telling anything what the actually happens with this testing. Please test on your own, I hope you would be on the same page as mine and agreeable with me, as far as you are reasonable.

1 Like

Thank you @lizlynch

Would you have a list or site with all the how-to templates you may have ?

Also, @lizlynch

I think the documentation here would benefit from having examples with two columns and one single value: how is it supposed to work in this configuration?

@Aurelien

You just simply play around with the app, then you would learn how it would work (good or not).

AppSheet docs is sadly not really comprehensive, as it will likely be.

1 Like

@Koichi_Tsuji

I agree.

This was my point :slightly_smiling_face:

@lizlynch

Sample app not using such option here…

Sample app not using option, so even sample not telling users anything…

This is factual. You dont need to respond to this post.

1 Like

@Koichi_Tsuji - See “Last Change to Red” column properties.

1 Like

@Koichi_Tsuji @Aurelien - Thank you for the feedback on the documentation. Will try and get some more details in the docs.

Here is the list of sample apps: Get started by using the sample apps. Some descriptions are not yet complete… Hope this helps!

1 Like

Probably 1% audience could understand and learn from the sample , to be honest with you.

let me know what you learned from that sample. I wait for your report.

Thank you!

@lizlynch consider that many users use spreadsheets, we need these feature also there, cause in appsheet database we cannot use apps script or formulas, so we are forced to use spreadsheet.

@Espegg What makes you think you cannot use appscript when using an Appsheet Database?

1 Like

Simply that we cannot run a script that do (for example) an update on appsheet database row like instead run this script on spreadsheet…

1 Like