Using the API to manage lists shows how to create blister lists from various sources such as xml feeds and blister lists, Fusion and blister lists while Setting up blister lists covers a built in function to create a list from a range. Here's how to combine data from a collection of sheets to create multiple blisters.
There are a number of limits on scriptDB. One of them is on object size. It's not a specific limit, but it is somewhere between 4k-8k. Since blisters are stored as single object, that places some constraints. This is not a bad thing, as you want to keep the size manageable to avoid performance issues anyway. In this example though, we want to create a blister from all the worksheets from the guardian university rankings, used elsewhere on this site for a google visualization example.
So in this case we are going to make multiple blisters in one function.
Here's the code creating multiple blisters from a spreadsheet with a number of sheets.
Up to now we've used either lists created in the blister library, or in the local sheet. In this case I've created a script called university and added it to the project references so its accessible to co-operating spreadsheets. We'll use its scriptDb to store this data in.
more to come...
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > GAS lists and validation >