Completely lost on data for PDF

[AcueductoPM]

I've watched numorous videos on how to create a PDF from data, but not matter what I try, it's not working.  I understand the BOT part, and creating the PDF Template with HTML....those aren't the issue.  

I'm trying to create a PDF from a Dashboard Slice, but I can't 'pull' the data into the PDF.

I use a filter table for the user to enter the "Medidor" (On the left of the Dashboard).  On the right is the Slice Table (Meter History), from the Table (Lecturas).

In the filter table, I created a virtual column as shown here:

The PDF brings in the <<key>> and the <<Medidor>>, but nothing else.

After watching multiple videos and reading what I could, I'm at a loss....

Any help would be appreciated.

[Suvrutt_Gurjar]

If you are trying to display a chart in the PDF, please take a look at the SNAPSHOT() function.

SNAPSHOT() - AppSheet Help

The SNAPSHOT() function will insert a chart view natively created in AppSheet. However native AppSheet charts have certain issues such as very small X, Y axis display values etc. 

If you are okay with using Google Apps Script (GAS), please take a look at the following tip

Tip to ALWAYS AUTOMATICALLY include The LATEST UPD... - Google Cloud Community

[AcueductoPM]

Initially, I just want to bring in the data in table format.  I think I can get the historian chart using quickchart, into the pdf also.

But I'm missing something...the data is blank....I'm missing a something in REF_ROW, or not assigning a correct type to a column.  I just can't find where it is.

[AcueductoPM]

@Suvrutt_Gurjar 

Your suggestion in the link will work great.  Just use the data contained in Google Sheets to create the chart and table, then export to PDF from there using Script.

The issue is, in my case, I want the user to initiate the command (or action, or automation) to create the PDF.  Automation in Appsheet is only triggered by an update, add or delete to a row. 

The only other method I can find is to create a CSV to export the data, then import that into Google Sheets template to create the chart for export to PDF.

[Marc_Dillon]

What exactly are you confused about, or where exactly are you experiencing an issue? What record is the bot being triggered on? What data do you want to display in your PDF?

[AcueductoPM]

I'm trying to bring in the slice data into PDF, in table format (not the histrogram...yet), based on the dashboard view.  To filter the slice data, the user inputs the Medidor value into the dashboard, and the graph (and associated data, change).  I'd like to create a PDF with this same data, but am lost on how to 'grab' it and put it in PDF template.  I understand the BOT and the HTML part...But every test I run, it never brings in the records.  It only brings in the [Key] and [Medidor] fields...which don't change.  Those are the stationary records.  But there shoulb e 5 results based on this table when Medidor = 23032235

[Marc_Dillon]

Use Start expressions in templates - AppSheet Help

[AcueductoPM]

I ended up created a Google Script to create the chart in Google Sheets, and to create the PDF. I can run the script from an action.

Much more simple than trying to create the graph and chart in PDF from appsheet.