Jump to content

Scott Pon

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Scott Pon

  • Rank
    1 man Army

Profile Information

  • Title
    IT Systems Manager
  • Industry
  • Gender
  • Location
    Milpitas, CA

FileMaker Experience

  • Skill Level
  • FM Application
    13 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'm having this problem now too. it has something to do with Java. but I have not found a solution. I have heard you have to uninstall and reinstall FM server. boo.
  2. Scott Pon

    Summarize data between three tables

    I did it this way and it works. Thanks for your help.
  3. I'm trying to summarize the amount of training hours for a specific department. I have 3 tables. Table1: List of people. Fields: Personnel Key, Person name, department Number Table2: List of Training. Fields: Date of training, number of hours, Personnel Key (from the Date, I get the Year and Month) Table3: List of Year/Month. This is where my calculations should display. I have a field for Month and Field for Year. Relationship #1: Table1::Personnel_Key = Table2::Personnel_Key Relationship #2: Table3::Year = Table2:Year, and Table3::Month = Table2::Month In Table3, I want to get a total of Table2::Number of Hours for Department 1. I created a field that will "Sum (Table2:Number of Hours)" but that will return ALL hours. How do I filter the hours in Table2 on Table1::Department Number = 1? Thanks.
  4. I created a database in FM pro. It has 50 records. A person can see the list of records. There is a button that will open a PDF that is associated to the record. For Record 1, the button will open the PDF "fileserver\folder1\0001.pdf". This works. Now i'm trying to implement this through webdirect. A person will log in, see a list of records, then click a button to the PDF. However. Using the same technique as the FM Pro, this does not work. I error-capture, and it generates an 'Error 3: File not found". this was attempted in Google Chrome and Firefox. I've tried to use the Open URL to open "file://///fileserver/folder1/1001.pdf". again it works in the fm pro, but does not work in webdirect. If I type in that path in a web browser address bar, it opens the PDF. has anyone tried to do this? what am I doing wrong? is this even possible? Thanks in advance
  5. Scott Pon

    Sort records (for list); specific items first

    Whoops sorry. yes they are all records. so I have 1 table "Issued List" it has a "Name" field, which would have the name of the location or name of the person. so I create a List based on this table and at the "Name" field. now I have to get the order correct. that's where I'm stuck. I have about 10 locations and 100 people.
  6. I have a keys database: what keys have been assigned to a person or location. so i need a list of these people (scott, bob, smith) or locations (key box 1, key box 2, binder 1). How can I put the list so that locations are first and people are 2nd (in alphabetical order) like this: Binder 1 Keybox 1 Keybox 2 Bob Scott Smith Thanks in advance.
  7. Hi All. I'm trying to understand how this works in my environment. We have Filemaker 13 Server, with FM Pro and FM Pro Adv clients. We are in a Windows Server 2012 Domain. So if I get an Ipad and connect it to the network, then download and install FM go, how does it connect to the FM server? will there be a problem with the Domain? The Ipad doesn't join the domain. Since it isn't joined, it also wouldn't be able to access the fileserver to view PDFs on the fileserver. is this correct? Extra question non-FM. What concern do you have with the Ipad being hacked? The Ipad would be on the network (even if it didn't get fileserver access). It could cause a security issue. thanks, not sure if I'm correct on these things. so let me know if I'm wrong. Scott
  8. Scott Pon

    Portal script trigger for new record only.

    Thanks for your input. The editing directly into the portal was requested by the user, which is why I am investigating. But your way is definitely doable.
  9. Environment: FM13 with FM13 Server, mix of Windows 7 and 10. Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new. We have a parent record, and portal to Children records. The children records have 2 fields: Profile Name and Process type. Our user would like to enter a new child record (profile name and process type). if the process type already exists, we will need to archive the existing record (matching the profile type). There is more bI want to start with this first. I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals. Any ideas on how to handle this? Or am I going to have to add a button to go to another screen to accomplish this? Thanks. I hope i gave enough info for you to help me.
  10. FM15? I'm just not ready.  

  11. Scott Pon

    FM13 to view MS Access table

    Thanks for the info. after digging through what you listed, it is NOT possible to link Access to FIlemaker in this way (Access as external data source) Here's a list of accepted data sources: http://help.filemaker.com/app/answers/detail/a_id/6420/kw/supported%20data%20sources And Access is not one of them.
  12. I'm at a loss, or maybe I overt-thinked this or missed the obvious answer. I have a Filemaker 13 Database on a Filemaker Server. I also have some additional data in MS Access. A user has requested to show some MS access data on to the FM database. So I created a ODBC connection. and connected it to my test access db. Attempt #1: I created a test FM file. I started with "Import Records"-> "ODBC Data Source". I selected my Data Source. It asks for Username / PW. I get to "SQL Query Builder". BUT: when I select the table, the Columns' box does not fill in. I checked the Access DB and gave "Users" Administrator Access. but still this box does not fill in. Attempt #2: Manage-> External Data Sources. I click "New". I choose "ODBC". for DSN I selected my ODBC Source. For simplicity sake, I left Authentication as "Prompt for username and password" I clicked "OK. It added to the External Data Sources list. BUT: when I go to Manage -> Database and tried to add to the relationship, it goes "The ODBC Data Source you have selected is not supported" then I'm stuck So is this possible, having Filemaker add an Access as a data source?
  13. Scott Pon

    Minimum Chart size or remove whitespace

    I checked padding. All 4 sides are 0. I can't go negative either
  14. I upgraded the company from Filemaker 11 to Filemaker 13. We are using Filemaker's built in charts. In Filemaker 11, we had a small 1" long , 1/2" tall line graph, which we used to show a trend. Clicking the chart will go to another layout with a large chart. However in FM13, the line cannot be seen. when I made the graph 2" long by 1" tall, I see the line graph, but I see a lot of white-space at the top and bottom. If these are "fixed" dimensions, it would squeeze in on the actual line. I thought this was the graph title, axis titles, etc. So I made sure the titles were blank. Didn't work. then I changed their fontsize to 1pt. still didn't work. Is there a way to remove that whitespace? or do I have to make these charts bigger? Update: I attached a picture of what I mean. the top is 1" by 1/2". the bottom is a duplicate of the graph, 2" by 1".
  15. Of course when I upgrade the company to FM13 (finally), FM14 comes out... sigh...


Important Information

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