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

27 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,006 profile views
  1. 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.
  2. 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.
  3. 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.
  4. 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
  5. 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)
  6. 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.
  7. 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
  8. 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.
  9. 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
  10. 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.
  11. 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?
  12. 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.
  13. 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.
  14. 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!
  • Create New...

Important Information

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