In Setting up blister lists I showed how to create lists in scriptDB from data in a spreadsheet. You can also do it by scripting. The cBlister class has a few aids to help with that.
Now that we have lists in the cloud, the great thing is that changes made are immediately available to everyone who uses these functions.
Using the currency list example, which looked like this, we'd like to run something using a Google Apps Script trigger, to update the exchange rate every day at 7am.
We want to get a result something like this...
We can use the Google Currency converter after retrieving the current list, add a new column for the exchange rate (if we don't already have one), and pop in the new exchange rate for every currency that has one. Setting a trigger to run this every morning will give us a fresh daily exchange rate.
This will dump the data to take a look at the whole thing, and we can use the new field in lookups/calculation etc.
Here's the dynamic validation list we used in How to apply blister lists as as validation looking up the latest exchange rate with=blisterLookup("blister.currencies",A2,"ISO","USDrate")
All comments, suggestions, assistance, good lists are welcome as I develop this capability. You can get me on Google plus, Twitter or this forum.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > GAS lists and validation >