{"id":7664,"date":"2025-09-01T12:26:26","date_gmt":"2025-09-01T12:26:26","guid":{"rendered":"https:\/\/ioninteractive.com\/ionacademy\/?p=7664"},"modified":"2025-09-25T17:03:20","modified_gmt":"2025-09-25T17:03:20","slug":"how-to-work-with-lookup-tables","status":"publish","type":"post","link":"https:\/\/ioninteractive.com\/ionacademy\/how-to-work-with-lookup-tables\/","title":{"rendered":"How to work with lookup tables"},"content":{"rendered":"\n<p class=\"\">Lookup tables are comprised of a key column with a corresponding column of values. The key can be a piece of respondent data collected on your form, a query string parameter, or an Ion core field. The value should be the one that corresponds to the key. By looking up a value based on a key, you can serve up targeted content and control the way respondents navigate through your creative along with a whole suite of actions you can take \u201cbehind the scenes.\u201d<\/p>\n\n\n\n<p class=\"\">Here are just a few examples of what lookup tables combined with server scriptlets can accomplish:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"\">Check to see if the respondent\u2019s location is considered serviceable by your business.<\/li>\n\n\n\n<li class=\"\">Map the respondent\u2019s location to a specific sales representative.<\/li>\n\n\n\n<li class=\"\">Display content based on a form selection, query string parameter, or core field.<\/li>\n\n\n\n<li class=\"\">Send conditional notifications and email templates.<\/li>\n<\/ul>\n\n\n\n<p class=\"\">Once you have outlined what you intend to accomplish, the first step is to create your lookup table file. You may have the ability to do this programmatically or it could be something you can accomplish by hand. Either way, the result should be a two-column .csv file. Column A will consist of your keys and column B will consist of the corresponding values.<\/p>\n\n\n\n<p class=\"\">If you\u2019re creating a short, simple lookup table, you can skip creating the .csv file, and enter the lookup table content manually, right within your console. Here are the steps to take to add your lookup table to your ion console:&nbsp;<\/p>\n\n\n\n<p class=\"\">1. Click Data Management in your console\u2019s side nav and select Lookup Tables<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"215\" loading=\"lazy\" src=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-1024x215.png\" alt=\"\" class=\"wp-image-7669\" srcset=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-1024x215.png 1024w, https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-300x63.png 300w, https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-768x161.png 768w, https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image.png 1354w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"\">2. Click on the \u201cNew lookup table\u201d button then add a title and optional description.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"478\" height=\"451\" loading=\"lazy\" src=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-1.png\" alt=\"\" class=\"wp-image-7671\" srcset=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-1.png 478w, https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-1-300x283.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<p class=\"\">3. Click the Lookup Table Actions dropdown menu and then import your properly formatted .csv file by clicking on the Import Entries link.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"362\" height=\"162\" loading=\"lazy\" src=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-2.png\" alt=\"\" class=\"wp-image-7673\" srcset=\"https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-2.png 362w, https:\/\/ioninteractive.com\/ionacademy\/wp-content\/uploads\/2025\/09\/image-2-300x134.png 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/figure>\n\n\n\n<p class=\"\">4. Or, add entries individually by clicking on the \u201cNew entry\u201d button.<\/p>\n\n\n\n<p class=\"\">You also can automatically transfer lookup table content to Ion via a PUT request. This advanced functionality requires a posting mechanism to deliver content to the lookup table and working closely with the Ion team to bring this functionality to fruition. Please contact your customer success manager if you intend to take this route.<\/p>\n\n\n\n<p class=\"\">Once the lookup table has been uploaded or added to your Ion console, you\u2019ll use a <a href=\"https:\/\/ioninteractive.com\/ionacademy\/scriptlet-server-scriptlets-for-global-sets-of-page-rules-advanced-functionality\/\">server scriptlet<\/a> to look up a value based on the key. The following function is used to accomplish the lookup:<\/p>\n\n\n\n<p class=\"\"><em>actionLookupValue(\u201clookup table label\u201d, \u201centry name\u201d);<\/em><\/p>\n\n\n\n<p class=\"\">Once you\u2019ve used the function above to \u201cgrab\u201d the value from the lookup table, you can use the scriptlet to execute subsequent actions. For example, you may simply return the value from the lookup table and dynamically insert this into your creative. Or, you could return a response code value and use this as your rule condition on your creative(s).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"\">If you have any questions, please contact us at help@ioninteractive.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lookup tables are comprised of a key column with a corresponding column of values. The key can be a piece of respondent data collected on your form, a query string parameter, or an Ion [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[1],"tags":[2173,2195,2194],"class_list":["post-7664","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-advanced","tag-lookup-table","tag-rules"],"_links":{"self":[{"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/posts\/7664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/comments?post=7664"}],"version-history":[{"count":3,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/posts\/7664\/revisions"}],"predecessor-version":[{"id":7864,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/posts\/7664\/revisions\/7864"}],"wp:attachment":[{"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/media?parent=7664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/categories?post=7664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ioninteractive.com\/ionacademy\/wp-json\/wp\/v2\/tags?post=7664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}