Jump to content

Brent Durland

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Brent Durland

  • Rank
    FileMaker Developer

Profile Information

  • Title
  • Gender
  • Location
    Salt Lake City

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification

Recent Profile Visitors

1,273 profile views
  1. Brent Durland

    Card window examples

    Here are a couple examples of card windows I thought were handy, including a photo gallery and a way of editing records: http://www.filemakerforever.com/articles/127 FF_Card_Window_Techniques.fmp12
  2. Brent Durland

    cURL Sandbox

    Here's a handy tool for testing cURL requests in FileMaker. I've included some examples from Twilio, Dropbox, SendGrid and others: http://www.filemakerforever.com/articles/138 FF_cURL_Sandbox.fmp12
  3. Leverage all the advantages of Dropbox for storing your files, and keep them accessible and organized from within FileMaker! Using the Insert From URL script step in FileMaker 16 and later, it is fairly simple to integrate a FileMaker database with Dropbox. Download the demo file for some ideas on how to set this up: http://www.filemakerforever.com/articles/133 This file includes an API settings screen that helps configure CURL options, and it also creates a log record for every API call made. This is very helpful for troubleshooting API calls.
  4. Thanks, Richard. You guys publish the most comprehensive FileMaker training that I'm aware of. Keep it up!
  5. If you love FileMaker but are new to JSON, download this free educational tool and start learning! http://www.filemakerforever.com/articles/134
  6. Brent Durland

    Uninstalling Zulu

    Now they have an admin tool for restarting Zulu. Look in the install folder. In my installation it's located here: C:\Program Files\360Works Just click "Stop" and then "Start" again.
  7. Brent Durland

    Make invoice from employee time records

    You can use FileMaker's subsummary feature to help with this. Create a layout with a subsummary by activity. Then when generating the report, do a find for the relevant time entries, and then sort by activity. You can include a summary field in the subsummary part that shows a total for that activity. This can be easily done in the same file which holds the time entry table.
  8. Brent Durland

    SCGetContainer Issue

    I'm also seeing this error today, where I didn't see it last week. And I've confirmed that SCSetBaseURL returns 1 even if bogus credentials are used.
  9. I recently upgraded to SuperContainer version 2.863 from a previous 2.x version, and everything is working fine, except when I delete a file I get an error 400 message. The file gets deleted but doesn't show as deleted until the record is refreshed. Any idea how to fix this? Thanks.
  10. Brent Durland

    How To Print Web Viewer Page Mac

    Have you tried using File > Print?
  11. Brent Durland

    Report From Multiple Like Tables.

    Have you considered using one table instead of many? This would be a much simpler option. Or, if you really need multiple tables, consider importing records into a central table from there to do your reporting. This could simplify things for you tremendously.
  12. Brent Durland

    Two Or Three Tables To Relate This Excel File

    Typically in a database you'd have a table for each entity, and here you have at least two, student and course. So, one student record for John Wayne and one course record for E38. Then to track registration, you'd create another table that references both student and course. This is called a join table, and acts as a go-between so you can have many students registered for each course.
  13. Brent Durland

    Filtered Layout

    You could create separate relationships for each category. Take the relationship you're currently using and add a match for a constant on one side, with the value "adult", etc., and have it match the category on the other side. That will give you records related by family and by specific category. This can make the relationship graph a bit messy, though, so I'd first try the idea of a script trigger. For example, you could create a script triggered OnLayoutLoad (assign this in Layout Setup), and have the script constrain the found set to the desired category.
  14. Brent Durland

    simple filtering question

    It sounds like you're setting a field in the person table to "active" after performing a find, correct? And your relationship for the portal on the event screen is based on that. I would do it differently, so that you don't have to set a field in that table after you do the search. Change the relationship for the portal so that the event key field holds a return-delimited list of person record IDs, so if the event key field contains "1¶2¶3", then persons 1, 2, and 3 will show in the portal. Then, after doing the person search, set that event key field to the IDs of the found person records, either with a custom function or a looping script. Hope that helps!
  15. Brent Durland

    Email & web link within calculation

    Unfortunately, you can't disable the "clickability" of a button conditionally, but you can have the script check for the presence of an email address and behave accordingly.

Important Information

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