Struggling with AppSheet? Drop your problem here — I'll help you figure it out

Hey everyone,

I’ve been deep in AppSheet for a while now and I keep seeing the same problems come up across threads. So I figured — instead of watching people go back and forth for days — let me just be a direct resource here.

Here are the common ones I see:

Formulas not working — IFS(), FILTER(), SELECT() logic that looks right but returns blank or throws errors.

Automations not triggering — bots configured correctly but nothing fires, or it fires multiple times.

Slice and security filter issues — wrong rows showing for the wrong users, or everyone seeing everything they shouldn’t.

Offline sync problems — records duplicating or disappearing after users work offline.

Table relationships breaking — REF columns not pulling correctly, related rows not showing in detail views.

Mobile vs desktop display issues — views and actions that work on desktop but break on the app.

Webhooks and workflow emails failing — automations reaching external services inconsistently or not at all.

Whatever your issue is — drop it in the comments. Tell me what you’re trying to build, what you’ve set up, and what’s going wrong. I’ll go through them one by one and give you a real answer.

And if you need more than just a thread reply — I’m also available as a virtual assistant for your AppSheet project. Whether you need someone to debug your app, build out your automations, fix your data structure, or just be on-call when things break, I can step in and handle it directly. Think of it as having an AppSheet person in your corner whenever you need one.

No fluff. Just solutions.

Drop your question below and let’s get it sorted.

I’m losing my mind over what seems like a very simple AppSheet PDF issue.

Current workflow:

  • User creates/edits an order

  • AppSheet automation generates a PDF

  • PDF is successfully saved to Google Drive

  • PDF is successfully emailed as an attachment

  • The stored file path in my File column looks correct:
    Attachments/Order_051826-6287.pdf

BUT…

When clicking the PDF link inside the AppSheet app itself, I get:

“Searching for ‘Order_051826-6287.pdf’ — File entry not found”

Important details:

  • File physically exists in Drive

  • Email attachment opens correctly

  • PDF updates correctly after edits

  • AppSheet bot generation is working

  • Using a File-type column (PDFFile)

  • Action is the standard autogenerated “Open File (PDFFile)” action

  • Path includes “Attachments/filename.pdf”

It almost seems like AppSheet automation can generate/access the file, but the AppSheet UI file resolver cannot.

Has anyone run into this specifically with bot-generated PDFs and File columns?

I’m trying to achieve the most basic workflow imaginable:
Generate PDF → Click PDF inside app → View same PDF.

I should add that in some cases the pdf displays fine from the link inside the app but if I make adjustments to the order, like change qty or add an item, the link either links to the old version or it breaks completely! Meanwhile the correctly updated pdf is in Drive as well as in my email.

Thanks for the kind words and for engaging with the thread.

If you have a specific AppSheet issue you’re dealing with right now whether it’s a formula that’s returning blank, an automation that won’t fire, a security filter showing the wrong rows, or anything else drop the details here and I’ll walk you through it.

What I need from you to give you a real answer:

  • What are you trying to build or achieve?
  • What have you set up so far?
  • What’s going wrong exactly — error message, wrong output, or nothing at all?

The more specific you are, the faster we get to the fix.

And if your situation is bigger than a thread reply — multiple issues, tight timeline, or you just need someone to go hands-on inside your app — feel free to message me directly. I work with AppSheet builders one-on-one and I can jump in and handle it for you. No back-and-forth, just results.

Drop your details below or send me a DM.

Hi,

Thank you for reaching out and offering to help. I really appreciate it.

I’m building a sales ordering app in AppSheet that generates PDF quotes/orders for salespeople and customers. Most of the core functionality is working, including PDF generation and email delivery, but I’ve been struggling with one issue that has consumed a lot of time:

I want the salesperson to be able to immediately open or download the exact PDF that was just generated from within the app itself on their iPhone.

The PDFs are successfully being created in Google Drive and emailed correctly, but the in-app viewing/downloading behavior has been inconsistent. I’ve also run into complications involving Drive permissions, generated file URLs, and differences between my test app and production app.

At this point I’m trying to determine the cleanest and most reliable workflow for:

  • Generating the PDF
  • Saving the file URL back into the order record
  • Allowing the salesperson to open/download the generated PDF directly from the app

I’d definitely appreciate any guidance or insight you may have on best practices for this setup.

Thanks again,
Bob

The main tables involved are:

  • Orders

  • Order_Details

  • Customers

  • Products

Right now I’m struggling with the PDF workflow.

Current setup:

  • Salesperson presses a “Generate PDF” action from the Orders table

  • An automation bot generates the PDF from a template

  • The PDF is successfully saved into Google Drive

  • Emails are sending correctly with the PDF attachment

  • I’m also writing the generated file URL back into the Orders table

The issue is that I want the salesperson to be able to immediately open/download the exact generated PDF directly from the app on their iPhone.

