macaroni

I have a solution that I'm trying to work out the security. What I am attempting to do is users will have on their desktops a filemaker 7 file that will open the solution files from the server. Since I have multiple users, I would like to impose the security of the users only have the ability of viewing the records they have created. If they did not create the record then the records can't be seen at all to the point that if they do a show all, only records that they have created will be shown. I'm hopping that this is possible and I have a feeling it is. Can anyone point me in the right direction on where the security priviledges this might be done or is this something I have to manage in my scripts. Thanks.

Is there a way to run a script when a window is closed. Running a script on close only happens when you close the last window of the current file. If the file however still has a window open then the close script is never ran. I wish there was option of run script on close window and run script on close of file thanks.

i'm having problems with the perform find script step particularly on related tables. I currently have a layout showing records from a related table. The related table is actually a table occurance from a different file. When I create the perform find script step and specify the fields and the values that I am finding, then execute the script I get the error that I am not making a valid find request. However if I make a perform find script step on a table occurance that is in the same file the script step works fine. I'm wondering if I am doing anything wrong. Any advice would be appreciated. Thanks.

When I store the original id (a auto-enter serial number) in a global field and go to related record, it doesn't go to it. It just stays at the newly created record. Here is again is what I do: I set the original parent ID to global field. then duplicate the original record. then Go To Related Record of the current table and current layout and it never goes to it. The relationship is a global = to the id. I'm having a hard time understanding this Go To Related Record in FM 7. Thanks.

Hi I'm trying to create a script that will allow to duplicate a record and it's related records. The problem that I am facing is that when I duplicate the parent record, I need a way to get the related records of the original parent record. The way I was going to go about it is, Duplicate the parent record Store the new duplicated record id into a global (not sure if this is the best way, might be 6 thinking) Go to the related record of the original parent record. Loop through and duplicate the related records and assign the parent id with the value stored in the global. The problem is, when I duplicate the original parent record, I am at the duplicate record and I can't figure out how to go back to the original so I can get the related records. Thanks for any suggestions and any insight on a 7 like approach to this.

Jean-Marie, Thank you very much for your help. I should really start reading my XSLT tutorial again as I am getting rusty again. Thanks.

I've been working on an XSLT and I'm getting different results in the HTML page produced. In creating my XSLT, I have been using TestXSLT http://www.entropy.ch:16080/software/macosx/#testxslt. When I export my data from Filemaker using the same stylsheet I get different results on the HTML page. As far as I know FileMaker uses Xalan-J as its XSLT processor which TestXSLT has as an option for XSLT processor to choose from. I'm not quite sure on how to best approach the different results. Using TestXSLT's Xalan-J, I get the results that I need and exporting from FileMaker I get a whole different result. Any advice would be appreciated. Thanks.

