Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About Goetch

  • Rank

Profile Information

  • Title
    Business Systems Analyst
  • Industry
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Never mind a little premature, this would only work if every item had an entry in the options table, and they don't, so back to the drawing board.
  2. Responding to my own topic in hopes that this helps someone else. It was so simple, I just needed to get related records using the options table and use a sub summary by orderLines::itemSku and that produces what I need.
  3. So I have an order entry solution that I am working on where the items can have "options" that effect the item's pricing. Basically I have orders --- > orderLines ---> items ----> options. In a basic invoicing solution I could easily just goto related records on the order lines and print an invoice type document. What I need to do is add these option lines to that type of print layout. I have seen a very similar post in the forum, but was wondering what else I could do to print these "option lines" on the invoice. I feel like I am missing something simple and obvious.
  4. @webko Thank you so much for the hint. It actually seems too easy now that I did it!!! I basically created a VL, populated the utility table, omitted blank records to get a record count then just looped through creating new records in the summary table, setting the fields just like one does for the VL utility table.
  5. @Steve Martino - The reason as webko stated is for performance. The figures for the historical data do not change, at times an item's classification does get changed, or was entered incorrectly by the data entry team. The program itself is really just a type of data cube, and summarizing and storing historical data will speed up many of the reports. The users of the program expect the reports to be near instant. I rarely use the FileMaker's built in sub summaries, the users like to see aggregate data, so sub summaries do not always work for the style of reports they want. I have tried to m
  6. We have been using FileMaker for reporting for several years now. We basically import invoice lines ( and several other KPI fields from related tables ) from our point of sale into our reporting program nightly. Basically what we have is lots of historical data that is not summarized. Most of my reports use summarized aggregate data, a few actually need the line details. What I would like to do is create several summarized tables from my main data table so I can have several summarized data cubes basically. What would be the best way to import the summarized data from the existing table
  7. I figured out a way to do what I wanted. I created a "view" table with globals and used a cartesian join to the scan table. I made scripts to set the fields and used a portal sort by id ( descending ) to show the last few scans. Seems to work great!! Can not wait to do a spot inventory test.
  8. I am pretty sure this is a known bug in FMGo 13, however, I was wondering if anyone might have a work around. I am having an issue with list view in a simple FMGo 13 program. Basically after about 20 or so records the input field of a new record disappears. Scrolling the screen will almost always bring it back. The program is pretty simple, 3 tables, 2 input fields scan and qty. I made the program to help take our physical inventory. The user is only interacting with the "scan" table. The two fields are scan and quantity. Basically I download the program into an iPhone and pair
  9. I have been able to get both server.app and FMS to work on the same server. I can not recommend doing this in a production enviornment, but this may be suitable for a development enviornment. One problem is that server.app and FMS will overwrite the ocnfiguration files if you chnage any settings in either. For those who would like to teest this out... In a nutshell, the machine will need 2 static ip address, just go to system prefs and go to network and click the + choose your curretn interface and assign a static ip address. Create a dns entry something like fiemaker.yourdomain.
  10. I have been reading through the documentation about installing FileMaker Server 13 on OSX. I only have one server at my location and that also runs my open directory and internal web services. Generally I use opendirectory groups for my soultion permissions. Going by the documentation I do not see a way to install FM Server 13 on this machine since by default Server.app uses ports 80 and 443 for it's own "Server" website. In the documentation on Page 72 it says my options are to configure the web services on Server.app to use different ports, I do not beleive this can be done, so the
  11. Thank you for the explanation and the tip. I didn't realize what was happening under the hood, but I probably should have, it makes total sense now. Thank you for your input it was very much appreciated!!!
  12. I created a sub summary report that also uses filtered portals to create a report for our companies sales. I thought it would be neat if I could show the monthly sales by department for each year we have on record. My goal was to show each department as a row and each month's sales as columns. The report works, and shows the correct data, however it takes hours to run and summarize the data making the report unusable as it stands. I even tested just using one department and one year to see how long it would take to generate the report, and it took about 30 minutes before it was finished.
  13. Dan, Thank you for your suggestion, I think I will start using the calculated date feild as you suggested. However, your sample file didn't address what I was really going for, and I am sure that is becasue the image I uploaded didn't show the whole report. The Report I was looking to generate was to sort by salesperson and summarize the sales person's sales by month. Usually we only display a year at a time on this report. However I am able to get the report I want by using many to many relationships with the sales table, however, I thought a many to many relationship was a no no..
  14. Hi I am having trouble making a report for my file. In a nutshell I have These Tables "Written Sales", "Sales People" , "Salesperson hours", and "Sales Person Goals". I am pretty happy with my yearly report / comparison, but now I want to show the same data by salesperson then by month. I tried using sub summaries but have not been able to get all the data needed for the report this way, namley my hourly productivity and goals. I have attached a copy of the file I am working on for your viewing pleasure.  The file is pretty basic, and I am a novice so please be easy on the crtitic
  15. Not being a filemaker guru, Would the use of globals cause any issues if there are multiple people using the solution at the same time? Also you are correct I am using relational value lists, however they all are based on the vendor, I have run into a little road block with this, in some cases we may use fabric from a different vendor than the frames vendor. They way I have the value lists set up the sales person would not be able to select a fabric from a different vendor. Is there a way to put in a case or if statement to use a different value list if certain criteria are met?
  • Create New...

Important Information

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