What’s happening instead has been inconsistent:

  • Some links fail

  • Some open the wrong revision/version

  • Some require Drive login access

  • In some cases the PDF exists correctly in Drive but won’t open properly from the app

I’ve also realized I accidentally spent part of my testing inside my production app instead of my QA/test app, which may have added confusion.

The column currently storing the generated PDF link is intended to be used for an “Open PDF” action after generation.

If you have recommendations for the cleanest/reliable AppSheet pattern for generating, storing, and reopening PDFs from mobile devices, I’d greatly appreciate it.

Thanks again,
Bob

@EAP_Industries and others:

As a long-time member of and contributor to this community, having no recollection of @Abolade_Samuel, and noting that their profile is private, I would recommend against granting any direct access until you’ve exercised some due diligence. Be VERY careful giving ANYONE (even me) direct access to your apps or your AppSheet login.

Thanks.

I wrote his this in an email.

Hi,

Thank you for reaching out and offering to help. I really appreciate it.

I’m building a sales ordering app in AppSheet for generating quotes/orders and emailing PDF confirmations to customers and salespeople.

The main tables involved are:

  • Orders

  • Order_Details

  • Customers

  • Products

Right now I’m struggling with the PDF workflow.

Current setup:

  • Salesperson presses a “Generate PDF” action from the Orders table

  • An automation bot generates the PDF from a template

  • The PDF is successfully saved into Google Drive

  • Emails are sending correctly with the PDF attachment

  • I’m also writing the generated file URL back into the Orders table

The issue is that I want the salesperson to be able to immediately open/download the exact generated PDF directly from the app on their iPhone.

What’s happening instead has been inconsistent:

  • Some links fail

  • Some open the wrong revision/version

  • Some require Drive login access

  • In some cases the PDF exists correctly in Drive but won’t open properly from the app

I’ve also realized I accidentally spent part of my testing inside my production app instead of my QA/test app, which may have added confusion.

The column currently storing the generated PDF link is intended to be used for an “Open PDF” action after generation.

If you have recommendations for the cleanest/reliable AppSheet pattern for generating, storing, and reopening PDFs from mobile devices, I’d greatly appreciate it.

Thanks again,
Bob

Just to clarify. When the order is originally created, it sends it perfectly to Drive as well as sends it in an email. I put a link to that pdf file right in the app. It appears after the Generate PDF button is pressed. The trouble is when I edit an order , increasing quantity or adding items. The pdf updates in Drive but the link inside the app either fails or opens the original pdf.

HI @EAP_Industries

Try adding one more step in your bot Putfile as well as.

In your table add one more column to put your pdf file link. name it for example link_pdf. . Do Regenerate Structure to adjust the additional column in your table.

One additional step in the bot name it put file select Run a data action in the Settings section select set row value then in the Set these column(s) section. select the additional column name which is [Link_pdf] enter a formula like this: this is just a naming sample:

“/appsheet/data/SampleFoto-509832202/FILES/”&[CUSTOMER NAME]&“_”&[NO REFF]&“.pdf”.

For this file name "/appsheet/data/SampleFoto-509832202/ see Info >> in the Properties section >> see the Default app folder section.

Look at the action has been formed automatically change to iinline. now you can see your pdf file just by clicking the Link_pdf action. if your error is enough according to the file name in your pdf link.

I hope this method works.

I’m not sure I understand what you replied - but thank you for replying. Here is a snip of the app. You can see the link at the bottom in the app simulator. All I want is for the user to be able to click on that and have it show the pdf file that was just generated in Drive. The Drive link you see in there now doesn’t work and wouldn’t work since the salesperson would need to be logged into the same Google account to view the file. Basically it breaks down to this. HOW can I display a pdf in the app? Without necessarily having to email it out?

Hi @EAP_Industries

If you want to keep it that way, has the folder been changed from restricted to anyone with the link? If not, change it to anyone with the link. Try the following link; it might help you display the All PDF generated by the bot in Gdrive: How to create a preview print PDF file, before send to print?

my God that looks promising. Testing it now with help from my little buddy ChatGPT. THANKS!

THAT WORKED!!! I CAN’T THANK YOU ENOUGH!!! AHHHHHHHH. We now just list all the pdfs in its own page.

Hi @EAP_Industries

I am very happy to hear that, if it has been resolved, don’t forget to close this problem

I have an app that is listed in My Apps but when I try to open it, it says I don’t own it. Any idea why this would happen?

Try choosing between Shared with me and Owned by me.

Hello! As I was testing this new functionality, I created a test app and did a lot of tweaks without really changing any background data. I just added virtual columns and things like that. But I tried copying all those over to the actual site this morning and I think I may have forgotten something because certain buttons aren’t appearing. My question is whether you know if there’s any way to quickly compare two apps to see where they differ? Probably not. I’ve ready tried my best to go page by page but still can’t find it.