executing filemaker script from via FM API

April 26, 201114 yr

Newbies

I’m hosting on FMS 10 (not advanced) and running FMP 11 Advanced on my desktop. I’m using the Filemaker ‘Registration’ template as a basis for the project. I’ve made the necessary customizations to the template to for their needs. Now I’m using the Site Assistant generated code to build a web interface to the database. The end users can now come in and either create a new account or edit their existing account fields. The next step is to allow them to register for new events once they have verified their account information.

The flow looks like this (depending upon new record or existing record)

home -> addrecord.php -> browserecord.php -> eventrecordlist.php

->findrecords.php->recordlist.php->editrecord.php->browserecord.php -> eventrecordlist.php

Eventrecordlist.php returns a page listing all of the available events with a registration button for each that the user should be able to click and execute the second of the scripts listed below.

Within the template there are two filemaker scripts that do exactly what I want

1) Register the current Contact for an Event

2) Register the current Contact for an Event 2 (which makes calls to 2 more scripts)

Create New Registration

Go to Contact Form Layout

I’ve removed any non-web usable commands and tested this within the template and everything works perfectly.

The issue I’m facing is that I can’t get these scripts to execute properly from the webpage. Based on some advice found at http://www.hierarchy.lv/?p=192 I’ve created a page that sits between browserecord.php and evenrecordlist.php called script_pre.php that is designed to execute the first script. The code is below. The first problem seems to be that the $recid gets dropped somewhere between executing the script and the code within the html. I’m not sure what I’m doing wrong and would greatly appreciate some advice.

(CODE FOR script_pre.php)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<?php

/**

* FileMaker PHP Site Assistant Generated File

require_once 'fmview.php';

require_once 'FileMaker.php';

require_once 'error.php';

$cgi = new CGI();

$cgi->storeFile();

$databaseName = 'CTE Registration';

$layoutName = 'Select List - Events';

$scriptName = 'Register the Current Contact for an Event';

$userName = $cgi->get('userName');

$passWord = $cgi->get('passWord');

$fm = & new FileMaker();

$fm->setProperty('database', $databaseName);

$fm->setProperty('username', $userName);

$fm->setProperty('password', $passWord);

$record = NULL;

$recid = $cgi->get('$RecordID');

//sample code from http://www.hierarchy.lv/?p=192 to execute script from buttons on http://161.45.157.13/registration/eventrecordlist.php

$script =& $fm->newPerformScriptCommand($layoutName,$scriptName);

@$result = $script->execute();

// end of sample code from http://www.hierarchy.lv/?p=192

ExitOnError($fm);

$layout = $fm->getLayout($layoutName);

ExitOnError($layout);

<html>

<head>

</head>

<body>

</body>

</html>

May 12, 201114 yr

Ya same problem with me also. I also not able to fire the script within PHP code after insert the record.

As PHP code is same as in standard.

Coding is as:

$layout_name='Reg';

$script_name = 'insertFile';

$script_param = '';

$script_object = & $fm->newPerformScriptCommand($layout_name, $script_name, $script_param);

@$script_result = $script_object->execute();

Sign In

executing filemaker script from via FM API

Featured Replies

Create an account or sign in to comment

Similar Content

Important Information

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)