{"id":975,"date":"2023-06-01T16:06:46","date_gmt":"2023-06-01T14:06:46","guid":{"rendered":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/?p=975"},"modified":"2023-06-01T16:26:07","modified_gmt":"2023-06-01T14:26:07","slug":"how-to-bypass-remote-caching","status":"publish","type":"post","link":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/docs\/how-to-bypass-remote-caching\/","title":{"rendered":"How to bypass remote caching"},"content":{"rendered":"\n<p>Alongside the <a href=\"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/docs\/prevent-formulas-from-regenerating\/\">save button<\/a>, remote caching is a performance optimization that prevents the odd Google Sheets quirk of periodically refreshing your formulas and wasting monthly characters. <\/p>\n\n\n\n<p>Remote caching is just one of the many <a href=\"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/docs\/rate-limits-auto-retry-batching\/\">performance optimizations<\/a> that Flowshot has under the hood.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is remote caching?<\/h2>\n\n\n\n<p>Remote caching saves a copy of your generated outputs in our own cache, rather than relying on Google Sheets&#8217; local cache. <\/p>\n\n\n\n<p>This means that scenarios such as refreshing the page or inserting rows will not retrigger the formula and use up your character quota \u2014 instead, you&#8217;ll get a cached version of the generation delivered back to you. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Bypassing the cache<\/h2>\n\n\n\n<p>There are certain scenarios where you might want to bypass the cache and get an original response every time.<\/p>\n\n\n\n<p>To do this, you can structure your formulas as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">=AI(<span class=\"hljs-string\">\"Generate a random number between 1 and 100,000\"<\/span>, <span class=\"hljs-keyword\">FALSE<\/span>)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Adding <code>FALSE<\/code> to the formula will reset the cache. <\/p>\n\n\n\n<p>This applies to both <code>=COMPLETE()<\/code> and <code>=AI()<\/code>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Alongside the save button, remote caching is a performance optimization [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[9],"tags":[],"meta_box":{"fs_sheets_template_link":"","image_select_range":[],"image_use_formula":[],"image_named_range_formula":[]},"_links":{"self":[{"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/posts\/975"}],"collection":[{"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/comments?post=975"}],"version-history":[{"count":3,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/posts\/975\/revisions"}],"predecessor-version":[{"id":980,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/posts\/975\/revisions\/980"}],"wp:attachment":[{"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/media?parent=975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/categories?post=975"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/flowshot-ai-static.ov8fweegsv-yk26emrnv379.p.temp-site.link\/wp-json\/wp\/v2\/tags?post=975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}