<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/66906d06565342c0b0bdce4b993703f3&quot; frameborder=&quot;0&quot; width=&quot;1200&quot; height=&quot;900&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>900</height><width>1200</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>900</thumbnail_height><thumbnail_width>1200</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/66906d06565342c0b0bdce4b993703f3-00001.gif</thumbnail_url><duration>405</duration><title>Google Tables Dynamic Formula Approach</title><description>While Google Tables looks promising, there are no formula capabilities. This is not ideal and while I get it - Tables is about information and workflow - there are cases where given a specific state or a value-pattern, you need certain columns to self-populate.To overcome this I envisioned a unified bot-&amp;gt;webhook interface to perform computations and other types of formula handlers for Tables. Simply, I needed a way for my clients to create a bot that was able to run javascript snippets with arguments.</description></oembed>