Hey — Games newt this might help:
This is a basic example of loading in CSV data into an array. capx
The Idea: The user types in a date from the 'DATE' column, eg.'1 Jan 1942'. The programm will then bring up a fact and load the associated image from a URL. Iv added a randomise button that uses the array to randomise a URL.
<img src="https://dl.dropboxusercontent.com/u/20299415/capx-forum/Pictures/facts-spreadsheet.png" border="0">
My Process: I made a spreadsheet via google docs, downlaoded it as a CSV file and then copied the CSV spreadsheet data and pasted it into the CSV plugin (you probably can load in the CSV doc instead of pasting data into C2)
Iv made a primitive search feature that works but it will mean I would have to do everything manually.
Would you guys happen to know how to look up one of the facts by searching a date in the text box?
Is the best way to load the 3 columns of data into the Array and write an expression in the Text Box with the logic of:
When a "DATE" is detected in the Array:
Sprite loads image from "URL" index of array.
Text loads "FACT" from index of array.