• 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
    15 Advanced
  • Platform
    Mac OS Sierra
  • Skill Level
  • Certification
  • Membership
    FIleMaker Platinum Member
  • Title

Recent Profile Visitors

1,769 profile views
  1. Hi there You are pretty close in what you describe already, you just need to setup the relationship exactly as you describe, then create a calc field in table A to summarise the result. Since the advent of ExecuteSQL most expert developers would use an SQL statement to get the result you need without using a relationship on the graph. Often we try to reserve relationships on the graph for the data connections and to show portals, rather than to perform summary's in this way, but for smaller and simpler solutions, it is perfectly fine. I've enclosed an example file if that helps and a screenshot of the results. I just created two FileMaker windows to show both tables side by side. Example.fmp12
  2. Hi there, the link to the file doesn't work, can you try again please?
  3. Yes indeed CWP does get round all of that, as it doesn't count as a 'connection' when a web page requests info from your FileMaker data using CWP. However, FileMaker will surely deprecate and cease supporting XML and PHP CWP within a few years, and it's not supported in FM Cloud, so I'm not sure I would embark on a big development project using those technologies right now. The new Rest API model for communicating with FileMaker Server is 'the future' but I would suggest that a chargeable licensing model for that will come one day, and currently it is missing lots of useful features, not least of which is being able to run a FileMaker script.
  4. I agree with Wim. The real problem is that FileMaker do not have a licensing model suitable for 'anonymous' users, especially if there are likely to be many of those on at any given time. You have to pay for each concurrent connection that you wish to allow, and this is the legacy licensing model. FileMaker Licensing for Teams only goes up to 100 users, but is not designed for anonymous users, users must work for the named company. In the UK on legacy licensing FM Server 16 + 100 connections is £19,798 + VAT (20%) per year, it's about £195 + VAT per concurrent user per year plus the base cost of the server. This is approximately 3 times the cost that it was per connection pre-FileMaker 15, and this is because 'connections' can now be used for FM Pro (for user connections), Go and WebDirect, whereas they used to be for Go and WebDirect only. You could buy more than 100 connections on the legacy model, you'd have to contact FileMaker sales for that (or a reseller) but the price won't go down per connection very much. For companies with many internal users they have the site license available which has a low price per user (and allows unlimited connections and installations up to the limits of the server), but that is for use only by employees of that company, not anonymous users. FM licensing does not suit multiple anonymous users really, and that does lead some customers to different platforms.
  5. Hello Your calculation IS boolean, and your field will hide when either Company__lxt is not equal to 'US' or when BOTH that same field is empty AND the CountryAbbreviated__gxt is not equal to 'US' So I guess it is a field that should only show for 'US' companies, and not show for international companies? If it is not performing the way you want, then perhaps the logic is wrong within it?
  6. Hi There You can indeed do that and it will host the iPad users just fine. Bear in mind that FM Pro is not optimised for sharing files (unlike FileMaker Server), and you will have to quit FM Pro on the Mac mini each time you want to backup the files. The performance for light use should be OK though. Don't let Time Machine backup the files as they will not be valid backups.
  7. Silly suggestion maybe, but could you try FM15, since Windows 10 did not exist when FM14 was released?
  8. Ah yes, comment is correct, that would be a better way to determine if the record is on it's own in a SubSummary group. However, making any of this happen in browse mode is impossible, sliding objects only work when printed/PDF'ed
  9. Hi Tattwam Firstly, I strongly recommend that you just live with the fact that both the sub-summary and the line item show. It will make you life much easier as that is how FileMaker is designed to work. However... The first way I can think of to do this would be to use the sliding features of FileMaker, along with the 'Also reduce the size of the enclosing part'. You would need to make the fields that show on the body be calculated fields, and they should evaluate to nothing (i.e. "") when that item is the only one that matches that sub-summary field in the found set. That isn't easy, but could be achieved by doing a PatternCount of the SubSummary field contents on a list that is calculated from the sub-summary field in the found set. If the PatternCount is '1', then it is the only record that matches, and the calculated field should be "" If you setup the parts in the body to slide upwards and reduce the size of the enclosing part, then the body can be made to reduce to almost nothing. It would be fiddly to set all this up, hence my recommendation not to bother, and just live with the native behaviour!
  10. Ah yes, nice one ggt667, had forgotten about that little cheeky option. Probably better than my idea.
  11. Hi Andrew You can set OnObjectModify (and OnObjectKeystroke if you like) Script Triggers on the fields that you want to lock, to run a script along the lines of the below. That will reject the input if the $$lockvariable is set to 0 If [ $$lockvariable = "0" ] Exit Script [ Result: 0 ] End If As an extension, in one of our solutions we show an error panel, that is just a rectangle with some text in it that is the frontmost layer of the layout, and we use an OnTimer script to hide it after a couple of seconds. This explains to the user why their input is not appearing, but doesn't require them to acknowledge it. If [ $$lockvariable = 0 ] Set Variable [ $$showInputError; Value:"Y" ] // the $$showInputError variable is used to show/hide the rectangle with text in it Install OnTimer Script [ “Clear Input error”; Interval: 2 ] // this script sets $$showInputError back to 'N' after 2 seconds, which hides the rectangle again Refresh Window Exit Script [ Result: 0 ] End If The 'Clear Input Error' script needs to both change the variable $showInputError back to "N" and stop the OnTimer script otherwise it keeps running every 2 seconds. That script looks like this. Set Variable [ $$showInputError; Value:"N" ] Refresh Window Install OnTimer Script [ ] Hope that helps
  12. Hi Freesia I'm sure the idea is that you learn how to do it yourself, rather than getting someone else to do it for you (at least that's how I remember school, though it was 28 years ago!) If you have the start of a database then we could give you some guidance on the last few steps if you have given it a go. You could post the database here. I'd start with just one table, with maybe an primary key (ID), a date field for the invoice date, and a value (number) field for the invoice value. You could then add a simple script that does a find on a date range, and then sorts the results.
  13. Hi Adrian You can't have two column portals I'm afraid, and it would be fairly complex to achieve that. I would suggest working with the single column, and just add a vertical scroll bar to the portal, and make each row smaller. You could duplicate the portal and do something crude like filter the first portal to show only people who's surname begins A-M, and the second portal to show N-Z. I've enclosed an example of that. Checksys.fmp12
  14. Hi Adrian I tweaked your file to give it the functionality you are after. One way of doing it is to have a table of 'Staff', and that need to be related in some way to your 'Menu' table with the global where you select staff names. Have a look for the following in the enclosed file :- New Staff Table Two relationships from the 'Menu' table to that staff table. One that matches whatever you have selected in the global popup menu, and one that shows all staff (using a cartesian join) Changed your value list to show the list of all staff in the staff table Added a new script that toggles whether a staff member is in or out Replaced your two buttons with one, that changes it's meaning, text and colour depending on whether the chosen staff member is in or out Added a portal to your 'Status' tab to show all staff and their current status. Hope it helps move you along! Checksys.fmp12
  15. Hello You could get the values from your value list using GetValueListItems and then go through a loop creating new records and taking the next value from the list of values to set for each new record. This way, it would be more flexible in the future as you could just change the value list if your appointment slots changed, and the script would continue to work without modification. I've done a little sample file to show you what I mean. Try running the script within, and it will create new records from the value list. Value