Testing Reports

tvinci
Participant V

Hello AppSheet,

How do I test whether this will work and see what it will return on the first day of the month?

Thanks

0 16 1,301
16 REPLIES 16

Jonathon
Participant V

In my case, I have a โ€˜Runโ€™ button:
2X_7_751ff10ae03d0b7e79a1b152d52fbb92c9c6c686.png

Do you not see this?

I do not.

Has your application been deployed or is it still prototype?

I believe you canโ€™t run reports or workflows from prototype applications.

This must be the problem.

What is a document template for reports?

Thank you.

The document template in appsheet is typically a Google Doc file that contains the formatting and code that defines how the report or workflow appear.

You can read more here:

Thank you. I fixed the template issue and the run button showed up so I clicked it multiple times. Then I looked in my Google Docs folder and I didnโ€™t see any reports. Where are the reports saved?

There should be a parameter you can specify under the workflow/report rule to specify where the documents are saved:

If no files are appearing, then there may still be an error in your workflow template. You can click on the โ€˜Logโ€™ button to see if errors are being reported.

How do I specify my Google Drive?

If you are logging into AppSheet with Google, and using Google Sheets as a backend, then your application will already be using Google Drive as its filestore.

The default path to your saved workflow files will be something like:
appsheet/data/YourAppName/...

If you leave the file folder path blank, then I believe the files will default into a folder as follows:
appsheet/data/YourAppName/YourTableName

Have you checked the log to see if the report rule ran correctly?

It seems it ran correctly but I donโ€™t see an AppSheet folder in my Google Drive.

I found the folder in my Google Drive and configured the File Folder Path to save documents in there but when I click run I still donโ€™t see anything

Now Iโ€™m getting this error message

Audit Log Details
Properties:
{
โ€œAppTemplateVersionโ€: โ€œ1.000083โ€,
โ€œRuleNameโ€: โ€œMonthly for โ€˜AGID and ELISAโ€™โ€,
โ€œEventTypeโ€: โ€œScheduledโ€,
โ€œInvokedByโ€: โ€œEditorRunButtonโ€,
โ€œServerNameโ€: โ€œprodu21ea00000Eโ€,
โ€œServerRegionโ€: โ€œEAST-USโ€,
โ€œIgnoreSecurityFiltersโ€: false,
โ€œEventMatchโ€: โ€œWorkflow event successfully matchedโ€,
โ€œConditionโ€: โ€œโ€,
โ€œMatchesConditionโ€: โ€œTrueโ€,
โ€œActionNotPerformedโ€: โ€œ14 errors present.โ€,
โ€œActionResultsโ€: โ€œCreated 1 ActionResultsโ€,
โ€œAction Typeโ€: โ€œMakeDocโ€,
โ€œAction Nameโ€: โ€œAction 1โ€,
โ€œErrorsโ€: โ€œError: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Key]โ€™ is invalid due to: Unable to find column โ€˜Keyโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Test]โ€™ is invalid due to: Unable to find column โ€˜Testโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Well Position AGID]โ€™ is invalid due to: Unable to find column โ€˜Well Position AGIDโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Well Position ELISA]โ€™ is invalid due to: Unable to find column โ€˜Well Position ELISAโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Sample Received Date]โ€™ is invalid due to: Unable to find column โ€˜Sample Received Dateโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Schuylab ID]โ€™ is invalid due to: Unable to find column โ€˜Schuylab IDโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[ID Number]โ€™ is invalid due to: Unable to find column โ€˜ID Numberโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Name]โ€™ is invalid due to: Unable to find column โ€˜Nameโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Setup Date/Time]โ€™ is invalid due to: Unable to find column โ€˜Setup Date/Timeโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Finish Date/Time]โ€™ is invalid due to: Unable to find column โ€˜Finish Date/Timeโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Result]โ€™ is invalid due to: Unable to find column โ€˜Resultโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Technician]โ€™ is invalid due to: Unable to find column โ€˜Technicianโ€™. Error: Report โ€˜Monthly for โ€˜AGID and ELISAโ€™โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Timestamp of Last Change]โ€™ is invalid due to: Unable to find column โ€˜Timestamp of Last Changeโ€™. Error: The document body is emptyโ€,
โ€œDocNameโ€: โ€œFiles/AppSheetDoc20200513_205754_157.csvโ€,
โ€œFileNameโ€: โ€œ/appsheet/data/EIA01-1334647/Files/AppSheetDoc20200513_205754_157.csvโ€,
โ€œMimeTypeโ€: โ€œtext/csvโ€,
โ€œPayloadTextโ€: โ€œโ€,
โ€œPageOrientationโ€: โ€œPortraitโ€,
โ€œPageSizeโ€: โ€œA4โ€,
โ€œPageHeightโ€: โ€œ0โ€,
โ€œPageWidthโ€: โ€œ0โ€,
โ€œAppTemplateNameโ€: โ€œ43b7e94a-34a6-45b6-93ba-bae728c46121โ€,
โ€œOperationโ€: โ€œWorkflow actionโ€,
โ€œResultโ€: โ€œFailureโ€
}

There is an error with the expressions in your workflow template; unfortunately I would need more information to troubleshoot what the error could be. I would need screenshots of your workflow template, report rule, and table structure/columns to be certain.


When Iโ€™m designing workflow / report templates, generally I start with a blank template void of expressions and make sure the rule is firing properly under the criteria I want, being distributed correctly to the groups or individuals I want, and/or being saved to the correct folder locations that I want.

Only once I have verified that the above is working correctly do I start to build the template expressions. Building reports/workflows programmatically like this will help you to identify the point in which errors are occuring.

I think you need to SAVE the app for you to see the run test button.

Jonathon
Participant V

For testing purposes I would suggest changing the workflow from a save file action to an email action, and have it email the file to you.

This way you can establish that the file is being generated correctly without worrying about the Google drive folder structure

Top Labels in this Space