wojeezy08

Open File Script

7 posts in this topic

My end goal is to have a button that, when clicked:

1. Opens a pdf form from my server

2. Fills in the form using data entered into FileMaker (I'm using FileMaker 10)

 

I'm on step one and and trying to use the "Open File" script, however it's not working.  Can the "Open File" script be used to open non-Filemaker files, such as PDFs?

 

 

Share this post


Link to post
Share on other sites

Are you sure you are using FM Starting Points?

1 person likes this

Share this post


Link to post
Share on other sites

Nope, thanks for pointing that out.

 

Any suggestions on the proper sub-forum for this topic?

Share this post


Link to post
Share on other sites
24 minutes ago, wojeezy08 said:

Can the "Open File" script be used to open non-Filemaker files, such as PDFs?

No. Try the Open URL[] script step to open a non-Filemaker file in its native application.

 

26 minutes ago, wojeezy08 said:

Fills in the form using data entered into FileMaker

I don't know of a way to do that natively from Filemaker. Perhaps with a plugin.

1 person likes this

Share this post


Link to post
Share on other sites

I move it to Managing Scripts

I deleted your duplicate post. Please do not double post your questions.

1 person likes this

Share this post


Link to post
Share on other sites

FileMaker's 'Open' command will work with Excel and text files -- converting them to FileMaker files in the process -- but not PDF.

I believe you can fill in PDF forms using Scribe: 360works.com/filemaker-pdf-plugin/

1 person likes this

Share this post


Link to post
Share on other sites

Excellent.  Great suggestion.  I've downloaded scribe; I'll post back here should I run into any issues.

 

THANK YOU THANK YOU THANK YOU

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • By Quito
      Hi,
      I want to create a Dropdown List of numeric options to select a range of records.  For example, the Dropdown list would contain:
      5
      10
      20
      50
      100
      -------
      edit...
      Each option would select the next 5;10;20;50 or 100 records to the right.  A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records.  The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is.
      Any help will be gratefully acknowledged.
      Best,
      Daniel
       
    • By Peter Wagemans
      Yesterday, I tried to move a script that creates a PDF ( and mails it ) to a server side script, as the "save records as PDF" script step is now supported in server side scripts.
      It did not work correctly, and generated an error 800 (file could not be created on disk) in the server log. Rather generic error.
      I changed the script to point to a blank layout instead. No more error. A nice blank PDF was created.
      I put a text box with "test" in it on the layout, Arial 12 point. -> error 800
      I removed the text box and put a png graphic on the layout -> OK
      I put a text box in a font that I was sure of the server did not have -> OK!
      I tried this several times, 2 several fonts, and the results and errors were consistent. So if during the PDF creation, the server replaces the font reference by its own replacement font reference, it is able to save as PDF. If a reference lik "Arial" is used, it fails and the server reports the generic error that it can not create the file on disk (800).
      I'm using MacOS 10.12.4 as client and Window Server 2012R2 as the server. Maybe there is a cross platform issue here? As always, more testing is required.
      Can anyone confirm similar issues? Any workarounds that are known? Any thoughts and insights?
    • By Cable
      I have several reports that use Google Charts displayed through a web viewer to display a "'gas gauge" type of chart. This is a very popular style for our dashboard reports to the point where it is a requirement.
      I originally started using them in FileMaker 14 and they worked great. When FileMaker 15 came out they wouldn't work at first but then did after an update to the code.
      I'm now testing Filemaker 16 and they're back to not working properly.
      They do display on the screen just fine but if you try to print preview, print, or Send to PDF they do not show.
      Does anybody have experience with this or know if a setting changed in FMPA 16 that could be causing them to not print?
    • By jbante
      FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community.
      JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON.
      The module is hosted on GitHub, or you can download it directly.
    • By rt916
      Hey folks,
      I am working on a layout that auto-populates a bunch of data from related fields. One of the fields is called district_number which has the numerical 1-12 value, depending on the district. I am trying to get a script to read the district number, then based on the value have it populate data in another field.
      I started by setting the district_number as a variable, $DistrictNumber
      Then I have the If statement:
      If[$DistrictAddress = "01"]
        Insert Text [Select;xxx::district_address_label; "District 1 P.O. Box 3700 blah blah blah"]
      Else If [$DistrictAddress = "02"]
        Insert Text [Select;xxx::district_address_label; "District 2 P.O. Box 3700 blah blah blah"]
      Else If [$DistrictAddress = "03"]
        Insert Text [Select;xxx::district_address_label; "District 3 P.O. Box 3700 blah blah blah"]
      ... etc...
      End If
      But ti doesn't work. Any help on what I am doing wrong is much appreciated!!
      Thank in advance,
      RT
      here is an image of how it looks