Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


rwoods last won the day on July 13

rwoods had the most liked content!

Community Reputation

28 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

Platform Environment

  • OS Platform
  • OS Version
    OS X 10.14 Mojave

FileMaker Partner

  • Certification
  • Membership
    FileMaker Business Alliance
    FIleMaker Platinum Member

Recent Profile Visitors

4,158 profile views
  1. Hello Not sure if you have tested this at all, but my understanding is that so long as those file references in your other files are not called (i.e. you are not a on a layout that shows data from them, and not calling scripts that use them), then FileMaker will not attempt to open them. Therefore, so long as you set the global variables before you first make a reference to the files, FileMaker will not attempt to open invalid file paths.
  2. So you are saying that 'delete child records' is independent of the layout that you are on at the time? So that delete fires if *any* relationship between TO's based on those tables has the 'delete child records' option set, regardless of which layout you are on at the time?
  3. Presumably bcooney meant that both the parent and child TO's are repeated, and set to delete via the relationship, and therefore only when you are on a layout based on those new TO's does the cascading delete occur. Provides a way to perform that function for the developer, without risking it happening inadvertently from the main TO's used in the solution. Maybe?
  4. Hello again Last time you said you were entering subdomain.domain.com and the record with server.subdomain.domain.com was not being found. I explained that before. Today you are searching for server.subdomain.domain.com (which FileMaker thinks is just one word) and it is finding it, because it exactly matches the word stored in your record.
  5. Hi John I think the issue is that you are using a value list in a situation in which it was never really intended to be used. It seems like you are only setting these records up once (since you don't want any duplication), so why have a value list? A value list is used to guide users so that they only choose valid selections when filling in a field, but your users won't be setting up records using that list perhaps? You are probably only setting up one new record each year. Why not just type in the year when you setup a new record? I can't think of any easy way to do what you originally asked, it would be a whole lot of effort for no big benefit.
  6. Hello You are only entering one word, the dots don't appear to FileMaker as word separators. Quick Find doesn't support wildcards, so you cannot type *subdomain.domain.com for example, which is a shame. This article explains that the only operator you can use is the "" "" operator https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Fperforming-a-quick-find.html%23wwconnect_header So quick find probably won't help you here. You could create an auto-enter calculation field (text) and substitute '.' for ' ' from your other field, and then add that to the layout and make it available for Quick Find, but that is a bit of a cludge.
  7. Hi qasalla Some thing in Filemaker are very easy, and some are more complicated! Relationships allow you to show portals. If you want EVERY study type to appear for EVERY participant, then the relationship that you use would have to be a 'cartesian join', that is one that succeeds in every case. You do this with the 'X' symbol when defining the relationship, and you should just use the Primary key in both tables, with the cartesian join, to create that relationship. Then you will see every study type for every participant. However this isn't very useful. If you have a field in the 'study' table that is 'Eligible_BOOLEAN', where the intention is that you somehow set that if a participant is eligible for that study type, then it will be the same for EVERY participant. This is probably not what you want. To solve this you have to setup a JOIN table, that is a table that has a record for each time a participant is involved in some way with a study type. The join table has two foreign keys, one relating to a participant, and one to a study type. You then need to find a way to add a record in that join table each time you want to store some information about that participant in relation to that study type. I've enclosed a little example, which I hope starts you on the right path. You pick the study type from the popup menu in the 'Participants' layout, and it will add a JOIN table record for that study type for that participant. You can manually select if they are 'Eligible' although you may have a different way of working that out. As a clue, it uses a Script Trigger on the popup menu, to run a script, which adds the JOIN TABLE record. Have a poke around it and see if that helps at all? Example.fmp12
  8. Hi Greg It would be helpful if you could post your database on the forum. It will be something to do with the setup of your relationships probably, in that it is generating entries in the TYPE table when you are choosing the type in the cards table. If you post the DB then I'm sure I could give you the answer quickly! (or someone else might beat me to it)
  9. Hello The built-in drop down calendar can only display it's default view, that is selecting day/month/year. The idea is that it correctly populates a 'Date' field, which needs all three of those elements. If you are just interested in Month and Year then presumably you are storing those in two separate fields? In which case, just use normal drop down list with value lists attached for months and years. If you are trying to store the info in a date field, then you could use two fields as described above and use an auto enter calculation in your date field along the lines of :- Date (monthField ; 1 ; yearField) to auto enter the 1st of the month and year as selected. It hard too give you the best answer without a bit more information on what you are trying to do.
  10. Hi Dellana Since you seem so new to all this, and may be approaching this the wrong way, I did you a little sample file so you can take a look at how it might be done. Hope it helps. Checkbox.fmp12
  11. I think FM17 always shows page breaks and page margins when in preview mode. The grey area outside of the normal parts (body, header etc) are the page margins. They aren't hugely useful, and FileMaker will never print anything in those areas anyway, but it gives you an idea as to how much 'White Space' will exist around your layouts when you print.
  12. Hello That's a tricky one, and I guess could be achieved in many different ways. You could have a script with the Set Selection script step that calculates the start and end point and makes the selection. Then add a 'Copy' script step after that. So it's just a two line script. Start Point Let ( [ sentenceNo = Get ( ScriptParameter ) ; ] ; If ( sentenceNo = 1 ; 1 ; Position ( SentenceTest::myTextField ; "¶" ; 1 ; sentenceNo - 1 ) + 1 ) ) End Point Let ( [ sentenceNo = Get ( ScriptParameter ) ; countOccurencesOfCarriageReturn = PatternCount ( SentenceTest::myTextField ; "¶" ) ] ; If ( sentenceNo > countOccurencesOfCarriageReturn ; Length ( SentenceTest::myTextField) ; Position ( SentenceTest::myTextField ; "¶" ; 1 ; sentenceNo ) - 1) ) Then call that script with the script parameter matching the sentence you are trying to select. You could have a number of buttons, each of which selects a sentence (1, 2, 3) etc. You could also put hide conditions on those buttons so it only shows the correct number of buttons. Still works if an extra carriage return has been put on the end of the last sentence. Enclosed a sample file for you to see it in action! SentenceTest.fmp12
  13. 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.
  14. 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?
  15. 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.
  • Create New...

Important Information

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