{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/66906d06565342c0b0bdce4b993703f3\" frameborder=\"0\" width=\"1200\" height=\"900\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":900,"width":1200,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":900,"thumbnail_width":1200,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/66906d06565342c0b0bdce4b993703f3-00001.gif","duration":405,"title":"Google Tables Dynamic Formula Approach","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-&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."}