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.
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.
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.
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”.
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…
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)
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.
| 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.
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.
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.
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.
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?
For me it’s more intuitive to set the column order in the view.
I don’t need to create a slice just for the one reason to set the column order. So I have less slices.
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.
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.