Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


rwoods last won the day on November 11 2016

rwoods had the most liked content!

Community Reputation

8 Neutral

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

Recent Profile Visitors

1,950 profile views
  1. Scrollable Text Fields (without entering to edit)

    Hi There This has been asked many times before, and is a tricky one. The built-in FM functionality makes it difficult. You can use a an OnObjectModify script trigger on a modifiable field, and just reject the keyboard input with a script if the user is not permitted to enter text. However, you can still copy/paste into the field I have found using this technique. The web viewer technique you mention is a popular one. Maybe someone else has a better idea, but I have wrestled with this a few times and never been too satisfied.
  2. Reporting a string of child relationships

    In my experience, if you want to use sliding then you have to base the reporting layout on the entity that has varying amounts of data. In the case you describe, that is exactly what you are doing. However, it sounds like you are trying to create a report of 'rooms', rather than of 'equipment', hence you are correct that creating an 'Empty' or 'Dummy' piece of equipment for rooms that have no equipment seems like the best option. Is there actually a problem with that method? It could be that you have the solution already. I can't think of a better way to solve your problem, since as you say, portal rows are of a fixed size, and I don't know of a way around that. Maybe someone else has solved this problem a different way, I'm sure they will contribute if so!
  3. Quick portal filter question

    I'd agree with Steve. you probably want Let ( [ indexValues = List ( TEACHER::_kplt_TeacherID ) ; searchValues = List ( TEACHER::Name_LF__lct ) ; index = ValueCount ( Left ( indexValues ; Position ( ¶ & indexValues & ¶ ; ¶ & TEACHER_X::_kplt_TeacherID & ¶ ; 1 ; 1 ) ) ) ; prevValues = LeftValues ( searchValues ; index -1 ) ] ; IsEmpty ( FilterValues ( TEACHER_X::Name_LF__lct ; prevValues ) ) ) and ( Status__lxt = "ACTIVE" ) Does that work OK for you?
  4. Restricting data by month

    You could create a script that does the 'Find' that you require, and restricts the number of records. Something like :- Set Variable [ $startOfMonth; Value:Date ( Month ( Get ( CurrentDate ) ) ; 1 ; Year ( Get ( CurrentDate ) ) ) ] Perform Find [ Specified Find Requests: Find Records; Criteria: Invoice::date: “≥$startofMonth” ] [ Restore ] Then you should add a script trigger to your layout using the 'OnLayoutEnter' option, that runs your script from above. This is quite crude, and would perform this find every time you enter that layout so you may need to refine it, but this would give you a starting point.
  5. Hi Charity FileMaker fetches data as it needs it, and it's beyond the scope of most developers to understand how the internal database engine works, and when data is fetched. You don't need to tell FileMaker when to fetch data. If you display a field in a tab on a form view, or in a column in a table view, then FileMaker will fetch and show the data. When it does fetch the data, it will be downloading from the server, or wherever the file is physically located. Usually we don't worry about it too much (as we have little control over it), but if you have very large images stored in the database, or are paying for data transfer (such as when using FileMaker Cloud), or even when using WebDirect where performance is a big consideration, it can be worth considering. If you could explain why it is important to you, perhaps we could give a bit more detail?
  6. 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
  7. Go to Related Record in Portal broken

    Hi there, the link to the file doesn't work, can you try again please?
  8. Newbie license question

    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.
  9. Newbie license question

    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.
  10. 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?
  11. FM15 on Mac Mini

    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.
  12. Silly suggestion maybe, but could you try FM15, since Windows 10 did not exist when FM14 was released?
  13. 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
  14. 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!
  15. Check-in/out

    Ah yes, nice one ggt667, had forgotten about that little cheeky option. Probably better than my idea.

Important Information

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