Jump to content

Jack Wright

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jack Wright

  • Rank
  1. Thank You! Will try this out when I am next on the computer!
  2. I am using FMS 14 Additionally The layout has a field on it with the valuelist assigned to it. Nothing showed up with the print_r
  3. Hello! Another post... Please help me out. I am trying to create an array from a value list within Filemaker Pro (Using PHP API) The idea is to create an array of names from a value list I have set up... Then put them into an option tag. e.g. $staff = array(FileMaker Value List) ^^ I know that's incorrect, but it shows what I want to do Then with that array I want to be able to Create a HTML option list (I know how I would do that) --- I am just really struggling with creating the array... Here is what I have $database = "comms__web"; $hostname = "###.###.#.#"; $username = "web"; $password = "################"; $layoutname = "Web"; $valueListName = "MIS"; //CREATE FILEMAKER OBJECT $fm = new FileMaker($database, $hostname, $username, $password); //GET THE LAYOUT AS AN OBJECT. $layoutObject = $fm->getLayout($layoutName); //GET THE VALUE LIST $valueList = $layoutObject->getValueList($valueListName); However it doesn't actually appear to pick up the list... Please help me out Thanks,
  4. Thank you all for your input. I managed to solve the issue, by simply changing the Filemaker script around...
  5. 1) - For this instance it is the test script: (view the image) 2) - In the test script I ask it to make a new layout then post the ID into that layout (The ID being the PHP_ID sent from the form itself) - The record is created, but no parameter, and you can see that I did an if statement to check whether there was a parameter, and when that was active no record was made, hence there wasn't a parameter, but without it a record is made so it is just the script that works. For a bit of context... The user fills a form and the data is sent directly to the database (That works fine) - The idea is to notify someone of when that message is sent, so I generate a random ID (I call the PHP_ID) this is then inserted into the database with the form and used as a parameter on the script, The script will then be written to check the parameter ID to the ID in the message, then send a notification to the user accordingly... So if Someone was to fill the form out with the details Dept: testDept User: testUser Message: testMessage it would put those details (including an ID, date timestamp etc.) as well as the PHP_ID into a record on the database... The script is then called which uses the SAME PHP_ID as the parameter. That script then looks through the database to find the record with the same PHP_ID, it will then send a notification to testUser on the filemaker database.... If I cannot pass this parameter I cannot do the check, thats where the issues lies.
  6. I tried your method... No error was thrown, but no parameter was set either... This is really odd, everything else works
  7. WIll try this now, Thank You I should also note, that when I try to set a variable for the parameter there is no parameter there.
  8. Hello all So I'm pretty new to Filemaker and CWP - I have created a form which people fill out and it stores the data in a filemaker solution. The idea being a script is then run which will notify a user if the form has been submitted. Now I have the script for that and all the Filemaker side completed, as well as the data entry from the PHP form, but I am really struggling with running a script with a parameter... It runs the script, but not the parameter attached. For a bit of context, Someone fills out the form and it is entered into the database, a script is then called with the parameter being an ID, the script then checks the ID with the parameter ID and then sends a notification to the user with the details from the record where the IDs match... but it will not pass the ID parameter into the script from the web application. Here is my script require_once ('FileMaker.php'); $fm = new FileMaker(); $fm->setProperty('database', 'comms__web'); $fm->setProperty('hostspec', 'http://192.168.X.XXX'); $fm->setProperty('username', 'web'); $fm->setProperty('password', 'XXXXXXXXXXXXXXXX'); $newPerformScript = $fm->newPerformScriptCommand('Web','TestScript','test'); $result = $newPerformScript->execute(); Please help me out here... Been trying to research this issue and nowhere really actually helps. Cheers Jack
  • Create New...

Important Information

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