Thanks for the help. I do have a follow up question, I want to create a format similar to below: Please rate each of the following: Activity 1 Poor Fair Good Great Excellent Activity 2 Poor Fair Good Great Excellent Activity 3 Poor Fair Good Great Excellent With the sample XML below and using the stylesheet that I altered following your lead of using matching templates. I can pull out the "Poor Fair Good Great Excellent" only once but this time I need to print it out the same number of times as the same number of <data> elements in column 9. I initially thought of putting it in <xsl:otherwise> <xsl:apply-templates select="fmp:COL[9]/fmp:DATA" /> <xsl:apply-templates select="fmp:COL[10]/fmp:DATA" /> </xsl:otherwise> but then this would only process the node for col 9 then process node 10. I think what I need is <xsl:template name="fmp:COL[9]/fmp:DATA" > <xsl:value-of select="." /> <!-- process node col 10.--> which is the following::sibling of col 9 </xsl:template> I can't seem to figure out how to process one data element of col 9 then process col 10. Any help is much appreciated. Sample XML file <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE> 0 </ERRORCODE> <PRODUCT BUILD="03-05-2004" NAME="FileMaker Pro" VERSION="7.0v1a" /> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="EvalSystem" RECORDS="2" TIMEFORMAT="h:mm:ss a" /> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="EvaluationID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ApplicationID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionType" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="HasCommentsFlag" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SelectionType" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RatingGroup" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionText" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QSTNITEMS::ItemDescription" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="RATINGOPTNS::RatingDesc" TYPE="TEXT" /> </METADATA> <RESULTSET FOUND="1"> <ROW MODID="2" RECORDID="2"> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> TTE </DATA> </COL> <COL> <DATA> 2 </DATA> </COL> <COL> <DATA> Matrix Selection </DATA> </COL> <COL> <DATA> No </DATA> </COL> <COL> <DATA> Radio </DATA> </COL> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> Please rate each of the following activities </DATA> </COL> <COL> <DATA> Center Tour </DATA> <DATA> Meet and Greet </DATA> <DATA> Training </DATA> </COL> <COL> <DATA> Poor </DATA> <DATA> Fair </DATA> <DATA> Good </DATA> <DATA> Great </DATA> <DATA> Excellent </DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> XSLT file: <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet exclude-result-prefixes="fmp" version="1.1" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output doctype-public="xml" encoding="UTF-8" indent="yes" method="xml" version="1.0"/> <xsl:template match="fmp:FMPXMLRESULT"> <xsl:apply-templates select="fmp:RESULTSET/fmp:ROW"/> </xsl:template> <xsl:template match="fmp:RESULTSET/fmp:ROW"> <xsl:variable name="qtype" select="fmp:COL[4]/fmp:DATA" /> <xsl:variable name="allowComments" select="fmp:COL[5]/fmp:DATA" /> <xsl:value-of select="fmp:COL[8]/fmp:DATA" /> <xsl:choose> <xsl:when test="contains($qtype, 'Single')"> <xsl:apply-templates select="fmp:COL[10]/fmp:DATA" /> </xsl:when> <xsl:otherwise> <xsl:apply-templates select="fmp:COL[9]/fmp:DATA" /> </xsl:otherwise> </xsl:choose> <xsl:if test="contains($allowComments, 'Yes')"> <!-- put input type="text" here --> </xsl:if> </xsl:template> <xsl:template match="fmp:COL[9]/fmp:DATA"> -<xsl:value-of select="." /> </xsl:template> <xsl:template match="fmp:COL[10]/fmp:DATA"> -<xsl:value-of select="." /> </xsl:template> </xsl:stylesheet>

