Summary:
In the About Advanced Merge Field Notation video, 2014 Infusionsoft Partner of the Year, Kim Snider, walks the audience through the various nuances associated with Advanced Merge Field Notations. During the video, Kim explains what AMFN is, how it can be used and what makes it the “secret sauce” of Pocket Developer.
Advanced Merge Field Notation:
Time Stamped Show Notes:
- 00:05 – Introduction from Kim Snider
- 00:18 – The video covers the definition of Advanced Merge Field Notation and explains what can be done with it
- 00:23 – Within The API Guys website go to → Learning Center → Pocket Developer Documentation → Scroll to Advanced Merge Field Notation
- 00:50 – Advanced Merge Field Notation is the “secret sauce” of Pocket Developer and what enables it to do so many things
- 01:06 – Specifically it enables users to work with fields that are not normally available in the drop-down of Campaign Builder
- 01:35 – It also allows users to work with those field in a contact other than the one going though the campaign
- 02:16 – Advanced Merge Field Notation can be used in any of the core plug-ins from the API Guys
- 02:52 – How to Use Advanced Merge Field Notation
- 03:17 – 99% of API Guys plug-ins work via an HTTP Post
- 03:26 – An example of Advanced Merge Field Notation
- 04:12 – Example #2 of Advanced Merge Field Notation
- 04:52 – Kim walks through Reference Notation
- 04:55 – This allows the user to work with a specific opportunity that may or may not be connected with the contact going through the campaign
- 05:19 – There are always two required parameters when working with a Reference Notation → table and field
- 05:30 – Kim talks through some of the Valid Qualifiers
- 05:44 – FilterBy → Allows for the performance of a query
- 06:26 – Newest and Oldest → Only returns the newest (or oldest) record
- 06:55 – Unpaid → Only supported for queries on Invoice Tables
- 07:19 – IsEmpty → Returns all empty fields
- 07:29 – GreaterThan
- 08:05 – Before
- 08:29 – OrderBy → Sort the results of a query by the specific field
- 09:08 – Max → Returns maximum of all returned numeric values in the specific field
- 09:14 – Count
- 09:20 – Sum → Returns the sum total of all values returned by the Advanced Merge Field query
- 09:39 – Global → Runs “global” queries for all contacts, not just the contact associated with the action or sequence
- 10:09 – Combine → Takes the results of an Advanced Merge Field query into one string and applies a “glue” between each result set
- 10:52 – All
- 11:05 – Additional examples of Advanced Merge Field Notation
- 11:14 – prefetch
- 11:38 – FAQ
- 12:14 – Kim’s contact information