Jump to content

Scott Pon

Members
  • Content count

    117
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Scott Pon

  • Rank
    1 man Army

Profile Information

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

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    10
  1. 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
  2. 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.
  3. 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.
  4. 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
  5. 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.
  6. 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.
  7. FM15? I'm just not ready.  

  8. 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.
  9. 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?
  10. Minimum Chart size or remove whitespace

    I checked padding. All 4 sides are 0. I can't go negative either
  11. 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".
  12. Of course when I upgrade the company to FM13 (finally), FM14 comes out... sigh...

  13. Universal (employee) list to use in any table

    IT WORKS! I don't know why that didn't work the first time I did it. I must be over thinking it. Thanks for your help!
  14. Universal (employee) list to use in any table

    Yes: I'm not duplicating data. I thought that was what I was doing. So I'll try it again. Thanks for the suggestions. I will let you know how it goes
  15. I have an employee table, where the employee has a status of "Active" or "Inactive". I'm trying to create a Value List of Active Employees that I can use anywhere within the database, in multiple tables. I though I could create a table "TableA" with a Calc Field "Static Active" = "Active" then create a relationship between TableA->Static Active with Employe Status. Then create a value list based on TableA. but that did not work. I end up with a blank dropdown box. In the same database, I have multiple tables that are going to need this value list. I originally created multiple instances of the Employee table and linked to each table. but that's multiple relationships, rather than 1 universal relationship But is there a better solution? Let me know if you need more explanation Thanks Scott
×

Important Information

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