Create and Save a Charts Per Record

Hello everyone!

This is kind of a stretch, so I am wondering if you anyone knows if this is possible.

I am looking for a way to iterate through all records in a table and create a chart based on data linked in another table. I’d like the save a picture of each of these charts in another column in the record.

For example, I have a table of people on a roster. Each of the people have certain metrics associated with them over time. I want to chart those metrics on a lineup graph and save it in the persons AirTable record.

Is this possible with some script combined with a vega, google charts or image-charts api call?

Can the AirTable Script editor handle image files?

Thanks!