I'm having some trouble on how to get out multiple <data> that is contained in a single <col> element. It only prints out the first <data> element when a <col> element has multiple <data> elements. The 9th <col> has the related <data> and in some cases may not have any. What I am atempting is the format below: Question Text 1 Question Text 2 related data 2a related data 2b related data 2c Question Text 3 Below is an example of the XML file: <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE> 0 </ERRORCODE> <PRODUCT BUILD="03-05-2004" NAME="FileMaker Pro" VERSION="7.0v1a" /> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="EvalSystem" RECORDS="2" TIMEFORMAT="h:mm:ss a" /> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="EvaluationID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ApplicationID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionID" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionType" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="HasCommentsFlag" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SelectionType" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="SelectionRatings" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QuestionText" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="QSTNITEMS::ItemDescription" TYPE="TEXT" /> </METADATA> <RESULTSET FOUND="2"> <ROW MODID="1" RECORDID="1"> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> TTE </DATA> </COL> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> Single Select </DATA> </COL> <COL> <DATA> No </DATA> </COL> <COL> <DATA> Radio </DATA> </COL> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> Please rate your experience </DATA> </COL> <COL> </COL> </ROW> <ROW MODID="1" RECORDID="2"> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> TTE </DATA> </COL> <COL> <DATA> 2 </DATA> </COL> <COL> <DATA> Matrix Selection </DATA> </COL> <COL> <DATA> No </DATA> </COL> <COL> <DATA> Radio </DATA> </COL> <COL> <DATA> 1 </DATA> </COL> <COL> <DATA> Please rate each of the following activities </DATA> </COL> <COL> <DATA> Center Tour </DATA> <DATA> Meet and Greet </DATA> <DATA> QA Sessions </DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> and the XSLT: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> <xsl:output method="html" version="1.0" encoding="UTF-8" indent="yes" /> <xsl:template match="fmp:FMPXMLRESULT"> <html> <body> <table border="1" cellPadding="1" cellSpacing="1"> <xsl:call-template name="header" /> <xsl:for-each select="fmp:RESULTSET/fmp:ROW"> <xsl:variable name="qType" select="fmp:COL[4]/fmp:DATA" /> <!-- we check how to print the question based on the question type --> <xsl:choose> <!-- Single Selection Type --> <xsl:when test="contains($qType, 'Single')"> <tr> <td colspan="8"> <xsl:value-of select="fmp:COL[8]/fmp:DATA" /> </td> </tr> </xsl:when> <!-- Matrix Selection Type --> <xsl:otherwise> <tr> <td colspan="8"> <b> <xsl:value-of select="fmp:COL[8]/fmp:DATA" /> </b> <xsl:for-each select="fmp:COL[9]"> <xsl:value-of select="fmp:DATA" /> </xsl:for-each> </td> </tr> </xsl:otherwise> </xsl:choose> </xsl:for-each> </table> </body> </html> </xsl:template> <xsl:template name="header"> <tr> <td align="middle"> <xsl:attribute name="colspan"> <xsl:call-template name="numfields" /> </xsl:attribute> <xsl:text> Database: </xsl:text> <xsl:value-of select="fmp:DATABASE/@NAME" /> </td> </tr> <tr> <td align="middle"> <xsl:attribute name="colspan"> <xsl:call-template name="numfields" /> </xsl:attribute> <xsl:text> Records: </xsl:text> <xsl:value-of select="fmp:DATABASE/@RECORDS" /> </td> </tr> <tr> <xsl:for-each select="fmp:METADATA/fmp:FIELD"> <td align="middle"> <xsl:value-of select="@NAME" /> </td> </xsl:for-each> </tr> </xsl:template> <xsl:template name="numfields" match="fmp:METADATA"> <xsl:value-of select="count(fmp:METADATA/child::*)" /> </xsl:template> </xsl:stylesheet>

I've been trying to figure out how to get my CDML to work. For some reason when I load a page, all I get is the CDML tags themselves. I checked my databases and made sure they are shared using webcompanion. I have webcompanion enabled in my application preferences and I still can't get it to work. Is there anything I am missing in terms of getting my CDML to work? I have a simple HTML file with the following code: [FMP-InlineAction: -db=mytestdb.fp5, -lay=TestLayout, -Findall] [FMP-Record] [FMP-Field: myfield] [/FMP-Record] [/FMP-InlineAction] I have FileMaker Pro Unlimited on a G4 with Mac OS X. Any ideas would be appreciated... Thanks

Hi Ugo, I looked at your sample file and it seems that the dynamic list doesn't get changed for each record. It appears to me that for each record there has 10 options. i.e. For record 1, if I assign 3 to it and proceed to record 2, 3 is still available as another option when it fact that it should not be since 3 was already assigned to record 1. What am I missing? Thanks.

How can I create a value list of numbers 1 through 10 and each time the value is used, the value is removed from the value list without having to use a second file but rather all in one file. I've done shrinking value list based on related files. I want to just use 1 file... I first attempted by first creating a calculation field that results in a text of 1

I have scripts that are assigned to the portal rows such as displaying more information and such. For some reason there are instances when they click on the portal row the script is not triggered at all. It is either they get the black highlight color which is i think is the default color for portal rows or the gray highlight color that occurs when you click on something with a script attached. The control script steps are set to PAUSE. Thanks.

I've seen a few examples where the parent file creates a related record in the child file by simply performing a set field of the foreign key in the child file. The relationship is Parent ID -> Parent ID (in child file) I tested it out and my question is how do you go about in creating multiple related records because I tried the script step of just "Set Field[Parent_Child::Parent ID, Parent ID] and this only seems to work when creating one related record. I ran it again and it didn't create another record. The child file's primary key is Child ID with an auto-enter serial no. What I have been doing is passing the foreign key through a global. I realize this is a very simple question and I'm still trying to learn all the neat features of FileMaker as I try to improve. Thanks...

Just as you posted, I tried 4 quotes and this time it needs to have the & included. You rock Lee.... Thanks.