We seem to have a need to take names and create scrolling text for various things (honor roll, Veteran’s Day, etc.). It was making me unhappy to have people spending time adding these names to PowerPoints or doing other manually intensive ways things to make this happen. I figured the Internet would have to have a better way.
Here is one.
You can get a fairly clean version of the file that focuses on vertical scrolling by saving this webpage. You could also view the source etc.View source ought to be a good friend in most situations where you’re trying to figure this kind of thing out. Do keep in mind you’ll need the additional files in this download to make this work. Keep in mind you can put this on the web or run it locally on a machine.
Now, I just needed a fast, simple way to create a list from a Google Form submission. In most cases you should have gotten these names in Excel, CSV, or user submitted via a Google Doc. I did something weird which might prove useful but may be frightening so it’s footnoted. In this case, I used some junk file names I generated from a folder with the following Unix command [code]]czoxMjI6XCJscyAtbFQgfCBhd2sgXCd7cHJpbnQgXCJcXFwiXCJzdWJzdHIoJDAsaW5kZXgoJDAsJDEwKSlcIlxcXCJcIlwiLFwiXCJcXFwiXCIkNlwiIFwiJDdcIix7WyYqJl19IFwiJDlcIlxcXCJcIlwiLFwiXCJcXFwiXCIkNVwiXFxcIlwifVwnICZndDsgWU9VUkZJTEVOQU1FT0ZDSE9JQ0UuY3N2XCI7e1smKiZdfQ==[[/code]. Once I had the data in Excel, I just added the following formula – [code]]czoxMDpcIj1BMSZcIjxicj5cIlwiO3tbJiomXX0=[[/code] and dragged it down to fill all the needed cells. The [code]]czo0OlwiPGJyPlwiO3tbJiomXX0=[[/code] is just a line break in HTML. I cut and pasted this into my HTML file, tweaked the CSS a bit to increase the size of the text and I was done.
The whole thing took about 10 minutes and hopefully will save some people inordinate amounts of drudgery.