Jump to content

John T

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About John T

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10
  1. Hello Olger, Thank you very much for all of your guidance regarding the process to follow to combine files. I spent most of this afternoon giving it a try on a backed up version of Inventory. I tried migrating into it the least complex file I had (Market Data). It did work until I started looking at the scripts that would have to be modified to fit the new configuration. That's when I hit a road block which made me realize that if I ever attempted to integrated some of my more complex files into Inventory it would take a long time to accomplish. My business just can not stand to be put on hold for days at a time while I do that. I will just have to live with many different, but linked files. Thanks again.
  2. Hi Olger, Thank you for the suggestion of using "exit application". I just added it to my closing script and it worked very nicely closing all of the open files. Great! Another problem solved. Yes I see the wisdom of combining some of my files so that operating it/them on FM Go will be more seamless. Is there some easy way of consolidating say my market data file into my Inventory file without having to add all new market data field names into the Inventory file? Possibly by going to File > Manage > Database > Tables > Import > Market Data?
  3. Yes, occasionally I have given thought to the idea of merging some of my 11 separate files, but let me give you all some insight into why that hasn't happened. I started using FileMaker many years ago starting out with FMP 5. Prior to leaning about FM I had experience with DB2 and another program the name of which I have forgotten. It took me 14 months to create a very thorough, relational book database for my books, my customers, market data and shipping statements/invoice files. They were all separate, but related files. Through the years I have added more related files to keep track of profit, monthly profit, customer credit card data, book appraisals, and most recently bookbinding projects/billing. Once cell phones became ubiquitous I started to imagine the day I would be able to load parts of my database on to my iPhone so that I would have some critical information available to me when I was in the field. Once FileMaker Go appeared I knew that my dreaming would become reality. But to put all the multiple files covering things like profit, credit card data, bookbinding, etc. on the iPhone would only clog up FileMaker Go with unnecessary stuff. So, I felt that keeping them separate would allow for both a piecemeal download to FM Go and also keep the credit card file separate for security purposes. At this point I consider my scripting problem solved. The workaround that I came up with may not be the most efficient in terms of scripting, but it works. And going back to the idea of consolidating files I am stopped by considering the old adage - "If it isn't broken, don't fix it." I will be the first to admit that one of my current minor complaints about having migrated to FM 17 Advanced from FMP 13 is that each of my separate files when opened requires that it be closed before I can quit the entire book database. Previously under FMP 13 I could close the open open file and all files would close with it. A picture attached below might help to explain what happens now. I didn't really complete the first sentence of my last paragraph. It should have read: "I will be the first to admit that consolidating files would solve my one current minor complaint about having migrated to FM 17 Advanced from FMP 13 which is that each of my separate files when opened requires that it be closed before I can quit the entire book database."
  4. Hello Comment, Thank you for your comments on my problems with this script issue. Before going further on the actual script I have to say that setting up a relationship between the files of Inventory and Web pages is not possible. One book in Inventory can have several different scripts in Web pages which access it. For example: a book by Robert Frost is accessed by the script for the individual page for Robert Frost as well as a more general page for books of poetry. Now, on to the specific script issue: I tried your suggestion (which makes perfectly good sense) so I created a script which read: Perform Script [by name: Inventory.fmp12::gTemp Script Name from Web Pages] but it was not accepted by FM with an error message stating it would not accept the first bracket as it expected "A number, text constant, field name or "(" is expected here." I replaced the first bracket with a "(" and then FM's error message highlighted "by name: Inventory.fmp12" and read "the specified table can not be found". Even taking out the ".fmp12" so that my script conformed perfectly with your suggestion made no difference. Is it any wonder that frustration abounds with this new scripting methodology! It appears that I was wrong about being able to copy to the clipboard and paste to non-FileMaker applications the clipboard contents. I would be happy to use "the default font" in my posts, but I do not see anything in the above format line of symbols which allow one to do that.
  5. Olger, thank you for your kind note. I gave the Perform Script function a try. It started with: Perform Script [Specified by: Name ; ___ ; Parameter: ___ ] where I tried to fill in the blanks with the following parameters: Perform Script [Specified by: Name ; "Script name" ; Parameter: "Inventory.fmp12" ] which did not work. Perform Script [Specified by: Name ; "Script name::Web pages.fmp12" ; Parameter: "Inventory.fmp12" ] also did not work Perform Script [Specified by: Name; "Script name::Web pages.fmp12 ; Inventory.fmp.12"] did not work. At this point I was beyond frustration. But, your second paragraph gave me an idea to use a completely different approach. I created a new global field in Inventory and then created a short script in Web Pages to copy the contents of the field "Script Name" to a new global field in Inventory. I also created a new script in Inventory as follows: Go To Field [Inventory::gTmep Script Name from Web Pages] Perform Script [by name: Get (ActiveFieldContents)] Set Field [Inventory::gTemp Script Name From Web Pages; ""] This worked perfectly. However, I can not understand the first method of trying to activate the appropriate script from Web Pages. By the way, during this process I found another thing which I really dislike in FMP 17. It does not allow one to copy into a clipboard the contents of a script so that it can be pasted into a document like this.
  6. I have great hopes that someone can help me...please. Although I am very new to this forum, I am a long time user of FileMaker products. I recently migrated from FMP 13 up to FMP 17 Advanced. In FMP 13 I was using a plug-in to allow me to open and run a script in another file. Unfortunately, that plug-in no longer works in FMP 17 as it is no longer supported and I was told that the new version of FileMaker allows users to perform all the functions that the plug-in previously offered. As a result, I have been trying to bring myself up to speed with FileMaker's new scripting methodology (which I am no fan of). I have exhausted all the resources that I have accessed and am lost. In greater detail here is my problem: In total I have 11 different files which are the core of my book database. Two of those files allow me to create the 200 or so static web pages I use to populate my web site. The primary file is one called "Inventory" which contains active records for well over 4,000 books. A second file is called "Web pages" where there is a separate record for each of my 200 plus web pages. In that file there is a field called "Script name" which references a script of the same name which resides in the file Inventory. I need to create a script which allows me to call up the script name appearing in Web pages and then run that script in Inventory. All of my efforts to create such a script so far have been complete failures. I hope someone can please write out the actual lines to accomplish this feat. Thank you in advance.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.