Jump to content

Matt_

Members
 View Profile  See their activity

  • Posts

    37

  • Joined

  • Last visited

Everything posted by Matt_

  1. Matt_
    Hi there, I tried doing something similar with a solution a while back. What I ended up doing, and turned out to be a clever trick was this: -Take your animated GIF and convert it to base64 (I used this website: http://www.base64-image.de/) -Create a web viewer object and insert the HTML below as your web address, substituting your_base_64_data_goes_here I've found this to be a quick way to accomplish this, and haven't noticed any obvious performance degradation as a result. "data:text/html, <html> <head> <style type="text/css"> body {border:none; text-align: center; margin-top: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; padding: 0; background-color:#b3b4b4;} </style> </head> <body> <img src="data:image/gif;base64,your_base_64_data_goes_here"> </body> </html>"
  2. Matt_
    I was able to find a resolution for this. I used the GetFoundSet(Fieldname) function from http://www.briandunning.com/cf/1093 Using global variables, I was able to incorporate this into a report generation script. When the report is generated, several global variables are created, example: $$TheftY, $$TheftN. If a "Theft" statistic is coded in the found set, $$TheftY="X", which is output using a merge variable onto the report.
  3. Matt_
    I'm trying to create a report for a solution, and have hit a bit of a roadblock when creating a report.  I have 3 tables:  1. Statistic Categories     -Each record in the table is a particular statistic code  2. Incidents     -Contains individual incidents. Each incident is coded with a statistic (using a value list, containing values from Statistic Categories table)     -Only 1 statistic code is assigned per incident  3. Reports     -Reports are related to a particular incident, and contain an incident report for the incident.     -Each incident may contain multiple reports   I am using a report format already in use by the company, and need to continue using the same format. The report itself is "hard coded" as it needs to be in the same format as the existing form.   From time to time, searches may be performed to display incident reports for a certain incident date range, or for a certain incident type(s). Based on the reports found, I need to update the header for the report to output a Yes/No value as to whether the found set contains a certain report type. I suspect this can be done somehow by obtaining a count of each statistic category in the found set?  I would appreciate some advice on how to achieve this.  I have attached an example file.  Thanks Matt Report.zip
  4. Matt_
    Not sure if this custom function will help you at all.... http://www.briandunning.com/cf/143 As long as you know GPS coordinates for the pickup location and the driver, it should do the trick.
  5. Matt_
    I'm working on a solution that needed to do something similar. I setup a script that would be performed on Closing. (Under File Options) Show Custom Dialog ["Close Database";"Do you want to exit?"] ## Choices are No;Yes If [Get(LastMessageChoice)=1] Halt Script Else Close File [Current File] End If Not sure if this is the "right" way to do it, but it works for me.
  6. Matt_
    I know what you're getting at... the example in the first post is just that. It was just an example I could think of that would convey what I'm trying to accomplish. Matt
  7. Matt_
    I need to display some data for a report in a very specific format, and (so far) that's the easiest way I can integrate all of the elements I need to.
  8. Matt_
    Anyone know of a way that I can display a number of related records in an html <table> using webviewer. I need a page displayed in a format as shown in the attached picture... I'm just trying to figure out a way to display the "Guest List" portion of the data with the Guest ID, Name, Response, Date Received fields. This data is kept in a separate table (Guest List) from the Event table. untitled.bmp
  9. Matt_
    The sample provided is excellent! Thank you so much! How would I modify this to do a reverse geocode? (Provide lat/long and retrieve a street address? Thanks!
  10. Matt_
    Hi there, I apologize in advance, I have a feeling that this is going to be ridiculously easy to do, but I can't seem to make the relationship work to do this. I'm creating a solution where police reports are entered, once a report is entered, an officer may want to cross-reference a report to another. It could be more than one report. ie. Officer A enters Report #1 for Robbery Officer B enters Report #2 for Vehicle Theft Officer C enters Report #3 for Abandoned Vehicle It is determined that all 3 reports are related (vehicle is stolen, bad guy robs a bank, and then abandons the car). If a user views any of the 3 reports, it should show the 2 other related reports. I did a search, and didn't come up with anything... any help would be greatly appreciated. Thanks in advance.
  11. Matt_
    I was actually able to sort it out. It was setup to Format as decimal - 2 decimal points. I changed it to "Leave data formatted as entered" and it works just fine. Thanks : Matt
  12. Matt_
    Hi there, I'm working on a billing statement, and I'm trying to sort something out. On the "Account Terms and Conditions" portion of the statement, it shows the late payment interest rate. If the rate is an even number, for example 24% it displays correctly, but if it's a rate like 22.75%, the decimal place doesn't appear. I've tried changing fonts to see if the decimal place wasn't a recognized character in that font set but it does the same for Arial, Times New Roman, etc.. The field it uses is specifically for displaying the interest rate in examples like this Account_InterestRate = 0.2275 Account_DisplayRate = Account_InterestRate * 100 = 22.75 Is there something I'm doing wrong? Thanks : Matt AccountStatementIntRate24.pdf AccountStatementIntRate2275.pdf
  13. Matt_
    Hello, I have a Filemaker solution that I'd like to integrate with a PBX (telephone) system. The PBX system uses a Postgres database. I've used external sources before (MSSQL, etc..) and never had any trouble, but I can't get it to play nicely. I don't need to write to the Postgres DB, just read (if that makes things easier). Any ideas/suggestions would be helpful! Thanks!
  14. Matt_
    That would likely work, good thinking! I'll give it a shot. Thanks again, Matt
  15. Matt_
    I assume that'd only work on the end of the person who changes the value. Probably the easiest way to think of it is that I'd like to to work like your audio notifications would work in say, your email client. So you have 0 new messages, but when new messages changes to 1, it makes a sound. That's kind of what I'm trying to do. I'm trying to come up with a solution for a contracting company, and when a new job is entered in the system(by a receptionist for example), the new job value changes from 0 to 1 (for example), and a notification sound is made (on all other systems).
  16. Matt_
    I'm still trying to wrap my head around this new Script Trigger feature, hopefully someone can point me in the right direction. I need there to be some type of audible cue when a field value changes, whether it be some sort of audio file playing, or just the "beep" command. I'm not picky as to how it does it - as long as it does it. Cheers, Matt
  17. Matt_
    I was just curious if anyone had any experience using a solution on FileMaker server over a mobile internet connection. Not WiFi, but the internet connections available through cellular providers. I'm working on a project right now, and it would be great to take advantage of this technology. It's capable of using the EDGE/2G/3G networks, with speeds up to 7.2Mbps. http://www.your.rogers.com/business/wireless/products/business_products_details.asp?shopperID=G5NF8FNVV0GV9J6S95V8E7R6NP1F7TCF&PRODUCTID=MC950DREDR&summary=1 I assume that these speeds would be acceptable for using with FileMaker. Thought I'd ask and see if anyone had experience with these gadgets, or any comments/suggestions... Matt
  18. Matt_
    Thanks Fenton, I'll give it a crack and see how it goes. I'll report back if there's any problems or I can't figure it out :)
  19. Matt_
    [color:blue]Anyone? Anyone?
  20. Matt_
    Hey, Please bear with me... I'm not sure if this is the right to post this but I'm hoping so. If not, please feel free to move it wherever it fits in best. Here's my situation. I've got a contact address table within a solution, that contains different types of address for a student. These could be Mailing Addresses, Home Addresses, Temporary Address, etc. They are all start and end dated, so it is noted whether the address is current; and any old addresses can be kept on file for future reference. Also, not everyone will have a Mailing address. In most cases, the home address will suffice. So I need to assume that the mailing address is the home address. I'm running into a problem now, that if I need to display an address on another report, (say a letter to the student) I want to display only the address that is type: Mailing (or Home), and is current. Any suggestions on how to go about obtaining that address to use on the layout?? I have attached a PDF copy of the data entry screen, as well as the list of fields. I would appreciate any help : Thank you! fmForums3-tbl.ContactAddr.pdf fmForums4-AddressDataEntry.pdf
  21. Matt_
    Hi There, I've been working on developing a FileMaker solution for a couple years now. I've done all of the research I need to do to make everything work data-wise, it's in about 40 different pieces (from me trying to make each piece of the puzzle work without messing up something else!). What I'm designing is a student information/administratio n system that manages all of the course selection, scheduling, etc. By no means is this a small task! I'm kind of stumped when it comes to designing a layout/GUI that works for the application. I've played around with a few different ideas as far as design goes and I'm not really satisfied with how it looks. I'm hoping to get some suggestions on what the best method for designing an interface would be. I'm not really prepared to shell out a bunch of cash for something like Scriptology, and the pre-loaded designs are pretty bland. Does anyone have any ideas or suggestions on how to design a layout that would look good and function efficiently?
  22. Matt_

    Help with Portal

    Matt_ replied to Matt_'s topic in Portals

    If I remember correctly, it doesn't matter which fields I join, right? I joined the JobID field with the EmployeeID field with an "X" relationship. All that happens now is that the portal repeats the same thing over and over again... any ideas?
  23. Matt_

    Help with Portal

    Matt_ posted a topic in Portals

    Hi, I'm trying to create a portal to display a list of jobs... I thought this would be easy since I've already created some more complicated portals in my solution. The layout I'm using is set to the Employees table. It has a few fields in it (Employee ID, Employee Name, etc.) I want the portal to display a list of all records from the Jobs table (Job ID, Job Name, Customer, etc.) This should be an easy one... how do I set this relationship up? Cheers!
  24. Matt_
    My solution is too big and clumsy to upload onto here, so I made a very scaled-back and simple version. It has all of the relationships setup, as well as some sample data so you can see how it interacts. It should give you a good place to start and build from. If you have any questions, give me a shout. I've learned a lot trying to build my solution and I'm always looking to learn more... hopefully I can help. Matt db1.zip
  25. Matt_
    I'm working on a solution which may very well help you. Unfortunately, it is very specific to the geographical area I'm in (as far as reports, etc.) If I get a chance tonight or tomorrow, I'll try and upload it for you. It is quite large, and it's still under construction, but some of the basic features (Student Records, Enrolment, Marks, etc.) are completed, and should allow you to see how to piece together your own solution. Cheers! Matt
×
×
  • Create New...

Important Information

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

  I accept