Brian Dunning's FileMaker Custom Functions

FieldNames2FieldValues ( Text )

Replaces field names with field values in Text

  Average rating: 4.3 (35 votes) Log in to vote

Ilya Shuvalov   Ilya Shuvalov
SUI Solutions

Share on Facebook Share on Twitter

  Sample input:
FieldNames2FieldValues ( "Dear {{Customers::CustomerName}} , thank you for buying our {{Products::ProductName}}!")
  Sample output:
Dear John Smith, thank you for buying our SUI Calendar!

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Replaces all occurrences like {{::}} to actual field values.



No name   No name, no location
Jun 28, 2011
Ok, so there are two competitors to this CF that are less well rated but still good (Mail Merge and Mail Merge Plus). However they use the << and>> that are more natural to users and the rest of us. It has been discussed that this CF is better because it does not use the evaluate function, which allows for more possible 'functionality' than perhaps desired, instead using GetField. Still, I am lazy, and here to copy and paste something, and would prefer to use the << and >> that my user is used to and a bit unmotivated to begin tinkering with this one. Great appreciation to all for three great choices!!!

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: