Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Matt_'s Achievements


Contributor (5/14)

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

Recent Badges



  1. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. That would likely work, good thinking! I'll give it a shot. Thanks again, Matt
  15. 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).
  • Create New...

Important Information

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