Because The Appsheet Formulas are very new and there is no standard rule for all functions. So Appsheeters often use another extension from a third party like the AppSheet Toolbox to support them in typing formulas quicker and correctly. With the AppSheet Toolbox extension users can manage table names, view names, suggested formulas, table names, or view names to insert in the formula easier.
Unfortunately, recently there is un-convenient with this extension that the Appsheet toolbox is often cracked or disabled when Chrome or Browser updates to new versions. So, users have a lot of trouble typing formulas because there are no suggestions from the software.
As you are currently utilizing the Appsheet Toolbox and lack the authorization to preview Appsheet’s latest features, you may not be aware that Google has incorporated a formula suggestion functionality into Appsheet. Therefore, kindly wait until your account is updated to access this feature.
Hi @hien_nguyen ! Your concerns are very valid, and I am happy to let you know that we are actively working on improving the Expression Assistant.
Expressions are a difficult yet crucial aspect of AppSheet and we are looking to provide a solution that helps both new and existing users.
Some of these features have been released experimentally to a subset of new users, but none are officially released to all users quite yet. We hope to do so in the coming weeks/months.
In the meantime, if anyone is interested in trying these features pre-release, you are welcome to message me your AppSheet ID and I can give your account access. We would love your feedback on the new experience! (However, please be aware that due to the nature of this being pre-release, there may be more changes / less stability in this area than you are accustomed to and we cannot guarantee that all functionality will be supported long term.)
I just want to add 2 cents to this.
If you are not willing to make the effort of creating a tool that has at least all of the features the extension from QREW has, don’t bother, seriously.
At least try not to be rude by breaking things that their extension depends on just because you think you are working on the “official” thing.
If you really want to make things useful, hear your customer’s voice while current behaviour is left unchanged, and just deliver/deploy your changes when everything is absolutely tested to be a better tool than was already available before it’s inception… you know, the opposite of most things lately
I see new formula expressions appear on some of my apps. But it seems that it is not really convenient for the user as the AppSheet toolbox. The new formula box just suggests expressions like excel and google sheets, It is not suggested all formulas, table names, view names, and define spacing row lines number as AppSheet toolbox.
I hope AppSheet will soon update to complete the formula typing support feature for the earliest users.
