Re: New data not included in report?

StuartSP · 11-12-2020 11:40 PM

Hello,

I’m trying to create an app which tracks the progress of a job, specifically the date when an item was installed. I have set up Excel templates and the data imports beautifully, however I am completely failing when it comes to getting the updated data to populate the emailed report. I’ve tried both Report and Workflow options without success and can’t see where I’m going wrong.

The spreadsheet I am using to set up the job contains six columns, five of which have information which is not to be edited, the last one being the installation date which is all that needs updating.

I can test the app on my desktop and can confirm that I can add the installation date (although it appears in US format, tips on how to change that to UK appreciated), save and sync, however when I run a test all I get is the template with none of the ‘new’ data emailed to me. No errors in the formulae are reported apart from me being the only person receiving the email as I am currently testing this platform.

I imagine I’m making a pretty basic and obvious error but can anyone point me in the right direction?

Lynn

Hi @StuartSP
You haven’t given us enough info to be able to help you.

StuartSP

What information do you need?

Steve

Please post screenshots of your workflow and/or report configuration(s), and of template.

Also, if you haven’t already explored these…

Steve

The audit messages aren’t all that useful here.

StuartSP

I’d love to, however I can only embed one image per post, yet again because I’m a new user so that would take about a dozen separate posts to resolve!

StuartSP

Thanks Steve. I ran the audit log and the only error it reports is an app sync issue, code below:

Action Details
Email Details
Properties:
{
“IfModifiedSinceDate”: null,
“getAllTables”: “True”,
“syncsOnConsent”: “True”,
“isPreview”: “True”,
“apiLevel”: “2”,
“tzOffset”: “0”,
“locale”: “en-US”,
“tableTimestamps”: “{}”,
“lastSyncTime”: “”,
“appStartTime”: “”,
“dataStamp”: “11/12/2020 4:02:53 PM”,
“clientId”: “63200a57-a9c7-4045-8e85-38ab9f44e8e3”,
“build”: “b664e0ff86885fcfdfdf-1605082757502-30f7f0c”,
“version”: “1.000044”,
“AppTemplateName”: “fca8ecc2-b57b-4aaf-a7be-faf72915851e”,
“Operation”: “App sync”,
“RecordType”: “Stop”,
“Errors”: “App ‘fca8ecc2-b57b-4aaf-a7be-faf72915851e’ is not runnable — please contact the app creator.”,
“AppTemplateVersion”: “”,
“AppDefinitionChanged”: true,
“Performance”: “{“Version”:1,“Time”:“00:00:00.0009192”,“PerformanceTimingRoot”:{“Mid”:130,“Timer”:{“Time”:“00:00:00.0009192”},“Children”:},“IsEmpty”:false}”,
“Result”: “Failure”
}

However, this may have been when the site was running slow - I would be trying to test and everything would grind to a halt. Not sure if this was from a bad working practice or a site-wide issue?

I would upload a PDF export of the template I am using but as a new user, this is not allowed. It’s in .xlsx format originally. Also, there is a limit on links that I can post, again as anew user, so I will follow this up with demonstrations of successful instances for comparison purposes.

Hope that helps?

StuartSP

For comparison purposes below are successful logs (1 of 2):

Scheduled report rule:

