Sign in to follow this  
Followers 0

Sending datas in a pre-formatted Word document

6 posts in this topic

Hello everyone,

I'm developing a little FMP database on Mac to help creating reports with MS Words. These reports will contain :

- non changing elements : logo and address, first level hierarchy titles…

- some specific datas from FMP : number and name of the affair, name and adress of the client…

- the text of the report directly typed in Word by the user.

So my need is :

- when all the fields are completed, user clics on "Create report" then :

- it creates a new folder with number and name of the affair,

- creates the report file by duplicating from the report template, naming it with number & name of the affair &.doc

- inserts datas from FMP (juste one record)

- add the file into a multimedia field to less user clic on it to open it.

All this by script of course for the user only clics on one button.

So what is the best way or what is the right plug-in for it ? I'm not familiar with Applescript nor VBA so I would prefer not have to use them.

Thanks all for your answers or suggestions.

Share this post

Link to post
Share on other sites

The only plugin I know that interacts with Word is 306work's Scribe. The OS ops, creating a folder, etc., can be accomplished with their ScriptMaster product.

Share this post

Link to post
Share on other sites

I'm not familiar with Applescript

Actually, Applescript may be your best option here - other than using a dedicated plugin (plus another plugin for the OS tasks).

What makes Word so attractive as an output format - compared to PDF, for example?

Share this post

Link to post
Share on other sites

Or even RTF?

Share this post

Link to post
Share on other sites

RTF is not easily produced either - unlike PDF.

Share this post

Link to post
Share on other sites

It's definitely worth examining the requirement that the final product is a Word doc. Sometimes, that is a relic of an old workflow, similar to "we must have reports in Excel."

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
Sign in to follow this  
Followers 0

  • Similar Content

    • Scribe Substitute for MS Word Placeholder Text
      By Daniel Shanahan
      First of all, I'm not sure that "placeholder text" is the correct term for the MS Word object.
      I'm working with multiple MS Word documents from the state government.  The content is locked but there seems to be placeholder text that I can tab through.  The placeholder text is highlighted in gray and marked with an asterisk before and after the text (see image).  I'm experiencing a couple of issues:
      1. If I choose the text inside the asterisk, then the substitution works but it leaves the asterisks (see #1 in Scribe_New_doc).
      2. When I choose "Amount", inside the asterisks, a NULL value is returned.  I thought perhaps it would not accept numbers so I created a text field with the same value.  However, this also returns a NULL value (see #2 in Scribe_New_doc).
      3. If I choose all of the text, including the asterisks, then the substitution value is NULL (see #3 in Scribe_New_doc).

    • mail record as PDF with calculated name?
      By Mike Blackburn
      I have found ways to do this from Filemaker in OSX but I can't seem to apply this to FMGo.
      I want to mail the current record as a PDF and to have the PDF name be derived from the value of a field (in this cas, the name of the client)
      Below is the script as it stands. Is this a possibility in FMGo?
      1. Go to Layout [ layout name ]
      2. Set Variable [$name ; Value: Patients::LastName ]
      3. Save Records as PDF [ Restore ; No dialog ; "$name.pdf" ; Crerate email ; Current record ]
      4. Go to Layout [ original layout ]
    • Portal exported to excel spreadsheet only contains one related field once, other fields are empty
      By justakid
      Hi All,
      Sorry if the title is a bit confusing, I wasn't sure how to explain it.
      Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)

      the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.

      I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.
      I hope this makes sense and thanks in advance for any help.
    • Scribe ScribeDocSubstitute Errors - A solution
      By CICT
      I hope this helps anyone that has had to put up with the ScribeDocSubstitute errors when no placeholder string could be found in a document - a problem that has had both us and our clients pulling our hair out.
      The 360Works Scribe help page - -  offers a solution of retyping an entire placeholder due to the XML creating a split string. We've been doing this, but at times it just doesn't work and we've never seen any evidence in the XML of a split happening.
      However, today we hit a eureka moment and believe the main problem is not split strings, but the use of Tracking under the Review menu in Word. With this switched on there are hidden occurrences of the placeholders in the XML that are referenced by ScribeDocSubstitute. We have had documents where the placeholder(s) has been typed, retyped and typed again (etc.)  but could not get around the error (we have a check that runs whenever we upload a Word template to FileMaker container fields, therefore documents that generate these errors are not allowed into the database). However, we've now been able to clear all errors within a file without retyping a single placeholder as follows:
      open the file generating the errors in Word, click Review, click on the arrow beside/below Accept, select Accept All Changes and Stop Tracking, save the file  and test
      We've been putting up with the placeholder problems since we started using Scribe and hope this helps people avoid the pain we've been through.
      Andy -

    • Container Fields and Printing
      By Answers
      In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens).
      The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC  it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.