Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About DanShockley

  • Rank

Profile Information

  • Title
  • Industry
  • Gender
    Not Telling
  • Location
    New York, NY

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Rather than having a Count calculation field, I'd definitely recommend having a field named something like zFoundCount (in every table). Define it as an explicitly NON-stored calculation equal to: Get ( FoundCount ) That field, as La Retta mentioned above, will know in what context it is being called. So, if you put it in a portal, filtered or not, it will show the number of records in that portal. It also has the advantage of not requiring the reading of the record content in the same way that a calculation field that Counts a data field in the table does. Read this article (
  2. Here is the bug report and discussion on this long-standing FileMaker bug. https://community.filemaker.com/thread/133594 Please don't say "problem solved" when there is a bug that prevents people from doing very typical work behavior. Mac and Windows both allow non-file-extension-preceding periods/dots in file name, and most apps work properly, unless that app has a bug. Users should be able to rename files, unless you are saying FileMaker should only be used in very controlled corporate environments. In that case, FileMaker Inc. will need to adjust their priorities in what features
  3. If you have FileMaker Server Advanced, you could use Custom Web Publishing to create a PHP form that saves submitted data into a FileMaker table.
  4. I agree that inserting one row at a time is a good idea, but you also have a syntax problem. The SQL INSERT syntax is this: INSERT INTO table_name VALUES (value1,value2,value3,...) Or, if also specifying the columns to insert into, as you want: INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...) Your example had the command "SELECT" instead of the command "VALUES" - that might have been the problem. Of course, as you noted, exporting and importing can be pretty fast. There are downsides to that process (stability, control over specific errors, etc.), bu
  5. Apart from the conversation about what to do with recovered files, it would be great if Sarah (aka "Kansas") could give us the info LaRetta requested. One possibility might be that the computer from which the record was created has clock issues, as someone mentioned. There are ways to avoid that, if the database is hosted, using an auto-enter calc: GetAsDate ( Get ( CurrentHostTimestamp ) )
  6. I had this problem today. Quitting FileMaker and relaunching it did not solve the problem. Just to address those who think it's a scripting issue, it failed when I had a button directly running a Show Custom Dialog with Get ( ActiveModifierKeys ) displaying in the dialog - it showed 0. Restarting my Mac fixed the problem. Not sure how or why.
  7. If you really want search-and-replace within scripts, you can use code that modifies the XML in the clipboard. I've built a useful (but potentially dangerous!) AppleScript tool for searching and replacing within FileMaker objects (not just script steps) in the clipboard, and have shared it on GitHub. https://github.com/DanShockley/FmClipTools NOTE: This is Mac-only, since it uses AppleScript. Also, you can definitely cause problems for yourself if you aren't careful: the search-and-replace can easily replace something that wouldn't normally be user-facing (it runs on the ENTIRE block of XM
  8. I'm almost certain 'comment' is correct. If your system runs a DDR on some kind of schedule, you could set up something to parse the XML generated for "Field" nodes whose "AutoEnter" sub-node has the attribute "overwriteExisting"=True. Are you doing this to be able to automate some kind of backup/export/data-transfer process? If you say more about why are trying to do this, there may be other possibilities.
  9. It sounds like the infamous automatic URL encoding bug in Insert From URL. In your sample URI, you have properly already encoded special characters. Unfortunately, the Insert From URL is then double-encoding certain characters like the percent symbol, so the service is getting mangled values for those parameters. Here's what it is probably sending (notice your % are now %25): https://api-ssl.bitly.com/v3/user/link_save?access_token=my_api_key&format=xml&title=Baillieu%2520 Print%2520Collection%253A%25200000.1067.000.000&longUrl=http%253A%252F%252Fgallery.its.unimelb.edu.au%252
  10. Yes. He did. His URL (1) shows a properly-encoded %2B. What happens is that the script step silently UN-encoded that into a + when it is sent to the server.
  11. I would definitely classify automatic encoding with no option to turn it off as a bug. Here's an example of where the automatic encoding behavior makes it impossible to submit a search string to a PHP page that includes a leading equals sign to do a search similar to that done in FileMaker (exact word match): If you are crafting a URL that has key-value pairs and the value for one of them needs to be "=Bob" (without the quotes) for example, you cannot submit that. So, your URL would look like this: http://server.example.com/search.php?FirstName=%3DBob That would result in the PHP doin
  12. There is a very useful option when you run the script step "Insert File" - you can choose the "Compress" checkbox to store the file compressed. Helpfully, FileMaker shows the icon and filename of the file in that container without any indication that it is compressed, but there is a lot less data being stored in the database (or external on the server ) and there is less data to transfer over a WAN or otherwise slow network. If you then choose to "Export Field Contents" of that container field, FileMaker silently decompresses that data to export the original file. Having looked at what is stor
  13. Nice little example of scripting a folder import. On a side comment: to get the parent folder path of the item, it might be helpful to use a custom function like this: // FileParentFolderPath ( somePath; pathDelim ) // version 1.2, Daniel A. Shockley // Returns the path to the parent folder of the given path, using the specified directory delimiter. /* VERSION HISTORY 1.2 - if no path delimiter is specified, use a normal forward slash. 1.1 - rewrote to take advantage of much simpler method */ Let ( [ pathDelim = If ( IsEmpty ( pathDelim ); "/"; pathDelim ) ]; Left ( somePath;
  14. In your Personnel table, assuming that table already has a Full Name calc field and the Current Employee Value field is a Number field with a 1 for active employees, create a calc field named Full Name Current with the following calc: If ( Current Employee Value ; Full Name ; "" ) Then, have your Current Employee Names value list use that calculated field as the second field (with Employee ID# as the first field for the value list) and sort on that second field, instead of the normal Full Name field that has a value for every record. Use all values - no need to have the value list de
  15. One possibility would be to put FileMaker Go 12 (actually, 13 at this point, since 12 is no longer available either) on your iOS devices while keeping FileMaker 11 on your server and Mac/Windows clients. Then, you could use something like RESTfmSync to transfer data between a local-to-the-device FM 13 database and the server. Since RESTfmSync uses the Custom PHP interface, it doesn't matter that the FileMaker versions are different. So, it's possible, but might be difficult. Remember that the iOS devices would then not be working with live data (that can be good and bad), and you have to
  • Create New...

Important Information

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