am trying Appsheet and have created a workflow that will alert me of inspection situations, I have chosen to send a message via email to a use. This message will consist of an email body and an attached PDF document.
However I have created a comment field, this field is formatted as LongText and the output on the pdf document is garbled.
Solved! Go to Solution.
Good afternoon Gents
I recreated the template and it seems top be fine now, I still have no idea what went wrong the first time just grateful that it working now. I attach an image for your convenience.
Thank you for the assistance!
Regards
How is your template set up? Itโs hard to say anything unless we see that setup. Can you post a scrshot from your template?
Hi Levent thank you for your reply.
Attached as requested.
Regards
@Johan_Marais
Is your problem arising from the [Comment] columnโs value?
Hi Levent
That is correct.
I havenโt experienced this kinda error with the LongText fields with my templates. But you can try this workaround and see how it affects.
1.) Create a 1x1 table just under your Comment: header
2.) Cut&paste your placeholder into this table
run the workflow and report us back if it works or not.
I will also chime in @Phil as well.
Are you using custom fonts? See this article https://help.appsheet.com/en/articles/2697053-troubleshooting-custom-fonts
If so, eliminate them.
Good morning Gents
I have created a single cell table as you suggested Levent, the displayed output remains the same.
I have gone through the logs as you suggested Phil, being on a free plan the options are limited, fortunately there were results for a workflow and nowhere could I find reference to custom fonts.
I include the output for your convenience:
Audit Log Details
Properties:
{
โAppTemplateVersionโ: โ1.000086โ,
โRuleNameโ: โInspection Failedโ,
โEventTypeโ: โChangeโ,
โInvokedByโ: โAddโ,
โServerNameโ: โprodu3c1a0002EBโ,
โServerRegionโ: โWEST-EUโ,
โIgnoreSecurityFiltersโ: false,
โTableNameโ: โInspectionsโ,
โRuleTableNameโ: โInspectionsโ,
โOperationUpdateModeโ: โADDS_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=[Status]=โInspection Failedโโ,
โMatchesConditionโ: โTrueโ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Typeโ: โEmailโ,
โAction Nameโ: โInspection Failedโ,
โWarningsโ: โWarning: App version 1.000086 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To โJohan Maraisโ CCโed to โโ and BCCโed to โโโ,
โEmailToโ: โMYEMAILโ,
โEmailCCโ: โโ,
โEmailBCCโ: โโ,
โEmailFromDisplayโ: โMYEMAILโ,
โEmailReplyToโ: โnoreply@appsheet.comโ,
โEmailPreHeaderโ: โAdd to application โComplex Detailsโ table โInspectionsโ by โMYEMAILโ at 7/17/2020 8:36:57 AM\r\n[App version 1.000086 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To โJohan Maraisโ CCโed to โโ and BCCโed to โโ]\r\nโ,
โEmailSubaccountโ: โFreeAccountโ,
โEmailSubjectโ: โLatest inspection feedbackโ,
โEmailTitleโ: โAlert: Add to application โComplex Detailsโ table โInspectionsโโ,
โEmailAttachmentโ: โName: โChangeReport.pdfโ Archive: AttachAndDoNotArchive FileName: โโ MIME Type: โapplication/pdfโ PageOrientation: โPortraitโ PageSize: A4 AttachmentByteLength: 0 AttachmentTemplateHasCustomFonts: False AttachmentTextLength: 7796 PDFCount: 1โ,
โEmailOtherAttachmentsโ: โโ,
โAppTemplateNameโ: โ58788217-5f36-4180-9923-87f91f2edd6cโ,
โOperationโ: โWorkflow actionโ,
โResultโ: โSuccessโ
Thank you for the assistance.
Herewith the report where comment is displayed in a single cell table
and then when I changed to a html output.
Thus the report is working, just not in a pdf format and that is the format that I need.
I thought I might just as well try a different app and created something similar on a small scale.
Herewith the result:
This is as expected, I will recreate the template that is the problem and post the output.
Good afternoon Gents
I recreated the template and it seems top be fine now, I still have no idea what went wrong the first time just grateful that it working now. I attach an image for your convenience.
Thank you for the assistance!
Regards
Youโre welcome, glad to hear that you have solved the issue.
User | Count |
---|---|
39 | |
28 | |
24 | |
23 | |
13 |