I want to create a simple Custom Function. I searched the web and found the explodedkey function and I am desperately trying to implement it.

I follow the following instructions:

To create a custom function:

1.

In FileMaker Pro Advanced, choose File menu > Manage > Custom Functions.

2.

In the Manage Custom Functions dialog box, click New.

3.

In the Edit Custom Function dialog box, for Function Name, type a name for the new function.

Custom function names must be unique and cannot exceed 100 characters.

4.

Build a formula.

I use the following formula:

ExplodedKey=

If(

  Length(txt)>1;

  ExplodedKey(Left(txt;Length(txt)-1)) & "?" & txt;

  txt

  )

Now its time to click ok and I get the following message:

The specified parameter cannot be found.

and in the formula box "Length (txt)" is highlighted.

This is where I am stuck.

Its probably a simple thing but for the life of me I cant figure it out.

Please Help?

Hi koalacolor! Welcome to FileMaker Forums!!

Well, ExplodedKey is the custom function name.

Then right below, there is box to enter function parameters. The txt is a function parameter so you would add txt in that box and then hit the + button which would insert the word txt into the next box (where function parameters will accumulate as you define your CF). Then below, enter your calculation.

Now understanding that, read your post again. It says you are missing the function parameter txt.

Does that help you through it?