Jump to content

Darren Emery

Members
  • Content Count

    129
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Darren Emery

  • Rank
    In-house FM expert. Reality: just getting started!
  • Birthday 10/19/1966

Profile Information

  • Gender
    Male
  • Location
    Manhattan, KS
  • Interests
    Faith, Family, Fitness. Reading, Writing, Learning. All things tech, esp. audio and video.

Contact Methods

  • Website URL
    http://www.cityofmhk.com
  1. Darren Emery

    Odd layout crash issue

    I have a layout that crashes every time we try to open it, but only the first time of the day. If we open it once and allow it to crash, then open Filemaker again, usually on either the second or third try, the layout opens fine, and works well the rest of the day, unless we shut down FM and restart. This seems VERY odd to me - any ideas? Don't really have any idea where to begin to troubleshoot this one. I do get error messages on windows event viewer - but I cannot decipher the language. Image is attached of these error codes. Any help would be GREATLY appreciated! Darren
  2. Darren Emery

    Get(Device) - what am I missing?

    It seems to be working now - I didn't change a thing, but about 30 minutes later, it is now functioning on the iPad as I had intended.... this is odd! Thanks Comment for your input.
  3. Darren Emery

    Get(Device) - what am I missing?

    Yeah - that was an error in posting, not in the script. The second two pics were NOT supposed to be there. The script reads as in the first image... 3 for iPad. Still no go
  4. I've been working on this much longer than I should - I must be missing something simple. I have this script set to run on first window open - would like to be taken to an ipad specific layout. Any idea what I'm missing here?
  5. Darren Emery

    Summary of a sub-summary?

    Every once in a while I come up against an issue that reminds me how little I really know about Filemaker. Creating summary reports is often the issue. I think what I want to do is possible, but I'm stumped. We track violations by address. Every time a violation is found at an address, and new record is created. I would like to create a report that tells us how many times an address is cited once, twice, three times, etc. in a given time frame. I can pretty easily create the summary report that groups by address, and then tells me how many times that address is cited. I need to take it one further step. In a given year, we might have 2k violations. The vast majority of these are one time per address. The report I'm trying to generate would tell me: Number of single violations per address: 1,937 Number 2x violations per address: 47 Number of 3x violations per address: 14 etc. This seems like a summary of a summary. Is this possible?
  6. Good idea Wim - I'll give that a try. Simple, and hopefully effective!
  7. I seem to recall finding a suggestion on this issue before, but cannot figure out what to search for! I have a very brief script that updates today's schedule for my inspectors. If there is no change in their schedule, there's no way to know for sure the script ran. I'd like to flash the screen, or in some manner indicate the script has run. Ideas?
  8. Darren Emery

    Import .csv record only if NO Match is found

    LaRetta - Fantastic! Validation worked perfectly, and so simple. Thank you!!!! BTW - I have the import set to perform without dialog, so the error message does not show to indicate failed import - it just doesn't import.
  9. I am creating an import feature for a web form that generates a csv file. I can't count on the user to always select the correct files to import, so I need to find a way to check for a matching record, and NOT import if a match exists. There is a unique ID# generated for each form submitted as a csv file. I also need to allow auto-enter functions so that a field is set to a particular value on the destination file. I would like to limit user input as much as possible, and script as much of this import as possible, but the schema and logic is escaping me at this time. Any suggestions?
  10. Darren Emery

    Text wrap glitch?

    Additional info: the 28 wraps to second line on any mag level other than 100
  11. Darren Emery

    Text wrap glitch?

    I have a screen size guide that I have new users open so I can quickly get a feel for how much screen real estate they have to work with. I had what appears to me to be a glitch show up yesterday. The text wrapped from far right to a second row - and I can recreate this issue by changing the magnification level to 75%. Any idea why text would automatically wrap to a second line?
  12. I am taking a new look at how I build in email functionality, and I have created a system that seems to be working well, but I wonder if I'm missing something, if there is a better way, or if I may be painting myself into a corner for expandability down the road. Would appreciate any feedback. I am using SMTP rather than client due to all the challenges we have faced in the past with Outlook/Windows upgrades. A key feature is that I need the outgoing emails to be from whomever is using the FM system, so that reply emails go directly to my user, rather than a generic email account. I accomplished this by creating a table where I store the FM user account name and the associated email. I also created a global calculation field that holds current account name via Get(account name) I related the email table to the original table (zoning, for future reference) via the global calc field which has the current user account. Then the outbound email grabs the email for the "to" field via this relationship. One thing I can quite figure out - the global calc field to Get(account name) does not display the name, but this system still works. If I turn global storage off, it displays my account name, but I need this to be a global field, so I have a unique value for each user. I know this is a pretty broad based question, but I don't know enough about this to know the right questions to ask!
  13. Darren Emery

    Send Mail not working - Microsoft Outlook

    James - I wondered if it might be a 64/32 issue. Thanks for the input!
  14. Darren Emery

    Send Mail not working - Microsoft Outlook

    A few years ago I abandoned Send Mail via client when FM and MS Outlook refused to get along after an update. I had a dozen or so automated emails that failed when we upgraded, and rather than fight the battle, I switched to SMTP. I am currently creating a new solution, ground up, for a client, and sending email via Outlook is preferred. Does anyone know why Outlook has so much trouble with Send Mail? Specifically, when I run the Send Mail button function, an email form is opened, but the system will not copy the email address from a field on Filemaker to the "To" field on the email form. Information will transfer to the subject and body of the email, but not the address lines. Anyone deal with this issue successfully?
  15. Darren Emery

    Hosted DB not viewable by "open remote"

    Got it - user error. When I created this DB, I failed to add my account name as full access. It was hosted with only the default "Admin" full access account, and when I tried to open remote using my account rather than admin,the files were hidden. Rookie mistake...
×

Important Information

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