Hello AppSheet,
How do I test whether this will work and see what it will return on the first day of the month?
Thanks
In my case, I have a โRunโ button:
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.
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
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |