{"id":12113,"date":"2019-06-11T17:57:21","date_gmt":"2019-06-11T17:57:21","guid":{"rendered":"https:\/\/www.directimpactsolutions.com\/?p=12113"},"modified":"2023-05-22T19:41:43","modified_gmt":"2023-05-22T19:41:43","slug":"filemaker-18-and-gmail-send-mail-bug","status":"publish","type":"post","link":"https:\/\/www.directimpactsolutions.com\/en\/filemaker-18-and-gmail-send-mail-bug\/","title":{"rendered":"FileMaker 18 and Gmail Send Mail Bug"},"content":{"rendered":"<p>A new bug with FileMaker 18\u2019s Send Mail script step has come up recently. This bug only occurs when sending email via <a href=\"https:\/\/en.wikipedia.org\/wiki\/Simple_Mail_Transfer_Protocol\" target=\"_blank\" rel=\"noreferrer noopener\">SMTP server<\/a>. It also only happens when using Gmail\u2019s SMTP service. The bug is apparent when users attempting to Send Mail via SMTP encounter this pop-up:<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Gmail-Send-Mail-Bug.png\" alt=\"\" class=\"wp-image-12114\" width=\"682\" height=\"256\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Gmail-Send-Mail-Bug.png 1024w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Gmail-Send-Mail-Bug-300x112.png 300w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Gmail-Send-Mail-Bug-768x287.png 768w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Gmail-Send-Mail-Bug-600x224.png 600w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/figure><p>If the user selects \u201cConnect,\u201d the email will send normally. This may seem like a non-issue; the user has to push one extra button. Problem solved, right? Not exactly. The problem with this pop-up is that it doesn\u2019t appear if the script runs with Error Capture set to On. Instead, the script receives error 1634. If you didn\u2019t build the script with error checking, the user is none the wiser that their email didn\u2019t send.<\/p><p>So what\u2019s the fix?<\/p><h3 class=\"wp-block-heading\">Fix 1 \u2013 Just Say OK<\/h3><p>The easiest thing to do is attempt to send an email with Error Capture set to Off. When you get the pop-up, select the checkbox for \u201cAlways permit connection to this host\u201d. After that you will no longer receive the pop-up, even if Error Capture is on.<\/p><h3 class=\"wp-block-heading\">Fix 2 \u2013 PSOS<\/h3><p>Fix 1 is fine for a knowledgable user in a small system, but isn\u2019t practical if your solution is being used by a large number of FileMaker illiterate users. The easiest workaround is to change the Send Mail script step to be a separate script that is run with Perform Script on Server. For unknown reason, this issue doesn\u2019t occur when FileMaker Server tries it. No idea.<\/p><h3 class=\"wp-block-heading\">Fix 3 \u2013 Insert From URL<\/h3><p>Another option is to use the new feature built into the Insert From URL script step. This step now supports STMP calls and allows you to send emails with HTML and plain text. To get this to work, make sure the verify SSL Certificates option is unchecked. This option takes a little more setup to work properly, but allows for more options in email formatting.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Insert-from-URL.png\" alt=\"\" class=\"wp-image-12118\" width=\"416\" height=\"229\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Insert-from-URL.png 568w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Insert-from-URL-300x165.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/figure><h3 class=\"wp-block-heading\">A Small Reminder<\/h3><p>One last thing to remember when having trouble sending emails through Gmail is to check your security settings. When you log into your account, there is a section called Security. If you scroll down in the Security area you will find an area titled \u201cLess Secure Apps\u201d with the option to turn on or off.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Less-Secure-Apps.png\" alt=\"\" class=\"wp-image-12120\" width=\"636\" height=\"203\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Less-Secure-Apps.png 869w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Less-Secure-Apps-300x96.png 300w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Less-Secure-Apps-768x246.png 768w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Less-Secure-Apps-600x192.png 600w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><\/figure><p>This needs to be on to allow FileMaker to use Gmail\u2019s SMTP server. This was true before FileMaker 18, so this may be old news, but a reminder doesn\u2019t hurt.<\/p><p>FileMaker has been notified of this bug and they don\u2019t yet seem to know the cause. It wouldn\u2019t surprise me if the issue is fixed in the next update. In the meantime, these tricks might help you avoid a headache.<\/p><p>If you wish to have further assistance on this bug, feel free to <a href=\"http:\/\/directimpactsolutions.com\/en\/contact-us\/\">contact us<\/a>!<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\" style=\"margin-top:var(--wp--preset--spacing--70);margin-bottom:var(--wp--preset--spacing--70)\"\/><p class=\"has-small-font-size\"><em>*This article was originally written for AppWorks, which has since joined Direct Impact Solutions. This article is intended for informative purposes only. To the best of our knowledge, this information is accurate as of the date of publication.<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>A new bug with FileMaker 18\u2019s Send Mail script step has come up recently. This bug only occurs when sending email via SMTP server. It also only happens when using Gmail\u2019s SMTP service. The bug is apparent when users attempting to Send Mail via SMTP encounter this pop-up: If the user selects \u201cConnect,\u201d the email &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.directimpactsolutions.com\/en\/filemaker-18-and-gmail-send-mail-bug\/\"> <span class=\"screen-reader-text\">FileMaker 18 and Gmail Send Mail Bug<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":6,"featured_media":12124,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","footnotes":""},"categories":[29],"tags":[254,39,242,221,253,255,256],"class_list":["post-12113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-low-code","tag-email-integration","tag-filemaker","tag-filemaker-cloud","tag-filemaker-server","tag-gmail","tag-gmail-api","tag-smtp-bug"],"uagb_featured_image_src":{"full":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP.jpg",1500,1000,false],"thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-150x150.jpg",150,150,true],"medium":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-768x512.jpg",768,512,true],"large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP.jpg",1500,1000,false],"2048x2048":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP.jpg",1500,1000,false],"woocommerce_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-600x400.jpg",600,400,true],"woocommerce_gallery_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Send-Mail-SMTP-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Direct Impact Solutions","author_link":"https:\/\/www.directimpactsolutions.com\/en\/author\/direct-impact-solutions\/"},"uagb_comment_info":0,"uagb_excerpt":"A new bug with FileMaker 18\u2019s Send Mail script step has come up recently. This bug only occurs when sending email via SMTP server. It also only happens when using Gmail\u2019s SMTP service. The bug is apparent when users attempting to Send Mail via SMTP encounter this pop-up: If the user selects \u201cConnect,\u201d the email&hellip;","_links":{"self":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/comments?post=12113"}],"version-history":[{"count":4,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12113\/revisions"}],"predecessor-version":[{"id":21021,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12113\/revisions\/21021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media\/12124"}],"wp:attachment":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media?parent=12113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/categories?post=12113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/tags?post=12113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}