• Content count

  • Joined

  • Last visited

  • Days Won


rwoods last won the day on November 11 2016

rwoods had the most liked content!

Community Reputation

7 Neutral

About rwoods

  • Rank
  • Birthday 07/09/1973

Profile Information

  • Gender
  • Location
    Nottingham, UK

Contact Methods

  • Website URL

FIleMaker Profile

  • Profile Updated
  • FM Application
    14 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
  • Certification
  • Membership
    FIleMaker Platinum Member
  • Title

Recent Profile Visitors

1,444 profile views
  1. Hi there If I were doing this, I would Perform a Script that exists in the Mutual Aid database, from the Townships database, and pass the information as a Script parameter, separated by carriage returns. So in the Townships database you do something like :- Perform Script (External Database: Mutual Aid DB ; Add Record Script ; ScriptParameter "Time¶Type Of Event¶Full Address¶Township¶ICS Officer ") and then in the Mutual Aid DB, you would have a script like this :- Add Record Script Go To Layout (Data Entry) New Record/Request Set Field ( Township ; GetValue ( Get ( ScriptParameter ) ; 4 ) ) Set Field ( Address ; GetValue ( Get ( ScriptParameter ) ; 3 ) ) Set Field ( Time Start ; GetValue ( Get ( ScriptParameter ) ; 1 ) ) etc This should give you a new record with all the data copied across. Does that help?
  2. Sorry, when I replied I hadn't noticed all the interim replies! Wim beat me to it!
  3. Ah yes, that only originated in FileMaker Pro 14, sorry! You could just change it to the following, and in line 1, edit the path to match the location of your folder. My code below assumes it is on the desktop. All that has changed is the old line 1 is deleted, and the new line 1 is modified. The other three lines are unchanged. Set Variable [ $path; Get ( DesktopPath) & "EXPORTS/serial_number.php" ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Export::serialNumber; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$path”; Character Set: “Macintosh”; Field Order: Export::export ] [ No dialog ]
  4. Hi Philip Your requirement seems very simple, so excuse me if I have missed something. Enclosed are some steps that would do the job, but there would be other ways to achieve the same thing. The first line asks the user to select their output directory, they would choose the EXPORTS directory, wherever that is held. You don't need to do anything special to skip the deleted records. Since they are not there, they will not be exported! Get Directory [ Allow Folder Creation; $path; Dialog Title: "Choose a directory"; Default Location: Get ( DesktopPath ) ] Set Variable [ $path; Value:$path & "serial_number.php" ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Export::serialNumber; ascending ] [ Restore; No dialog ] Export Records [ File Name: “$path”; Character Set: “Macintosh”; Field Order: Export::export ] [ No dialog ] I tested this on a simple file (enclosed) and I got the file requested. I would note that the file is not a valid PHP file, you would need to do some work to add HTML headers, PHP tags and all the rest of it depending on what you actually wanted to use the data for. Export.fmp12
  5. Hi nexgen By restricting access to layouts in Manage -> Security, it shouldn't affect your scripts' ability to modify the records in the associated table, unless of course you have also restricted access to the records. You say they can't 'trigger' the scripts. How are they triggering them? If it is from a button on the restricted layout then of course they can't trigger them, but I assume that is not the case? Also, you cannot copy/paste onto a layout to which they have no access, just in case you are doing that. 'Set Field' should work, so long as you are on a layout based on the correct table to which they do have access. Your script should go to a layout to which they do have access based on the correct table, makes the changes to the fields, and then switch back to the original layout (to which they do have access). That should work. Make sure you have set 'Allow User Abort' to 'Off' so they cannot interrupt the script and get access to data you don't want them to see. Maybe post an example FileMaker file and we can see what the issue is if you can't resolve it?
  6. Just wanted to agree with Wim here, calculation fields are very tempting, and often very useful, but land you in big trouble on larger solutions, especially when hosted in the cloud across WAN connections. If you have a customer record and want to display the total value of the sales for that customer, it seems natural to create a calculation field that adds-up the totals from each transaction for that customer. The trouble is that the transaction total is calculated from the total of the line items on that transaction, and the total on each line item is dependant on calculation involving quantity, item value, tax amount etc etc. You can soon get to a situation where you wait several minutes for a list view of all your customers with their total transactions. The answer in the end can come down to scrapping your calculations, and instead using 'Auto-enter calculations' to have the numbers you need stored, rather than re-calculated each time you need them. The trick then is to make sure you are triggering the update of these stored values whenever they need to change. There is some good lively banter on this subject at
  7. Hi Nexgen It sounds like you are not 'normalising' your database, but rather splitting a table in two just to help with a perceived possible performance impact? The process of normalising is usually performed when you have a number of similar entities that are all related to a single higher-level entity. Instead of having Child1Name, Child2Name, Child3Name for instance you would instead have a table of 'Children' that each relate to a single parent. If each of these children had a large image stored of them, then normalising would allow FileMaker to only download the image of the child you are interested in, rather than having to download all three images if they were all stored in the parent record. Whether or not just splitting your table in two is a good design decision is debatable, but may create you more work in the future that is not outweighed by any performance benefits. FileMaker is fairly efficient at only downloading what it needs, so you may be fixing a problem that doesn't exist.
  8. Hi Monarch You can use the Get ( TriggerTargetPanel) function to give you the index number and object name of the panel that you are switching to, and you use the OnPanelChange trigger to run a script to make use of that. I've done a simple test file for you to take a look at if that helps? TEST.fmp12
  9. Hello Your post made sense right up to the 'Field 4' part where it seemed to be missing some info. Also, the next line didn't make much sense. Could you edit your post a little and I can help! Also, is 'Last service date' supposed to mean the future last date on which service will be provided, or the most recent service date. It seems like we don't know how many services to schedule (do they get 4, 8, 12 etc etc?)
  10. AVLA and VLA required you to stipulate how many 'connections' you required from iOS or WebDirect clients, so was equally unsuitable for anonymous users or any situation where you could have an unknown number of users online at any given time. You can of course just buy say, 25 connections, and hope that this is enough, but if you have 'burst' situations where lots of anonymous users come online at the same time, it will give you problems. Also, these 'connection' licenses tripled in price with the advent of FileMaker Licensing for Teams. Calling the FMI Sales team and they'll advise you open the best course.
  11. Hi There The new FileMaker Licensing for Teams model is not really suitable for 'anonymous' logins via WebDirect since you have a fixed number of licenses. That licensing model is designed for teams who have a known number of members. The 'legacy' licensing model (previously known as AVLA or VLA) is not much better for your use-case, since you still have to stipulate a number of users. I would suggest that if you want to use FileMaker (and who wouldn't!) you could use custom web publishing & PHP to access and manipulate your data. It can be tricky to debug when you first start using it, but it is very straightforward so long as you have someone who can design the HTML for you. It does not rely on the number of licenses you have, and so long as your server is fast enough there is no practical limit on the number of simultaneous users. FileMaker 16 will bring new API access to your server data according to their roadmap, and I'm sure CWP using PHP will be deprecated at some point in the future, so you may want to wait for that version and see if it suits you better. You could call your local FileMaker sales team and run your scenario past them, as they sometimes have ideas on how to fit their license model to suit your needs. Hope that helps.
  12. Hello, thanks for your question. Users can select one option from a list if you present it as 'radio buttons', or multiple items if you present 'checkboxes' or a 'popup list'. Maybe you could have a look at the built in documentation, for instance
  13. You can use 'Perform Script on Server', and have the plug-in installed on the server, to get around the fact that FM Go does not support plug-ins. Or you could wait for FM 16 since FMI's roadmap shows built-in support for the commands that you are currently relying on the plug-in for. They say they will include 'Enhanced cURL options — Provides cURL options to configure HTTP/HTTPS calls that work with REST APIs.' in the next version.
  14. Sorry, I realise my answer was a bit 'brief', trying to be helpful in a hurry! If you google 'Filemaker Xero Examples' there is loads of content posted by the community. You could try the chargeable plugin by Foundation Data at if you want some pre-built functionality (rather than doing it yourself with the API). Or there are various YouTube videos with examples, you could look at It's been done many times before, so there are lots of examples and resources. Good luck!
  15. Hi John You would need to interact with Xero using their developer API. You can find this at Whilst FileMaker 15 has limited tools for communicating with RESTful APIs it can be done using PlugIns.