Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About gwjo

  • Rank

Profile Information

  • Industry
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra
  1. Hi Agnes, it is green. Here is the status page: Thanks, George
  2. I have a new installation of FMS16 and am trying to get the webdirect function working. When I click on the Test filemaker webdirect link on the tests page of the FMServer console page I see momentary activity as though something is loading but then a blank page. Is there something in the settings or setup of the server that I have missed? Any suggestions gratefully received. Many thanks, George
  3. Thanks. Looks fine for someone with a lot of php experience. The demo video shows viewing functionality only. Does this system allow for the creation of new records and editing of records? regards, George
  4. Can anyone point me in the direction of documentation on how to set up and use FMEasyWeb, please? Apart from setup help, I also need to know if it can embed javascript and link this to a filemaker database. I am doing this using FMStudio at present but am finding it very slow progress. Many thanks, George
  5. Many thanks - I largely have it sorted now. I think the problem was due to a circular argument in that the first table couldn't do the lookup from the the second one until it had the data from the second one (if that makes sense - a catch 22 situation). I have it resolved now for the FMP side of things. Regards, George
  6. I'm hoping that someone can help me with a lookup problem. Briefly, I have two tables in a database, one with the reference data in it and the other with the active records. I'm developing a chemical structure drawing package that will allow students to practice drawing molecules that have a particular functional group in them. They select the functional group they want to draw, the first table then does a calculation based on that which returns a question number at random within a pre-set number of related records, and based on the question number generated, a lookup function fills the field data from the second table. The problem that I have is that when I create a new record with all the fields blank, and then select the functional group type (from a radiobutton set), it always returns the first record in the lookup table. If I click on the functional group button again, it then does what it should do and generates the question number appropriately. Any ideas as to why this might be and how to set it right? Thanks, George
  7. I find it really frustrating trying to edit the php pages generated by the site assistant. Does anyone have, or can point me to, a guide that explains the syntax needed for the API? My php expert colleagues tell me that it is not standard php and that I should establish the logic behind it so that we can build up a site from scratch. Any ideas would be appreciated. (The old Claris homepage, that I used in producing web applications for FM4.1 had a library of html compatible code for all the interfacing commands - something like this for FM php would be absolutely great!) Thanks, George
  8. I've just upgraded my system to FMS10 advanced and am having serious problems with the php site assistant. To be brief, it is not producing a usable set of pages whereas the old site assistant in FMS9 advanced did. Drop-down menus don't work, add record doesn't give any enter buttons or even the set of fields selected and so on. This is a disaster for me as I rely on the site assistant, clunky though it is, to generate the basic pages which I then edit in dreamweaver. Any suggestions as to how to troubleshoot this, or guidance on an alternative way of generating the site would be very much appreciated. Many thanks, George
  9. I'm struggling with forcing a required field to have a value. Any suggestions as to incorporating javascript code so that it is compatible with FMP php? many thanks, george
  10. I'd be very grateful for help on this - I'm moving from a CDML system to php and am trying to do a find based on a user input field (record id) and a hidden field (expired). If the result for a record has the expired field set to 'no' then I want the browser to return a text string including the record details, if the result has the expired field set to 'yes', then to return a different text string . How do I do this? In CDML, I simply used [FMP-IF: expired.eq.no] Click on record id to view details [FMP-FIELD: record number] [FMP-ELSE] This record has already been used. [/FMP-IF] Any help / suggestions would be greatly appreciated, Thanks, George
  11. I'm sure this is a silly question but I can't find the solution in the help index..... I'm trying to set a value in a field based on a calculation involving the number of records in a related table but don't want the field to recalculate each time the number of records in the 2nd table changes. So, on day 1 there may be 100 records in the related table and I can record this and use it in my calculation. On day 2 there may be 120 records, and any new calculation will use this value, but I don't want the calcs done the previous day to change from the 100 record status. There must be a logical function to get the absolute value but I can't see it. I don't want to write a script for this using copy field and then paste - it seems too clumsy! In frustration, many thanks, George
  12. Thanks ever so much for this. Excatly what I needed and very straightforward. Regards, George
  13. hi, Is it possible to merge two filemaker files into one, with all of the field definitions? I have moved from FM4.1 to FM9 advanced. In 4.1, relational tables were different files. FM9 can have multiple tables in a single file and it would be better to do it this way rather than maintaining several files. I can't see anything in the user's guide or help files. Exporting field definitions would also work but I can't see how to do this either. I'd be grateful for suggestions, many thanks, George
  14. I have set up a database with guest access and the privilege set to allow the creation and editing of records and with guest account set up as the entry point. The system is set up using php with fmphp enabled and I can view and find records but not edit them. The error message is: Error: 200 - Record access is denied, which suggests a privileges violation. If anyone has a checklist or similar to troubleshoot the access problem, I'f be very grateful. regards, George
  15. I've been trawling through this all day and thanks to Andy Gaunt's suggestion (on another similar topic) and piece of code to report errors onto the browser, I've worked out that it is to do with the location of the filemaker.php files and subfiles. I now need to work out how to specify the location of these files as they are integral to the working of FM-API for PHP. Any suggestions would be appreciated. Regards, George

Important Information

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