1.0Gathering Tools - Improve the reliability and security of Excel processeshttps://www.gathering-tools.com/en/rich600338<blockquote class="wp-embedded-content" data-secret="lqDjMrCNVo"><a href="https://www.gathering-tools.com/en/documentation/key-field-update-mechanism/">key field update mechanism</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.gathering-tools.com/en/documentation/key-field-update-mechanism/embed/#?secret=lqDjMrCNVo" width="600" height="338" title="“key field update mechanism” — Gathering Tools - Improve the reliability and security of Excel processes" data-secret="lqDjMrCNVo" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.gathering-tools.com/wp-includes/js/wp-embed.min.js </script> Details of the key field update mechanism The key field update allows you to update only certain fields of existing records. The key fields are used to designate the records to be modified in the host table using the equivalent item combinations in the data from the compartment. An option is provided to add records […]https://www.gathering-tools.com/wp-content/uploads/2021/11/KeyField.png810796