freeDive: frequently asked questions
The information below was prepared prior to the launch of the freeDive beta. Please feel free to contact us if you have additional questions you would like answered.
freeDive uses Google APIs to access the spreadsheet data. The API guesses which row contains the column headers by comparing text with numbers in each column. Having a column on numbers assures the Google API guesses correctly.
freeDive can only search text fields.
No. Searching for the number 10 would result in any number with a 10 in it (100, 1,000, or 1,000,000,000). freeDive uses operators (greater than, less than) to select ranges of numbers. Number search would be a nice feature and we may get to it eventually, but it's not practical for our initial launch.
freeDive uses Google APIs to access the spreadsheet data. The API guesses which row contains the column headers by comparing text with numbers in a column. If there are two header rows, the API cannot guess reliably.
Honestly, we probably could have figured this out and may still. But it's a low priority issue and easily addressed in the spreadsheet. Plus, it gives you control over the appearance.
Multiple sheets occasionally cause problems in freeDive. Additionally, they can slow performance.
Every bit of information that has to transmitted can slow performance. Deleting everything you don't need will provide a better user experience.
Yes. The more refined your spreadsheet is, the better your experience with freeDive will be. Clean your data, arrange the order of your columns, delete everything you don need.
Your searchable will break.
Make sure that your spreadsheet publishing options are set to automatically republish. Eventually the new data will appear in freeDive. You can make the changes immediate by opening the spreadsheet publish settings and clicking Republish now.
All caps text takes up a lot space and is hard to read. Title text is easier to read and will help a table with several columns fit into a story or post area. But if you have space and really want to use all caps, you can.
Make sure that you only enter your key, not the entire URL.
Make sure you have published your spreadsheet and changed the sharing settings to Public.
Yes. You may have up to 10 columns. Keep in mind that too many columns in a small space may result in a horizontal slider (which we hate).
To view the page, you must rename it to "yourname.html" The you can open it with your browser.
freeDive works in Internet Explorer 8+, Chrome, Firefox, Safari and Opera.
No. IE 6 and 7 account for less than five percent of browser use. We will not support these browsers.
The embed code allows the table to live inside your web site. As a result, whenever a user changes the primary search, the page URL is updated. This creates a link to results that users can share on social networks with whichever social sharing buttons you choose to use on your site.
Some content management systems restrict what kinds of code can be embedded. While there is usually an administrator who can address the problem, it is common for reporters/editors to be restricted.
The HTML page allows the use of freeDive with an iframe. This is critical in cases where content management systems restrict what kinds of embed code can be used. It's also easier to edit the CSS and customize the table to match a web site.
When using an iframe, the ability to share search results with social media sharing sharing buttons is lost.
Yes. But you must use the embed code.
The Google API sees % in columns as a decimal. For example, 34% is seen as 0.34. This means that the numeric slider will display a range from 0 to 1, rendering it useless. The numeric search function will be confusing for users and should not be used on this column type. We have requested fix for this issue and will update in this space if there is a change.
Yes. freeDive supports limited HTML in your spreadsheet. For example, a cell with <a href="URL">Link</a> will display a clickable link.
Yes. And yes. You can reference an image available on the web. If you are using the embed code you can reference your CSS. Use this: <img src="URL" /><br /><p>cutline<p> If you are using embed code, you can use your site CSS. Example: <img src="URL" /><br /><p class="cutline">cutline<p>