Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Jarvis last won the day on April 15

Jarvis had the most liked content!

Community Reputation

1 Neutral

About Jarvis

  • Rank

Profile Information

  • Industry
  • Gender
    Not Telling
  • Location

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I have a script that requires a pause for radio button input. The pause is currently set for 2.5 seconds. Is it possible to script this such that the pause stops (and the script continues to run) upon field modification?
  2. Thank you Olger. Is all I needed to hear. Is way above my paygrade.
  3. Thanks Steve. That sounds easy enough.
  4. I currently spend about $60 per month to a company that hosts my FMP 14 databases on a shared server. How complicated would this be to manage on my own? I am not interested in hosting sites for anybody else, just those for my own company. What kind of dedicated computer gear would I need to make this happen? Would I need to have a dedicated IP address? Can this be done by a rube like myself or would it be better to continue paying someone else for this work?
  5. How complicated is it to migrate solutions written under FM Pro 14 to FMP 18? Will I need to rebuild them from 14 to 15 then 15 to 16 etc?
  6. I use Filemaker Pro 14 to communicate with my cabinet shop. I host my databases on a remote server that costs me $55 per month. The total ecosystem consists of three iMacs, three iPads and an i-Phone. The iPads & iPhone are, of course, hooked to the database with FM GO. I am usually fairly slow to adopt new software and new operating systems for several reasons. For many years I was first in line for every hardware and software upgrade. Over time I accumulated a lot of software and a lot of machines. The machines were always smarter than me and the software plenty competent enough. None of the new features were compelling enough to jump ship from what I was working with. Usually an upgrade on a piece of software required an upgrade to OSX. I couldn't simply upgrade one piece of software without upgrading all of the software and sometimes this meant I needed new work stations as well. I would be happy with Filemaker 14 for the rest of my life. My CAD software is out of date but I can play it like a piano. I prefer desktop applications over cloud based solutions. I am also getting a little fatigued by everybody having their hand in my pocket for $70 a month. (The software companies seem to have concluded where price elasticity kicks in) Enough of my rant: MY QUESTION is: Is it possible to add (FM14 compatible) Filemaker Go to to additional iPads if they are accessing FM14 based solutions?
  7. Thank you to everybody for your help here. I really appreciate it. I would be curious to learn more about the results of Tony's retesting of "Hide Object When". My comprehension of the "Conditional Visibility" section of the article BCooney pointed to seems to corroborate what Fitch reported. CONDITIONAL VISIBILITY If you use the new feature to hide objects when a formula is true (Conditional Visibility), be aware that it follows the exact same rules as Conditional Formatting. It immediately reevaluates as referenced data changes and as the window is redrawn. No commit or refresh is necessary. Like Conditional Formatting, this is nice, but it can lead to a significant performance impact if there are a lot of conditionally hidden objects on the layout.
  8. I have been watching and re-watching a web seminar by Mark Richman called "Eight ways to make Filemaker databases run even faster. https://www.youtube.com/watch?v=yNRNMgs--T4&spfreload=10 The basic goal is to minimize the packets of information that need to come down from and go back up to the server. He makes the statement that "if you can see it or touch it, it invokes the data" . To this end he advocates for using more layouts with fewer objects per layout. My question has to do with how visibility factors into this. A database I am creating for my cabinet shop has a lot of graphics that are grouped together with fields. These combined objects are stacked on top of each other then made visible based on the results of a calculated field. The attached jpeg shows a couple of typical objects. Only one of these objects is visible at a time. The entire stack would probably comprise a dozen or so of these objects. If only one of the objects is visible at a time do the non-visible objects contribute overhead weight to the layout? Would my database refresh faster if each of these cross-section objects was on it's own layout?
  9. I am not sure if this question belongs in the Calculation Engine forum or the Relationship forum. This extends a question I posted earlier this week. It involves multiplying summary fields X summary fields.scope of work.fmp12scope of work.fmp12 I am developing a database for producing bid-cost estimates for my cabinet shop. I have a table that produces a graphical synopsis of the cabinets that we need to bid on. This SYNOPSIS table tracks how many doors, drawer boxes, faceframes etc are contained in each cabinet and keeps a running total of how many items are required for all the cabinets. A second table tracks labor costs for building various components. There will eventually be several tables like this for the various components we need to build. The LABOR DOOR table tracks batch size and total minutes. We use this to calculate minutes per item. One of the goals for these labor tables will be to determine what is the optimum batch size for any particular component. I would like to be able to link the data from the labor tables to the synopsis tables. I have been unable, however, to accurately calculate how much time all the doors we have sold will take. This should be a simple multiplication of Door Quantity X Average Door Minutes. The yellow field in SYNOPSIS table should read 12 Doors X 22 minutes per door = 264 minutes instead of 45. I am not sure if this is owing to a bad relationship or that I cannot somehow use Summary Fields in such an equation.
  10. Here is a comparison of the way I was scripting this before being edified by Comment. This database posts all the math for six possible drawer box combinations. When everything is posted it will get exported as a CSV file to a standalone application that optimizes the most efficient way to cut plywood. I have no control about how that software imports the CSV. I just have to make my data show up in the right columns. If you compare the two upload methods you will see that Comment's recommendation seems to take about half as long. This is on a desktop computer. I imagine the difference would be much greater if you had to move all those packets of data back and forth using Filemaker GO on an iPad. I don't know enough about fetching data with a lookup to know if this would be viable for me. The panel optimizing software needs all the data to show up in one place but the cabinet information derives from many locations. To simplify testing I have included yellow buttons to populate cabinet data fields. If you are interested in testing the "search & destroy" button it is best to change the (yellow) cabinet ID number at left. The reason for this button is that information is always changing in cabinet land. We need the ability to seek out any instance of cabinet math and delete it from the cutlists when the information changes. I just thought I would put this up to show how much better Comment's approach is than mine was. Since drawer boxes are just a tiny portion of the entire conundrum I can only imagine how much better it will run for this change in appproach. Box Math Copy 1.fmp12
  11. Comment, I just entered the code as you described and it works just like you said it would. Very inspiring. Thank you so much.
  12. Thanks Comment. That is just what I needed. FWIW: I am a much better cabinet maker than FM programmer.
  13. I am commencing a massive re-write of the database we use to run our cabinet shop. This database involves a lot of fields and a lot of scripts. Much of the database is managed on a desktop computer but lots of the information is passed to an iPad through Filemaker Go. I want to make the scripts as efficient as possible. Many of them now require too many round trips to the server. I am hoping to do this with a SET FIELD script. I am trying to develop a script that collects data from the current record of one table and posts it into a new record on another table. This works fine if I move back and forth between layouts using copy & paste. When I try to do this with SET FIELD it always returns the values from the first record and ignores the values in the current record. Can SET FIELD pass this kind of data or am I just doing something wrong? I have attached a sample file of what I am trying to accomplish: The protocol is as follows: 1) We import cabinets from the cabinet library 2) We develop cost estimates on a synopsis sheet to predict labor 3) If we get the job we go back to each cabinet on the library page and corroborate the dimensions. When they have been audited we then post the record to the MasterLIST. It is this last step I am having trouble with. setfield example Copy.fmp12
  14. Thanks Comment. Was exactly what I asked for. (Now I just have to reverse engineer the example that you posted)
  • Create New...

Important Information

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