Action Details
Email Details
Properties:
{
“AppTemplateVersion”: “1.000047”,
“RuleName”: “Daily pile log”,
“EventType”: “Scheduled”,
“InvokedBy”: “EditorRunButton”,
“ServerName”: “INSTANCE-EUROPE”,
“ServerRegion”: “europe-west4-gcp-prod”,
“IgnoreSecurityFilters”: false,
“EventMatch”: “Workflow event successfully matched”,
“ForTableNameRows”: “Table or slice ‘Installation tracker slice’ returned 0 rows”,
“AppTemplateName”: “fca8ecc2-b57b-4aaf-a7be-faf72915851e”,
“Operation”: “Scheduled report rule”,
“Performance”: “{“Version”:1,“Time”:“00:00:03.0951034”,“PerformanceTimingRoot”:{“Mid”:123,“Params”:{“ParamList”:[{“Pid”:15,“Value”:“Daily pile log”}]},“Timer”:{“Time”:“00:00:03.0951034”},“Children”:[{“Mid”:341,“Params”:{“ParamList”:[{“Pid”:15,“Value”:“Daily pile log”}]},“Timer”:{“Time”:“00:00:03.0948542”},“Children”:[{“Mid”:360,“Params”:{“ParamList”:[{“Pid”:19,“Value”:“Daily pile log”}]},“Timer”:{“Time”:“00:00:03.0948118”},“Children”:[{“Mid”:283,“Timer”:{“Time”:“00:00:03.0933318”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:03.0811605”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:”(JobRef) Daily pile log"}]},“Timer”:{“Time”:“00:00:03.0811088”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:01.7844609”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:00.2842660”}},{“Mid”:29,“Timer”:{“Time”:“00:00:01.3415849”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.1557298”}}]},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“31”}]},“Timer”:{“Time”:“00:00:01.2963100”},“Children”:[{“Mid”:411,“Timer”:{“Time”:“00:00:00.9681504”},“Children”:[{“Mid”:412,“Timer”:{“Time”:“00:00:00.1993950”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.1992247”}}]},{“Mid”:278,“Timer”:{“Time”:“00:00:00.7678681”},“Children”:[{“Mid”:414,“Timer”:{“Time”:“00:00:00.7676079”},“Children”:[{“Mid”:407,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:00.7675108”},“Children”:}]}]}]}]}]}]}]}]}]}]},“IsEmpty”:false}",
“Result”: “Success”
}

StuartSP

2 of 2:

Workflow action:

Action Details
Email Details
Properties:
{
“AppTemplateVersion”: “1.000045”,
“RuleName”: “Daily pile log”,
“EventType”: “Scheduled”,
“InvokedBy”: “EditorRunButton”,
“ServerName”: “INSTANCE-EUROPE”,
“ServerRegion”: “europe-west4-gcp-prod”,
“IgnoreSecurityFilters”: false,
“EventMatch”: “Workflow event successfully matched”,
“Condition”: “”,
“MatchesCondition”: “True”,
“ActionResults”: “Created 1 ActionResults”,
“Action Type”: “Email”,
“Action Name”: “Daily pile log”,
“Warnings”: “Warning: App version 1.000045 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To ‘stuart@southernpiling.co.uk’ CC’ed to ‘’ and BCC’ed to ‘’”,
“EmailTo”: “stuart@southernpiling.co.uk”,
“EmailCC”: “”,
“EmailBCC”: “”,
“EmailFromDisplay”: “Southern Piling foreman”,
“EmailReplyTo”: “noreply@appsheet.com”,
“EmailPreHeader”: “Daily pile log.\r\n[App version 1.000045 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To ‘stuart@southernpiling.co.uk’ CC’ed to ‘’ and BCC’ed to ‘’]\r\n”,

StuartSP

Part 2 of 2 (part two, because I cannot post more than two links in any one response, ho hum):

“EmailSubaccount”: “FreeAccount”,
“EmailSubject”: “Daily pile log”,
“EmailTitle”: “Scheduled rule ‘Daily pile log’ for application ‘v2’ invoked at 11/12/2020 4:03:24 PM”,
“Email Attachment Name”: “Daily pile log.xlsx”,
“Email Attachment Archive”: “AttachAndDoNotArchive”,
“Email Attachment ByteLength”: 825335,
“Email Attachment FileName”: “”,
“Email Attachment FilePath”: “”,
“Email Attachment MIMEType”: “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,
“Email Attachment PageOrientation”: “Portrait”,
“Email Attachment PageSize”: “A4”,
“Email Attachment PDFCount”: 0,
“Email Attachment TemplateHasCustomFonts”: false,
“Email Attachment TextLength”: 0,
“AppTemplateName”: “fca8ecc2-b57b-4aaf-a7be-faf72915851e”,
“Operation”: “Workflow action”,
“Result”: “Success”,
“EmailTaskResult”: “{“status”:“SENT”,“error-message”:null,“tracking-id”:“CKwme8RzdsYScov1P0QVhQ.0@notifications.google.com”,“external-id”:“1699889987680175”}”
}

StuartSP

Right…By way of screengrabs and Photoshop, behold:

Steve

Sorry for the delay responding–was out sick over the weekend.

I don’t see anything obviously wrong with the configuration, though I do wonder if ForEachRowInTable is the desirable setting for Create report. I may very well be–I don’t l know enough about what you’re trying to accomplish.

I suspect the problem is in the template, or when the email is being generated. A screenshot of the template (not the resulting report) would be helpful.

But, before diving into any of that, I encourage you to review Sending Email Only After Adding a Parent Record and All of Its Children here:

That particular problem is very common, and I wonder if it applies in your case.

StuartSP

Thanks Steve, progress has been made but at the same time, not: I changed the Workflow rule to ADDS_ONLY and the Condition to IF([Install date] = “date value”, “”, “ISNOTBLANK”). Then I tested it and everything was great. So I saved it and now I get an error message of:

The Workflow rule Condition ‘=IF([Install date] = “date value”, “”, “ISNOTBLANK”)’ of rule ‘Daily pile log input’ must return true or false.

It’s obviously a bad formula I’ve written and frustrating that it definitely did work but now doesn’t.

One other thing is that when testing it on the desktop, it automatically synced so I got tons of emails, however I have the Delayed sync slider set to on (blue) so I’m not sure if this is a quirk of testing or a bug?