Tech

I was recently working on a project that required I setup a VAST/VPAID waterfall within VideoJS, and pass macros to be replaced on runtime to the ad tag. It was pretty tricky to get it working, but after much research, I was able to accomplish it. Here’s how I did it. Setting up VideoJS I first followed the instructions to setup VideoJS, plain vanilla, stock, just as-is and nothing fancy. Made sure that was working. I found this hosted mp4 video which is great for testing if you don’t want to eat up your own bandwidth. Setting up VideoJS Contrib Ads

If you’re anything like me, you want clean data and don’t want to show anything that may look wrong. In this instance, I have rows of data, but some rows may not have data yet and I want them to be ready for when they do have data. Instead of showing 0 for every field with no data, you can return an empty cell. Here’s how. In the cell you want to show the empty cell when no data, you first run the calculation to see if it returns any data. If it does, then show that data. If it …

Continue ReadingHow to Return an Empty Cell When the Value is Zero in Google Sheets

Keep it simple. select * from table1 where criteria1 = TRUE order by random() limit 500 Simple enough to get the job done and pulls a random sampling based on the result set.