Might there be a way to add an option to an embed block to snapshot and convert the embed to a jpg and store that? We use embed blocks to show graphs of current % completion of various task, once we hit a threshold it would be nice to be able to snapshot that embed block and store the result on that date. Probably would store it something like 4 or 5 times as we cross thresholds on a project. Currently the views on those days are lost or have to be manually snapshot and saved elsewhere.
You can’t automate it, but it sounds like you’re looking for the web clipper block.
Taking physical screenshots is not in the cards for Airtable blocks (now known as “Apps”), but they probably could support this if the screen capture features were embedded in the apps themselves and assuming Airtable allows access to the Apps’ HTML parent.
Baring this unlikely pathway, there may a better way to think about this problem - charting virtualization.
Imagine every day you capture the data that is rendered in the chart block so you can revisit that “state” of the information. This can now be automated to persist the data as at a certain point in time and/or a specific milestone. This would be accomplished in a separate table whose objective is solely to render historical [chart] views of the data as it progressed through the milestones.
In essence, you are capturing snapshots of the state of the data required for the chart(s). With a comprehensive collection of data at points-in-time, rendering the data visualizations is a simple matter of views and filtering dedicated to making it easy to traverse the historical snapshots.
The web clipper block supports 3 types of screenshots:
The currently supported attachment field inputs are:
- Add screenshot , which will allow you to capture a selected portion of your screen by clicking and dragging your cursor to highlight a rectangular section of the web page
- Add page screenshot , which will capture a full-page screenshot of the web page you’re currently on.
- Add image from page , which will capture an image by clicking on it. As you mouse over images, the image will be highlighted in blue if it can be selected
Yep - totally aware of the features in the Web Clipper.
Unfortunately, it doesn’t check the most important box… automation.
Right, as I mentioned in my original post above.
Yeah, there are many ways to do it from an external programatic perspective, but there are three key gotcha’s -
- You have to render the page where the block is displayed and that’s not easy to do with security and other navigation considerations to ensure you have the right visual.
- It’s not easy to automated the capture of just the chart block; you’d have to instrument a way to carve up the image which is tedious and brittle.
- Browsers change and when they do you get to see just how brittle such an approach would be.
This is why it’s a better approach to simply virtualize access to historical charts by making copies of the data, not the pixels. This approach also makes it possible to enhance the charts as new
charting features emerge and apply the new features to the current AND historical data.
Even if there were a way to capture the pixels, any client of mine would have a very difficult time convincing me to build that.
Sidebar - in 2015 I saved KFC $2.5m bucks doing it exactly as described above. They needed monthly dashboard snapshots for 17,500 restaurants over a thirty-year period and the plan was to snapshot the images. I recommended a virtualized dashboard and we developed just one app that works for all operations from 1998 to somewhere beyond 2028 - 30 years x 12 months x 7,500 (it’s a big number). And the dashboard has been updated three times in five years - all new features run against all historical data.
Can Embed App have a button added to leverage webclipper just for that block as shown, then ask for a label to add it to the existing record as an image on a date with a label. That would be very cool. Just click, type in the label “milestone 1 reached” and have the image get added to the data base for the same record.
Yep - time is just a window into the viz-ready dataset.
Plot.ly is just a rendering tool whose output is a function of data. Caching viz-ready data works with all rendering approaches.
Sure, it’s huge because it’s not viz-ready data, right? You are essentially forcing the data visualization process to also perform the data aggregation tasks (i.e., for every data visualization - re-crunch the raw data). This is typically, but it’s not a mandatory approach. Why not cache-forward the aggregations needed for the analytics? And if it’s a lot of data, one would want to question the use of Airtable for such information at the outset.
Bottom line - the data you need for analytics is typically a superset of the data captured. Compress that raw data into meaningful concise stories that can be easily managed, reported, and rendered.
Yep, but it would still be manual and humans are at the pinnacle of IT process forgetfulness.
Indeed! Perhaps useful for many things. But alas, still manual.
Also WebClipper records a URL not an image, what we really need is the ability to store the image when a milestone is reached, The URL that points to a live page could have the data altered later. Storing an image would solve that.
Second WebClipper creates a record, what we want is to add a column to the same record as the embed block (which for us is just a URL from plot.ly being displayed) with the label “Milestone A reached, on this Date”
Also not an issue if you use the URL as an image attachment. Airtable will make a snapshot (copy) of the image at the time it is imported into the Airtable attachment field. A simple action script could append the webclipper URL as an attachment.
Let me try that…any way to make it add the image to the same record as the one containing the embed block URL, instead of creating a new record?
This depends on what “it” is. If it’s an action script processing the record where the webclipper wrote the URL, then yes - action scripts can do anything you want them to do.
Will see if I can get that to work. I tend to only explore a bit at a time, so thanks for the super help.
If I understand this correctly, what’s required here is the ability to screen capture a chart block in the dashboard on a regular basis. Unfortunately, I don’t think that’s possible with our tools. One of our extensions allows you to take a screenshot of a public URL (but not private ones). Which seems like what the OP is asking for. I could be missing something though.
I just realized that dashboards can be shared publicly. So maybe this solution could work after all!