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 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.
  2. 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
  3. Comment, I just entered the code as you described and it works just like you said it would. Very inspiring. Thank you so much.
  4. Thanks Comment. That is just what I needed. FWIW: I am a much better cabinet maker than FM programmer.
  5. 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
  6. Thanks Comment. Was exactly what I asked for. (Now I just have to reverse engineer the example that you posted)
  7. Hi Comment, This table would have maybe 12 to 20 records. It could be thinned down if necessary. We build: DOORS - DRAWER BOXES - FACEFRAMES - ROLLOUTS etc. All the things you would see in a set of kitchen cabinets. I am not sure if "variance" was the right word. What I am trying to compare is estimated labor with actual labor. Other useful comparisons might be how a individual's work performance compares with the company average, or maybe compare how long things take for them to produce today vs how long they took when they first were learning. I have a really great group of millennial kids working with me right now. They are really engaged with what they do and they like to see success. There is a lot of gratification in scoring performance. Numbers are precise but bar charts are comprehensible.
  8. I would like to create a database for my cabinet shop that contains three fields: I want to use this to better understand and explain how we are performing at certain labor activities. In the movie in my head it kind of looks like attached jpeg. The fields are: ITEM ESTIMATED TIME ACTUAL TIME Is this possible to produce a chart like this in Filemaker?
  9. Thanks Comment! That was exactly the code I needed. (How do you know all this stuff???)
  10. I watch a lot of training videos on Youtube. Whenever a topic interests me I add the URL into a simple two field database that contains a DESCRIPTION FIELD and a URL FIELD. The database lives on Dropbox so I can find it wherever I am. Some of the videos last for 20-30 minutes but I am only interested in small sections that last for one minute. I would like to find a way to find those particular sections without scrubbing through the video. Is there a way to script opening the video and then go directly to that sequence of the video? For example: the part of the video I want to watch lives at 3:38/19:58. Could I add a third field called CHAPTER that would open the URL field and take me to 3:38 in the movie?
  11. I have a database that assigns task to workers in my cabinet shop. The field "Worker" is populated from a drop-down value list. If you want to find all of the tasks assigned to a particular worker you select their name in the "Worker" field then click a (FIND WORKER) button that drives a FIND script. The FIND script reads as follows: 1 - Set Error Capture [On] 2 - Copy [Select Entire Contents] 3 - Enter Find Mode [ ] 4 - Paste [ Select ] 5 - Perform Find [ ] All of this works fine when run on a desktop computer but does not work at all when run in FilemakerGO on an iPad. Is there something I need to do different or is this script not compatible with FilemakerGo?
  12. Thanks Steve. That's the clue I needed.
  13. I am trying to build something like a bingo board to act as a visual management tool for my cabinet shop. This bingo board might be printed out on hard paper or could be electronically managed on an iPad. I would like to have the field names show up as a column on the left side of the layout with the field contents displayed in a spreadsheet type format on the right. The image of each cabinet would derive from a repeating container field. The value for each task would derive from scripts that are keyed to each cabinet type. A sink base, for example, would not have any values in the drawer box category but a drawer bank would not show cookie trays. When the bingo board is completely filled in the kitchen is done and ready to ship. Is there any way to do something like this within Filemaker?
  14. Thank you LaRetta! Once again you have pointed me in the right direction. I spent a little time with the GetDevice Function this morning . I haven't had time to make much progress yet but imagine this has something to do with an IF statement that directs me to the layout I want. I have been rapidly deploying topic specific solutions for my cabinet shop. I came up with one last week that tracks material remnants and another one a day or so ago that elegantly assigns priorities to tasks and monitors status. We run most of this with iPads but I wanted to have it available for iPhones so people could add to the list if they think of something outside the shop. And thank you too Lee. I bookmarked the link to DevCon sessions. Most of those are way over my head but some of them surprisingly make sense. I am a cabinetmaker, not a programmer like you guys.
  15. Does Filemaker 16 offer the ability to utilize responsive design? Is there anyway to create breakpoints within a database so as to have the displayed layout be appropriate for an iPhone, iPad or desktop device? If this is not possible and I need to create three separate layouts, how does the device know which layout to toggle to? I
  • Create New...

Important Information

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