Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RyanESmith7

  • Rank

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

3,540 profile views
  1. I figured it out! The Base64Decode function needs a filename with proper extension for image files. For anyone trying to crack the UPS api, here's how you get your label out: Set Variable [$json_gif; Value: JSONGetElement ( $json_gif; "ShipmentResponse.ShipmentResults.PackageResults.ShippingLabel.GraphicImage") ] Set Field [MyTable::MyContainerField; Base64Decode( $json_gif; "label.gif" ) ] Enjoy, Ryan
  2. Thanks, ggt... 1, 3 and 4 are definitely possible, it is step 2 that I am struggling with.
  3. I am getting a JSON response back from the UPS API that returns the shipping label in GIF format. I would love to display that as an image (and even print it), but none of the decode functions seem to do the right thing. Here is the JSON: (note the key for the GIF is ShipmentResponse.ShipmentResults.PackageResults.ShippingLabel.GraphicImage How do I get that GIF to display as an image in FileMaker? Thanks, Ryan {"ShipmentResponse":{"Response":{"ResponseStatus":{"Code":"1", "Description":"Success"}, "TransactionReference":""}, "ShipmentResults":{"ShipmentCharges":{"Tran
  4. FM16 is out and it looks like there are some very good improvements for Web Direct, but I'm not finding a lot of info on licensing. Have there been any improvements in the licensing for high user count Web Direct users?
  5. The specific part is if this still applies to QBXML or has Intuit changed QuickBooks' XML format over the years
  6. Thanks, comment. I'm trying to import/process/parse some similar XML data from QB and this whole thread has been very enlightening. I've been investigating on how to parse this XML data for far too long.
  7. I just ran across this and I'm wondering if it is relevant 14 years later. LOL
  8. Not silly at all, because I will try that. But I'm hoping to stick with 14 as we haven't done any testing with our database on 15.
  9. We have a newer Dell laptop that is having display issues with FileMaker Pro 14 running on Windows 10. It is a very high resolution monitor with the DPI defaulted to 250%. As you can see from the attached pic, every layout comes out partially displayed. As you move your mouse over the fields and the buttons, they become displayed. I tried taking the DPI down to 100 and decreasing the resolution, but that didn't fix it. I've tried 32-bit and 64-bit of FM14. I have tried Windows 7 and Windows 8 compatibility for DPI and scaling. Nothing seems to fix this. Any ideas? Thanks, Ryan
  10. I don't know why I struggle with this. I'm doing a series of finds on a list layout, and after I've filtered everything else, I want to filter OUT Private tasks Not assigned to the current user. Something like this: But we ALL know that <> is not a valid "not equal to" symbol for FileMaker. What's the best way to go about this? Thanks
  11. Sorry for the late reply, Comment, but thank you... that worked!
  12. Yes, I am looking for a relationship, not a find. My apologies for the confusion. I can't use the first day of the week because the client can start their tracking on any day of the week they want AND they can even skip weeks of tracking on occasion. So I'm not actually looking for Sunday, I want the record (from the same table, via table occurrence) that is just before this record. For example, I would want it to return something like this: My current calculation is correct except for that RED one in the example above. Because the user skipped 15 days between logging. So
  13. Sorry, I should explain further... Table: WeeklyLog WeekStart(Date Field) PrevWeekStart (Calculated Field, returns Date, Calculation = WeekStart-7) Then I have a table occurence PreviousWeekLog_TO that is setup like this: Then on one of my report layouts I do some calculations between the two tables to show changes from week to week in the data. This works perfectly when the two weeks are 7 days apart, which is 90-95% percent of the time. However, sometimes a client will start a new WeeklyLog 8-n days after the PreviousWeekLog->WeekStart. What I would like to do is make
  14. I have a table that is a log of weekly records, and when I'm presenting the current record, I need to be able to pull data from the week before, so I'm currently using a calculated field with a reference to This Week Start Date - 7. But every now and then, the weeks are not a week apart. So what's the best way to find the Previous Week Start Date when it isn't an exact 7 day match? Thanks!
  15. It seems to be. I only have one device to test with on Saf 9. Many of my customers have already updated to 10, already.
  • Create New...

Important Information

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