Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RyanESmith7

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

2,560 profile views
  1. 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?
  2. xslt for QuickBooks xml

    The specific part is if this still applies to QBXML or has Intuit changed QuickBooks' XML format over the years
  3. xslt for QuickBooks xml

    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.
  4. xslt for QuickBooks xml

    I just ran across this and I'm wondering if it is relevant 14 years later. LOL
  5. Laptop / Windows 10 / 4k rss display issue

    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.
  6. 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
  7. 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
  8. Find the week before calculation

    Sorry for the late reply, Comment, but thank you... that worked!
  9. Find the week before calculation

    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 I'm trying to figure out the WeekStart of the record before. Thanks for spending so much time trying to understand me... sometimes it's hard for me to convey my issues in writing.
  10. Find the week before calculation

    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 my calculated field "PrevWeekStart" be more dynamic. A Client will log for anywhere from 6-36 weeks of data, so I'd like to find the previous WeeklyLog record that the client had (in date order) rather than just assume it was 7 days prior. This scenario works: Record 1, WeekStart = 10/1/16 Record 2, WeekStart = 10/8/16 This scenario does not work: Record 1, WeekStart = 10/1/16 Record 2, WeekStart = 10/9/16
  11. 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!
  12. WebDirect Connection Issues

    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.
  13. WebDirect Connection Issues

    "The spinning wheel of death" as my users are starting to call it, is back. Any other ideas out there? It consistently happens with Safari. Chrome is a little better.
  14. Perform Find on a Calculated Field

    Confirmed. Downloaded one of the DBs to my local PC and the code works there. Doesn't work on hosted.

Important Information

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