Brent Durland

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

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

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.

Thanks, Richard. You guys publish the most comprehensive FileMaker training that I'm aware of. Keep it up!

If you love FileMaker but are new to JSON, download this free educational tool and start learning! http://www.filemakerforever.com/articles/134

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.

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.

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.

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.

Have you tried using File > Print?

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.

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.

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.

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!

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.