Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Title
    Business Systems Analyst
  • Industry
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Goetch's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  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 move to virtual list style reports, however, they took longer to generate than using multiple table occurrences, and the users were not happy waiting 5 to 10 seconds after a button click. This was probably due to my lack of experience with virtual lists. I didn't think of trying to use a virtual list for the import, so I will give that a try. I am not that experienced with the technique, but I think I can muddle through it.
  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? Is it even possible? For example I would like to summarize sales by category by month and import that into a new table. Any insight would be greatly appreciated.
  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 a socket scanner with it. I have a script trigger that runs on object save on the scan field. The barcode and based on a preference either a new record is created or the user enters in the quantity. Everything works great until about 20 or so records are scanned, then the user can no longer see the input field on the bottom of the screen. Scrolling up usually fixes this. The program seems to work flawlessly if the layout is set to form view, however, obviously the user does not see the last few scans in this view. Like I said I have read that there are bugs in list view. Can anyone suggest a work around?
  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.com and point it to the new ip address. Shut off all server.app websites including profile manager, calendar, websites, and wiki. install FMS allow FMS installer to disable the ports 80 and 443 Edit the server.app apache config files to listen on the original ip address I think you need to edit 2 files /Library/Server/Web/config/apache2/httpd_server_app.conf and /Library/Server/web/config/apache2/sites/virtual_host_global.conf Now you need it edit the FMS config files to listen on your new ip address. /Library/Filemaker server/HTTPServer/conf/httpd.conf /Library/Filemaker server/HTTPServer/conf/extra/httpd-ssl.conf For good measure I also edited the file /Library/Filemaker Server/HTTPServer/bin/httpctl and changed the hostname variable to the dns hostname I gave filemaker (example: SERVER_NAME="filemaker.yourdomain.com") Keep a backup copy of the files you editied because both server.app and FMS may overwrite the files if you make any changes to either.... go into server.app and restart your web services including, profilemanager, calendar, wiki and web sites. (you may need to restart) test yourdomain.com should go to your internal sites and filemaker.yourdomain.com should go to the filemaker websites. For php to work with filemaker you may need to edit more configuration files, I am still working on getting PHP to work... However I ahve been able to test webdirect... There may also be issues with using the server.app sites and they may take up a concurrent connection, I am still testing this... But I think if you go to your profilemanager site it may use a concurrent connection.... This is posted as-is and is meant for development only..
  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 other option is to uninstall server.app, also not really an option... So if I go by this documentation my only real option is to purchase a new machine to be my filemaker server... So is there a way to install FM Server 13 on a Mac with running Server.app and have both function?
  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. In a nut shell this is what I did. For the basis of this report I have a "Sales" table that contains the following fields: "Date of Sale" "price" "quantity" "Extended Price"(calculation that takes qty*price), "department" , "month of sale" (calc month (date of sale) , "year of sale" (calc year (date of sale) and a summary field "total price" (summary extended price). I started off by creating a Cartesian self join to a TO allsales. I then created a new layout based on the TO Sales and made a sub summary by year, and a sub summary by department. I then made 13 portals from the "allsales" TO and filtered them ( Sales Sales::Department = Sales All Sales::Department and Sales Sales::Year of Sale = Sales All Sales::Year of Sale and Sales All Sales::Month of Sale = 1) and so on for each month and then a total for the last filtered portal. I put the "total price" summary field in the portals. This enabled the data to be viewed as I would like it and the totals were correct, however it takes what seems like forever for the data to populate. I was just wondering as to why it takes so long to summarize this data set? Currently there are about 450,000 records in the database. But even when I limit the records to one department for one year (about 5000 records) it still takes an incredibly long time to populate the data. I have been reading through the forums and I guess this is basically a "cross tab" report, so I guess I can try other techniques, but this was so simple compared to what I have read.
  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.. Ideally I would like to be able to get the same data on the comparison report drilled down to a monthly format, however, I think I would need to use a different technique to accomplish this. Anyway if anyone can shed some light about using many to many relationships in this way it would be appreciated. I attached the file. Writtensales copy DS 2.fmp12.zip
  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 crtiticisim, but any and all comments are appreciated!!! I am sure I am just not seeing the easy answer here.   Here is what I want to accomplish with the current file.   Writtensales copy.fmp12.zip
  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.