Screenshot 6 charts

Hi There

Is there a way to screen shot like I did in below all 6 charts and send them out in a enmail every week Saturday at 23:00:00

desmond_lee_0-1704765096062.png

 

Solved Solved
0 15 1,024
1 ACCEPTED SOLUTION

Please create a scheduled bot to send the email.

Please use SNAPSHOT() function to include the 6 charts in the email.

In the email template, please include the chart dashboard name as follows in the SNAPSHOT() function.

<<SNAPSHOT(LINKTOVIEW("QUA005"))>>

SNAPSHOT() - AppSheet Help

The example below shows: 

The charts dashboard view in the app

The name of the dashboard view is "Charts Dashboard"

Suvrutt_Gurjar_1-1704783522190.png

The image  below shows the template that includes the SNAPSHOT() function.

Suvrutt_Gurjar_0-1704783477431.png

The image below shows the email sent by the bot

Suvrutt_Gurjar_2-1704783709469.png

 

 

 

 

 

 

View solution in original post

15 REPLIES 15

Please create a scheduled bot to send the email.

Please use SNAPSHOT() function to include the 6 charts in the email.

In the email template, please include the chart dashboard name as follows in the SNAPSHOT() function.

<<SNAPSHOT(LINKTOVIEW("QUA005"))>>

SNAPSHOT() - AppSheet Help

The example below shows: 

The charts dashboard view in the app

The name of the dashboard view is "Charts Dashboard"

Suvrutt_Gurjar_1-1704783522190.png

The image  below shows the template that includes the SNAPSHOT() function.

Suvrutt_Gurjar_0-1704783477431.png

The image below shows the email sent by the bot

Suvrutt_Gurjar_2-1704783709469.png

 

 

 

 

 

 

Hi Surrut

Thank so much and I am doing this my first automated chart. Don't what mistake I made it shows only link

desmond_lee_0-1704784311653.png

 

Please recheck the template expression.

JSO
Silver 2
Silver 2

 


@JSO wrote:

SNAPSHOT()

https://support.google.com/appsheet/answer/10107421?hl=en&sjid=131

 


Thank you @JSO for sharing the article .

@desmond_lee 

I had also shared it earlier. Please take a look at the article.


@Suvrutt_Gurjar wrote:

In the email template, please include the chart dashboard name as follows in the SNAPSHOT() function.

<<SNAPSHOT(LINKTOVIEW("QUA005"))>>

SNAPSHOT() - AppSheet Help


 

 

I finally got it setup but how do I increase the width of the text and the picture size? I try the template margin, the appsheet margin all does not work

desmond_lee_0-1704866742764.png

 

I believe it may not be possible to control the width of the image coming out of a SNAPSHOT() function.

As a workaround, I would create a SNAPSHOT() function of each individual chart in the dashboard. This is so because the dashboard is anyway made of several individual chart views.

So my email template would have multiple snapshot functions , such as below ( one for each individual chart.)

<<SNAPSHOT(LINKTOVIEW("Chart 1"))>>

<<SNAPSHOT(LINKTOVIEW("Chart 2"))>>

and so on.

So the email could look like below. Each individual chart below the other.

Note: It is possible that the bot may fail with as many as six individual SNAPSHOT() functions.  To overcome this, I would create a combination of charts -say 2 or 3 in a dashboard and then use SNAPSHOT() for only two dashboards -each containing three views. These dashboards should be reference views , created only for bot purpose.

Suvrutt_Gurjar_0-1704868389698.png

 

 

@Suvrutt_Gurjar hi i try that and it work with me good i just have question can i when filter data take a snapshot for that filter ? 

It works for a week then it show this link. Don't where is going wrong and even if I split it individually still the same

desmond_lee_0-1705903725079.png

If I click that link msg

Failed to create fife url for remote image https://storage.googleapis.com/appsheet-prod-screenshot/4685153c9ee6f1d-155a-41cd-ad22-e960a4ab5c0d?...

My template

desmond_lee_1-1705903763192.png

 

I think you please contact AppSheet support team.

Recently another community member reported the same error. 

Error Snapshot - Google Cloud Community

 

Noted. Thanks

desmond_lee_0-1705910268688.png

 

Issue resolved by appsheet supprot team

desmond_lee_0-1706015400820.png

desmond_lee_1-1706015442359.png

 

Great. Than you for the update. As thought, the issue was not with configuration that an app creator can do.

Hello, I am currently having the same problem with automatic email generation, could I please know how you managed to display the chart images in the email body instead of the link. Even when I use this: <img src="&lt;&lt;SNAPSHOT(LINKTOVIEW(&quot;Global Status&quot;))&gt;&gt;"/>     The image is not displayed. 

Thanks in advance.

I did not do anything except appsheet resolve the lissue. What I did was as per the steps. I copy the 

desmond_lee_0-1723105960677.pngdesmond_lee_1-1723106044935.png

 

Top Labels in this Space