It’s half-way built. I find that I lack the appsheet native way of thinking about things, so wanted some feedback.
So my appsheet (supabase backend) talks to a webapp (written in appscript), and i send it the proposal data, which it puts in a template, and makes a pdf. I want my users to see the draft pdf before they send.
The whole thing is a bit disembodied cos of the time lag… so they ask for a preview, it takes 5 seconds odd, then the proposal is made. What is the best way for them to look at it? Can I embed the pdf in appsheet? I read that somewhere, or shall i just offer them a link in the table of proposals that the webapp can return. We’re all Google workspace so a drive link is fairly easy.
I’d quite like some kind of visual result (after clicking “Generate draft” ) from the proposal detail page, after the action → bot completes. Can I get a URL to pop up somewhere obvious?
And just out of interest, how do others design around the limitations of appsheet apps. It seems like using automations etc make the user experience a bit… stop-start. Not very slick.
So you’re sending from AppSheet to an apps script web app… and IT creates the file?
Why not make the file in AppSheet?
This video will show you how to go about the report file creation, how to folderize in your Google Drive, how to set the link in your app, etc.
Depends on what you’re doing really, and how you build things out. If you’ve got a long running process, you can do things to make it smoother (like taking the user to a detail view where you’ve got a load GIF for them to look at while they wait).
Ultimately you’ll have “loading” or “processing” times no matter where you build
AppSheet introduces more latency because of all of the logs and verifications/validations it’s doing
The trade off is usually worth it
There’s a bunch of “tricks” or techniques for building your app in certain ways so that it’s as smooth as possible for your users; which of these you use, how you go about it, all depends on what you’re doing, how you’ve built the app, etc. (AppSheet is a very nuanced platform, so there is generally no one-size-fits-all advice. What works 99.9999% of the time, might not be the best for your situation.) ¯\_(ツ)_/¯
Thankfully you have resources your can reach out to!
