Saving PDF and Viewing Them

DayToDataInc

In summary:

I create a PDF via bot
Save the full path to the sheet
Go to the invoice's details & click the link to view the PDF
or
Go to the invoice's details & click on the action..
File can't be found?

I'm probably missing something simplistic here.

So I have a bot that saves my invoice as a PDF, which works flawlessly

Here is the invoice saved to my drive in the correct directory.

PDF is correct

I am saving the full path to a column (non virtual) in the same bot after the PDF is created. Here you can see invoice 1274

Here is the data, showing that it's saved.

When I go to the view, the link is active

I even created an action to open the PDF externally

but when I click on it in the detail or click the action button, I get the following error.

        <html>
        <body style="margin:20px">
          <div>&#39;CRM-5099355/Invoices/Invoice_1274.pdf&#39; not found</div>
          <div>Probable cause: N/A</div>
          <div><ul><div>
   <div>Path: Root</div>
   <div>Result: FAILURE</div>
   <div>Message: N/A</div>
   <details>
<ul>
<li><div>
      <div>Path: Root</div>
      <div>Result: FAILURE</div>
      <div>Message: N/A</div>
      <details>
<ul>
<li><div>
         <div>Path: Root</div>
         <div>Result: Success</div>
</div>
</li>
<li><div>
         <div>Path: Root</div>
         <div>Result: FAILURE</div>
         <div>Message: N/A</div>
         <details>
<ul>
<li><div>
            <div>Path: Root</div>
            <div>Result: FAILURE</div>
            <div>Message: N/A</div>
            <details>
<ul>
<li><div>
               <div>Path: Root</div>
               <div>Result: FAILURE</div>
               <div>Message: N/A</div>
               <details>
<ul>
<li><div>
                  <div>Path: Root</div>
                  <div>Result: FAILURE</div>
                  <div>Message: N/A, Searching for &#39;CRM-5099355&#39;, File entry not found</div>
                  <details>

Suvrutt_Gurjar

While saving the file name in the backend, please try starting with just

"Invoices/......" rather than ""Appsheet/data/appname/Invoices...."

DayToDataInc

Didn't work.

The data save as:

Suvrutt_Gurjar

One thing you may want to share is why it was necessary to create the action "View Invoices" .

Typically if the [Invoice File Path] is a file type column, you would have a system generated action to view that file.

In the example below, the column [Report_File] is of "File" type and stores the file path as the screenshot below shows.

The column in table is as follows

Once a column is designated as file type, AppSheet automatically creates an associated system generated action as shown below to view that file in detail and summary views

Please try making the [Invoice File Path] column as "File" type and test if not already done so.

Mahadevlube

try "/Invoices/"

DayToDataInc

Didn't work...

DayToDataInc

This is what I was following originally: https://youtu.be/kgp-mnsUQPQ?si=0d5Pb97BWNy_7N38&t=611