Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


rwoods last won the day on January 6

rwoods had the most liked content!

Community Reputation

25 Excellent

1 Follower

About rwoods

  • Rank
  • Birthday 07/09/1973

Profile Information

  • Title
  • Gender
  • Location
    Nottingham, UK

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    OS X 10.12 Sierra

FileMaker Partner

  • Certification
  • Membership
    FileMaker Business Alliance
    FIleMaker Platinum Member

Recent Profile Visitors

3,742 profile views
  1. I've had to do this for two FM Cloud 16 instances, seems like there is a bug which just prevents login for these older versions. Upgrading the FM Cloud instance (whilst you can still login) resolves the issue, but once you have the issue, you have to do as they ask. They need RDP access to the instance and the private key. It pretty embarrassing for them really, and it takes over 24 hours to resolve in my experience.
  2. Hello This is a tricky one, but I think could be improved by design in the database. FM will only attempt to locate the other files if it needs to. You could have layouts for use in FM Go that don't have any fields, references or scripts that require the other databases. Then FM Go won't bother to open them if it never needs the data. The other technique might be to use Global Variables in the Manage->External Data Sources. In your startup script you could set those Globals to the correct values if you are on a computer, and set them to nothing if you are running in iOS. This would prevent Filemaker from looking for them. However, if your database relies on values from the other files for calculated fields or layout items that you need to display on iOS then both of these techniques will have the effect of reducing functionality in your database. Maybe that helps?
  3. rwoods

    pc fmgo

    Hello If your potential clients need to use the features of FileMaker then they must buy FileMaker! This is the business model of FileMaker. It wouldn't make any sense to allow organisations or individuals to use the features of the software for free. Now of course, the most sensible way to provide inexpensive access to your solution for your clients on Mac OS X or Windows PC's would be to host it on a Filemaker Server and allow them to access the solution with WebDirect. The best kind of license for you to obtain for your server would be an SBA license, which grants you the ability to host a vertical market solution which multiple different organisations access. It is a lower cost per user to you than a standard FileMaker Server/User license, and avoids the normal contractual terms that stipulate you can only allow members of your direct organisation (and subcontractors) to access your Filemaker Server. You will need to be (or to buy from) an FBA partner to get an SBA license and FileMaker have to see your solution first to ensure it is secure and compliant. I don't believe that you can give your clients copies of the FileMaker Pro app under this type of SBA license, I believe they would have to use WebDirect, but you may wish to check with FileMaker on that. I hope this helps.
  4. In addition to this, you can use... GetContainerAttribute (containerFieldName ; "filename") ...in a calculated field to have the file name of the file in your container field available for export. And you can also use... Base64Encode (containerFieldName) ...in another calculation field (or auto-enter calc) to encode your file that is in a container as plain text, which means you can then export it in a CSV file. If your web site can decode this data (which is pretty straightforward) then you could display the actual file on your site, particularly if it is an image. Hope that is of some help.
  5. Thanks Comment, that did the trick!
  6. Hello I am integrating with Apple's GSX API's, and one of the functions allows you to download a PDF of a 'DepotShippingLabel' which we need to send faulty parts off to Apple. The data is sent as an application/octet-stream. I have tried saving that data into a FileMaker field, and then using 'Export Field Contents' to a path that resolved to Get ( DesktopPath) & "mypdf.pdf" However, the resulting file is not recognised by Preview or Acrobat. Does anyone know how I can convert this type of data into a usable file using Filemaker (or an custom/plugin functions)? I can't post the whole data here as it contains sensitive data, but below is the beginning and end of it, just so you can see what sort of data I am being given by Apple. It is just plain text that I have moved into a text field. JVBERi0xLjQKJeLjz9MKNCAwIG9 <lotsOfDataRemoved> k+PgpzdGFydHhyZWYKMjQwOQolJUVPRgo= Any hints or tips would be appreciated!
  7. rwoods

    Record navigation

    Hello Firstly, you really need to get rid of the slashes in your table names. Call them 'Customer_Aircraft' or something, but you must get rid of the slashes. They will cause you untold misery at some point. As a rule don't use spaces or special characters in table names, layout names, table occurrence names or field names. Underscores are OK ( _ ), but avoid most other non-alphanumeric characters. To your issue, in line 4 you need it to be Set Field [Customer/Aircraft::Owner/Operator ; $$SetCustomer ] The way you have it now, you are setting the field to nothing.
  8. rwoods

    Filter contents of drop down

    Hi Gismo To do this you could create a relationship from the invoice table to the customer table that is only true if the customer is active. I don't know how you show a customer to be 'active' but a relationship from a field in invoices that is always say 'Active' to a field in customers that says 'Active' would do it. Use an auto-enter calc in the invoice table to set that constant value to always be 'Active'. Don't forget to force that value in for all existing invoices. Then base a value list in invoices on that relationship, and you will only see active customers.
  9. @comment Well, I'm not 100% sure how the implicit type-casting works with FM variables, so I was just ramming home the point to FileMaker that this was definitely a date!
  10. You should base your loops on actual dates, rather than just an index number. Why not set a variable $date to $date = GetAsDate ( Date ($month1, 1, gYear ) ) Then have a single loop that increments $startDate by one each time, tests if it is a Sunday, does it's creation if it is, and exits the loop when Month($date) = $month1 + 2 (i.e. it has reached the month that is two months after the start month). Remember to exit the loop before testing whether that last date is a Sunday. There are probably better ways to do this anyway, like finding the first date that is a Sunday and then just adding 7 to it repeatedly to find subsequent Sundays, and stopping when you reach Month 3. Hope this helps.
  11. rwoods

    JSON - SetElement Help!

    Hello Just looking at the documentation it says :- You can set multiple elements by providing an additional set of keyOrIndexOrPath, value, and type parameters in brackets [ ] for each element. The following syntax sets N elements at once: JSONSetElement ( json ; [ keyOrIndexOrPath1 ; value1 ; type1 ] ; [ keyOrIndexOrPath2 ; value2 ; type2 ] ; ... [ keyOrIndexOrPathN ; valueN ; typeN ] ) Does that help Exactly! We over-lapped there....
  12. rwoods

    Send Mail will not allow two (2) attachments

    Hi There The ability to send mail with two attachments was added in FileMaker 17, up to that point you can only send one attachment with FM's built-in script steps. You may be able to use a plug-in (MonkeyBreadSoftware or BaseElements) to send multiple attachment in FileMaker 12.
  13. Good point @OlgerDiekstra It certainly needs the decimal delimiter in the Filter list!
  14. Hi Eli I know someone will have a better answer than this, but my thoughts would be 1) Make the field type be 'number' and use the fields options validation set to 'Strict Data Type = Numeric' 2) If the field has to be a text field, but you want to check that it is numeric, the you could do something like :- FieldIsNumber = If ( Filter ( numberField ; "0123456789" ) = numberField ; 1 ; 0 ) This Boolean result would be 1 if the field only contained numerals. It would give a positive result for '01234', but this may be OK.
  15. rwoods

    What iPad will you recommend?

    Morning The iPad mini 4 is similar in speed to the iPad Air 2. The iPad Air 2 was replaced by the full-sized (9.7") iPad (5th Gen) and more recently by the iPad (6th Gen). So while the mini 4 is a fine device, you would be much better served by the cheaper and faster iPad (6th Gen). I would suggest testing your app with a mini 4 if you want to use a small form factor device, and see how it goes!

Important Information

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