How to display a form in the Filemaker database?

  • jonsynergy
    Asked on December 16, 2016 at 7:42 AM
    I am trying to display the form from a field in the database Filemaker database,  but I can't get the form to display. I can display a hyperlink to it, but I can't get the form itself to display properly in the same page. Do you have any suggestions please?
  • Boris
    Replied on December 16, 2016 at 8:04 AM

    I'm afraid I'm not that familiar with Filemaker itself, but I understand that several of our users were able to add their forms into their instance of Filemaker.

    Upon looking through Filemaker's documentation, it looks like you can display your form there by using what they call a "web viewer":

    http://www.filemaker.com/help/12/fmp/en/html/create_layout.9.45.html

    If you experience any issues with the form you are trying to use there, please send us a link to the page where you have embedded/added your form, and we'll gladly check it out for potential conflicts or issues.

    I hope this helps.

  • jonsynergy
    Replied on December 16, 2016 at 8:10 AM

    Hi Boris, many thanks for that. I must admit I can't understand what they mean when describing displaying in a web viewer. Any further guidance would be much appreciated. 

    John

     

  • Boris
    Replied on December 16, 2016 at 8:50 AM

    I'm afraid that, having never used the Filemaker software before, their instructions are a bit vague even from our end for helping you out.

    Can you please send us a link to the page where you have managed to get the form's hyperlink to display, so we can take a look? This would help us get a better visual on what has been achieved so far, and what does the structure of that page look like.

    With our forms in general, you can embed them in most kinds of places and websites by using one of our embed codes, such as preferably our iFrame embed method:

    https://www.jotform.com/help/148-Getting-the-form-iFrame-code

    When it comes to where to paste our embed codes within your Filemaker, or whether you need to use actual embed codes or just a direct link to your form, that is something that Filemaker support would know better.

    It might be better to reach out to Filemaker support technicians, and ask them how to go about in order to add your form from an outside source to where you want to within Filemaker:

    https://www.filemaker.com/support/contact.html

    I hope this helps.

  • jonsynergy
    Replied on December 17, 2016 at 8:17 AM

    Hi again,

    I have tried pasting the code http://www.laboratorymarkets.com/reports.asp and for some reason it doesn't show up even though the webpage is a standard .asp file

    Any help would be much appreciated.

    John

  • Boris
    Replied on December 17, 2016 at 10:42 AM

    I have checked the page you have linked to, john, and it looks like the form was copy/pasted there as ordinary text, and worse still, it was paste at the very start of your page's HTML code:

    How to display a form in the Filemaker database? Image 1 Screenshot 30

    This is causing some errors on your page, as well as the text you've entered shows at the very start of the page:

    How to display a form in the Filemaker database? Image 2 Screenshot 41

    To resolve the issue:

    Step 1. Please remove that text first. It is not a valid HTML code, and it pasted in the wrong place of your page, potentially leading to errors and issues.

    Step 2. Use your form's iFrame embed codes for pasting into your website instead:

    https://www.jotform.com/help/148-Getting-the-form-iFrame-code

    In other words, you should not be placing this into your site:

    https://form.jotformeu.com/63501264153346

    Instead, you should be placing this into the site:

    <iframe id="JotFormIFrame-63501264153346" onDISABLEDload="window.parent.scrollTo(0,0)" allowtransparency="true" src="https://form.jotform.com/63501264153346" frameborder="0" style="width:100%; height:539px; border:none;" scrolling="no"> </iframe> <script type="text/javascript"> window.handleIFrameMessage = function(e) { var args = e.data.split(":"); var iframe = false; if (args.length > 2) { iframe = document.getElementById("JotFormIFrame-" + args[2]); } else { iframe = document.getElementById("JotFormIFrame"); } if (!iframe) return; switch (args[0]) { case "scrollIntoView": iframe.scrollIntoView(); break; case "setHeight": iframe.style.height = args[1] + "px"; break; case "collapseErrorPage": if (iframe.clientHeight > window.innerHeight) { iframe.style.height = window.innerHeight + "px"; } break; case "reloadPage": window.location.reload(); break; } var isJotForm = (e.origin.indexOf("jotform") > -1) ? true : false; if(isJotForm && "contentWindow" in iframe && "postMessage" in iframe.contentWindow) { var urls = {"docurl":encodeURIComponent(document.URL),"referrer":encodeURIComponent(document.referrer)}; iframe.contentWindow.postMessage(JSON.stringify({"type":"urls","value":urls}), "*"); } }; if (window.addEventListener) { window.addEventListener("message", handleIFrameMessage, false); } else if (window.attachEvent) { window.attachEvent("onmessage", handleIFrameMessage); } if(window.location.href && window.location.href.indexOf("?") > -1) { var ifr = false; if (args.length > 2) { ifr = document.getElementById("JotFormIFrame-" + args[2]); } else { ifr = document.getElementById("JotFormIFrame"); } var get = window.location.href.substr(window.location.href.indexOf("?") + 1); if(ifr && get.length > 0) { var src = ifr.src; src = src.indexOf("?") > -1 ? src + "&" + get : src + "?" + get; ifr.src = src; } } </script>

    Step 3. Please be careful where you place these embed codes into your site. They shouldn't be placed in some random place of your page, such as the form's link is currently paste as the very start of your HTML page.

    Websites have certain structure to them, specified as HTML, and your HTML codes should be placed accordingly. Simply edit your page as you normally do, such as when you were entering the text of your article, and paste your embed codes into the place of the article where you want your form to appear.

    Should you experience nay further issues after doing the above, please let us know and we'll gladly take a look at what might be going wrong. Thank you!

  • jonsynergy
    Replied on December 17, 2016 at 4:04 PM

    Thank you Boris! :-)

  • jonsynergy
    Replied on December 18, 2016 at 4:09 AM

    Hi, thanks again for your previous help. One question I have is this ...

    I thought the form exclusively related to PayPal, which is the online payment account that I have.

    However, I notice that credit card options are also offered to the left of PayPal .. are these credit card options separate to PayPal or are the processed through PayPal?

    Thank you.

    John

  • Ashwin JotForm Support
    Replied on December 18, 2016 at 4:24 AM

    Hello John,

    I have moved your second question to a new thread and you will be answered here:  https://www.jotform.com/answers/1014366

    Thank you!