Jump to content

Jarvis

Members
  • Content Count

    670
  • Joined

  • Last visited

  • Days Won

    1

Jarvis last won the day on April 15 2019

Jarvis had the most liked content!

Community Reputation

2 Neutral

About Jarvis

  • Rank
    wannabee

Profile Information

  • Industry
    cabinetmaking
  • Gender
    Not Telling
  • Location
    seattle

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.10.5

Recent Profile Visitors

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

  1. Thank you so much! That was exactly what I needed.
  2. I have a task list that I use to manage work orders at my cabinet shop. This list contains all work orders for all customers. Each record essentially contains three fields: Customer Name - Task Description - Status. Status can be either "Pending" or "Complete" The Status Field is populated with the status "Pending" with an auto-enter upon record creation. When I want to thin the list down to tasks germane to a specific customer I click on that customer's name then run the following script: 1) Set Error Capture [ on ] 2) Copy [ Select ] 3) Enter Find Mode [ ] 4) Paste [ Select ] 5 Perform Find [ ] This script returns all the records germane to a specific customer but does not differentiate between Pending Tasks & Completed Tasks. Is there a way to filter for a specific customer but constrain the list of work orders to just those tasks that are still "Pending"? I don't want to see all the tasks. I just want to see the tasks that remain.
  3. Thank for the info Wim. I am going to guess this is one of those things that if you have to ask what it costs you probably can't afford it. Something I have noticed about subscription based software is that Price Elasticily of Demand seems to hover around $70 +/-. That's about as far as they figure they can reach into your pocket without you saying no or finding another source. $70 a month to be on the filemaker team, $70 a month to host a shared file on somebody else's server. $70 a month to have access to Adobe Create Suite. My cabinet shop is located about two miles from Amazon Headquarters. Almost every one of my customers works for Amazon, Google, Apple or Facebook. Funny thing is whenever I tell them I want to license a kitchen to them for $70 a month they say "Absolutely NOT!" They somehow don't like subscription services when it's their pocket.
  4. How does Web Direct work with respect to licensing requirements? I would like to create a database for my cabinet shop that I can use to train customers. A lot of this will be predicated on Conditional Value lists. If you pick "Natural Wood", for example, you would be presented with a subset of further questions related to what species of lumber, whether the lumber should be slip-matched or book- matched etc. If you pick "Paint Grade" you would be presented with a list of options like Spray Painted vs Brush Finished. What I am trying to is present information and ask questions in a way that my customers don't need to drink from a fire hose. My question is how is this handled with the current subscription based licensing paradigm in Filemaker? As I understand it the current licensing model allows for 5 seats on a basic license. What happens if I have twenty projects currently in process? How do I provide licenses (seats) for all of these people who come and go?
  5. I have a half dozen possible plan-view conditions for cabinet boxes. The cabinets can have an exposed end, abut a wall or appliance or simply be adjacent to another cabinet. I have some standard drawings that depict these conditions. Should I store these drawings in repeating container fields on another table and call them with a calculation or I should I simply stack them on top of each other and control their visibility with a calculation? Which approach would require less data to move down from a server?
  6. I figured it out. Problem was in a match field alignment.
  7. I am trying to script completion status for each product that my cabinet shop builds. To make this happen I have created a library of possible cabinet styles. This library contains all the tasks specific to each particular cabinet style. The process starts out with creating a record in the PROJECT table, stipulating what style of cabinet it is then activating a script that imports tasks germane to that style of cabinet. The logic for this seems simple enough but I cannot get the script to properly import the tasks. No matter what style of cabinet I initially stipulate it defaults to the first style in the library. It also won't import tasks for the same style cabinet more than once. It seems like this has something to do with found sets but I don't have the horsepower to find the sets. Can anybody tell me what I am doing wrong? Bingo Board.fmp12
  8. Comment, Thank you so much for that formula! I just went out to the shop and measured a bench we have in production. I compared it with what your calculation said it should be and baddabing-baddaboom we built it just like the Filemaker says we should. You are really talented at this but I think you missed your calling. You should have been a Cabinetmaker!
  9. My cabinet shop builds window bench seating for kitchens. I am ultimately trying to determine overall projection into the room. The basic parameters are angle of the back (A), projection from the wall (B) and height to the window sill (C). What I am trying to calculate is how deep the base portion (D) would be. I am thinking this has something to do with the pythagorean theorem but my math skills are not big enough to be sure. Angle (A) is typically 10º though can vary. Is there a way to derive Dimension D from a filemaker calculation?
  10. 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?
  11. Thank you Olger. Is all I needed to hear. Is way above my paygrade.
  12. 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?
  13. 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?
  14. 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?
×
×
  • Create New...

Important Information

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