8 Replies Latest reply on May 12, 2015 9:26 AM by TSGal

    FMP URL supports variables but not repeating variables ( $var[N] )

    BruceRobertson

      Summary

      FMP URL supports variables but not repeating variables ( $var[N] )

      Product

      FileMaker Pro

      Version

      13.0v2

      Operating system version

      OSX 10.8.5

      Description of the issue

      The FMP URL format allows declaration of script names, script parameters, and variables.

      The FileMaker variable feature allows for "repeating" variables, using a square-bracket syntax, of the form $var[N] where N is an integer. Variables can be declared or read when using this format.

      PROBLEM: this feature does NOT work in the FMP URL method.

      Steps to reproduce the problem

      The following will work and script "doThis" will receive the parameter and will be able to read the value of $myVar1 ( "thompson" )

      fmp://$/myFile?script=doThis&param=23&$myVar1=thompson

      However this will not work and it will not be possible to retrieve the value of $myVar[1] or $myVar[2] etc

      fmp://$/myFile?script=doThis&param=23&$myVar[1]=Bill&$myVar[2]=Thompson

      Expected result

      If the script "doThis" runs in the file, then the following should work:

      Let( [ N = 1; $p=get( scriptParameter ); $firstName = $myVar[N]; N=2; $lastName = $myVar[N]  ] ;
      $firstName & " " & $lastName & $p
      )

      "Bill Thompson23"

      Actual result

      " 23"

      Exact text of any error message(s) that appear

      No error message