You can learn more about the Save File workflow action in Creating and Saving a File from a Workflow Rule or Scheduled Report.

The most common support questions for Save File workflow actions are:

  1. Where is the file being saved?
  2. Why isn't my workflow rule working?
  3. Why isn't the 'Test" button working?
  4. Why isn't the PDF file formatted correctly?
  5. Why are the images in the PDF file too large or too small?
  6. How do I control when and how maps are shown in my PDF file?
  7. Why is the error "Request cancelled: took too long to process" occurring?

Where is the file being saved?

The article Save File Archiving how you can control where the saved file is archived. 

Topic "File and Folder Name in Audit History" in this article explains how you can obtain the saved file name from Audit History.

Why isn't my workflow rule working?

Use Audit History to troubleshoot workflow problems. 

Do this as follows:

  1. Open your application in the AppSheet Editor.
  2. Go to the Manage>Monitor tab and click "Audit History". Then click "Get audit history records".
  3. Look for audit records with an "Action" value of "Change workflow rule" or "Scheduled report".
  4. You may need to wait for up to five minutes for the audit record to appear. We group audit records and periodically write the grouped audit records to reduce overhead. This can result in a delay before an audit record appears in the audit history. You may need to wait a short while and then click "Get audit history records" again to see the audit record.
  5. Click the "Details" icon to see the outcome of the workflow rule.
  6. If the workflow rule did not fire, the Details give the reason for this.
  7. If you see "Result": "Success" at the end of the audit record, then AppSheet successfully fired the action in the workflow rule.

Why isn't the "Test" button working?

If clicking the "Test" button on the Behavior > Workflow pane does invoke your workflow rule for testing, make certain that your browser is not blocking pop windows. 

For the Google Chrome browser:

  1. Click the Customize and control Google Chrome button on the top right of the browser's toolbar.
  2. Select Settings from the dropdown.
  3. Expand Advanced settings at the bottom of the page
  4. Under Privacy and security, click the arrow following Content settings.
  5. Click the arrow following Pop-ups and redirects.  
  6. Add https://www.appsheet.com:443

Why isn't the PDF file formatted correctly?

In your workflow rules, you can define parameterized Google Doc document templates that will be instantiated, converted to PDF files, and archived. Occasionally, these PDF files are not formatted identically to the original document template. To troubleshoot such problems, it is important to understand the three steps followed by AppSheet in processing these attachments:

  1. Export Google Doc to HTML
  2. Modify HTML to replace placeholders with values
  3. Convert HTML to PDF

Inconsistencies in format could be introduced at step 1 or step 3 because neither maintains complete fidelity in the document format. Most commonly, the problems are at Step 1 and can be fixed by you. The trouble-shooting steps to follow are:

  1. Try to export the Google Doc straight to PDF and check that it does it correctly. If not, try tweaking the formatting options in the Doc until it exports to PDF the way you want.
  2. If it exports correctly to PDF, then export to HTML and open that in a browser. Check if the format is right, and tweak the formatting options to ensure that it exports with the right format.

 

Why are the images in the PDF file too large or too small?

You can control the size of images shown in the workflow email body or attachments. By default, columns/expressions of type Image are shown larger than columns/expressions of type Thumbnails. You can specify a Format Rule (in the UX>Format Rules section of the app editor) to further control the size of images in your workflow email content. In the format rule, you get to choose the table, one or more columns, an optional condition, and the image size (Tiny, Small, Medium, Large).

How do I control when and how maps are shown in my PDF file?

You can control how geographic column values (Addresses and LatLongs) are shown in the workflow email body or attachments. By default, columns/expressions of type LatLong are shown as static maps with a pin, while columns/expressions of type Address are shown as text. You can specify a Format Rule (in the UX>Format Rules section of the app editor) to further control the size of static maps in your workflow email content. In the format rule, you get to choose the table, one or more columns, an optional condition, and the image size (Tiny, Small, Medium, Large, or Text). Choosing 'Text' results in the textual representation of the value being shown in the attachment. 

Why is the error "Request cancelled: took too long to process" occurring?

AppSheet has a mechanism to prevent runaway applications from consuming too much time and impeding other applications that are running at the same time. 

When we begin an Add, Update, or Delete request, we start a timer that runs for 2 minutes. We expect the request to finish within that 2 minute time limit. This includes the time to perform the Add, Update, of Delete as well as the time to perform any workflow rule triggered by that Add, Update, or Delete. 

We check the time limit when:

  1. Computing Virtual Columns
  2. Applying Security FiltersThis can occur when we are evaluating an expression that requires reading a table and applying a Security Filter to it.
  3. Fetching Values from a TableThis can occur when you have Virtual Columns that contain expressions that refer to other tables. We must read those tables, apply the Security Filters for those tables, and compute the Virtual Column values for those tables.

You may exceed these time limits if:

  1. You have lots of Virtual Columns having AppFormulas that are expensive to evaluate.
  2. You have Virtual Columns having AppFormulas that require reading other tables. When evaluating these AppFormulas, we must read those other tables, apply Security Filters for those tables, and compute the value of the Virtual Columns for those tables.
  3. You have workflow rules that are expensive to perform. Workflow rules having complex Body or Attachment templates can be expensive. They may include Start expressions that require reading other tables, applying Security Filters for those tables, and computing the values of the Virtual Columns for those tables. 
Did this answer your question?