What do you like best?
I've now been using appsheet for over a year. I think using Appsheet is a lot like using LEGO's. Legos let you build something simple, like a wall, with very little effort, but you can also build something like the Millenium Falcon out of them too, you just have to have some determination, patience and the willingness to learn (especially from the community). Outside of Google Sheets, Appsheets is my very favorite software...and I'm definitely not a programmer.
What do you dislike?
The most difficult part is understanding the logic behind how the tool works. Ultimately this is learning how to understand the logic behind relational databases (they have lots of tutorials and the user community is very active and helpful) and then leveraging the tools that Appsheet gives you to build them. For me, this took about 50 or 100 hours of puttering around building ever more complicated apps. This can be VERY frustrating because you create errors you don't understand for reasons that are very opaque. All I can say is "Keep Trying". At some point, everything just clicks and it gets easier by about 5x.
The most challenging part from a deployment perspective is getting end users to download and install the app(s) because it's a two step process. First they have to download appsheets and then they have to download the app. It seems simple but it's amazing how many people struggle with something as simple as that.
Recommendations to others considering the product
If you don't understand the theory of how relational databases work, you're learning curve will be a little more frustrating. Once you get the logic behind relationships of different data and how important it is to break down the data into relatively narrowly defined tables (it's ok if this doesn't make sense, it didn't to me either at first) it get's much easier. The tool itself is really easy to use, if at times mildly tedious.
What business problems are you solving with the product? What benefits have you realized?
Property Inspections, Service Tracking, Basic CRM and we're now working on developing a quoting app that will let our salespeople build quotes in the field.