tag archives: hacks

working example form and graph: how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms here is a working example of a google form and chart embedded statically into a web page.
you may also be interested in a truly static version and/or the underlying data in this spreadsheet on google docs.
[more...]

[category: computers & technology] [tags: , , ]

how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms the problem: for a small web project that is going to run on a server with very restricted functionality (due to safety concerns), we wanted to include a web form where visitors can submit values. these values should then be presented in a graph, showing all submitted values and highlighting the latest addition.

the solution: after some digging, i found a way to do all of that using google forms/spreadsheets, which offers user input, a simple spreadsheet-based database, as well as dynamic image creation.
check out the working example page and the underlying spreadsheet, and continue reading for a step-by-step tutorial on how to create a web form that plugs into an automatically refreshing graph/chart using very basic means, and how to implement it all using just two static web pages, a google form, and a google spreadsheet. [more...]

[category: computers & technology] [tags: , , ]

How to unprotect Word files without knowing the password

[posted: ]  [95 comments]

How to remove unknown passwords from protected Microsoft Word files I’m regularly annoyed at password-protected Microsoft Word files that only permit editing of certain aspects of the document such as form fields. By itself, Word’s “Restricted Editing” isn’t necessarily a bad thing. It’s the fact that file creators are usually very conservative and prefer to disallow editing something “just in case”, rather than giving users the option to add text somewhere unexpected.
The result is often that in order to complete a form, one must print it out and amend it with a pen, or convert to PDF and use the “comment” function.

Looking for a way around, I recently found out how to remove the Document Protection from Word files without knowing the actual password*:

* Note that this method only works with Word Docs that are protected from editing, not files that require a password to open. [more...]

1 second everyday: how to manually add videos to a past date (or: how to change a file’s modified date in android)

[posted: ]  [34 comments]

1 second everyday: how to manually add videos to a past date (or: how to change a file's modified date in android) have you heard about 1 second everyday? it’s an app for android and ios which lets you create a neato long-term compilation of short videoclips recorded daily – as the name suggests, you can use 1 second per day.
before the android version was released, a few days ago, i had used memoir, which works with the same principle but doesn’t sync video and audio very well.

moving from one app to another is not easy: making the videos of one app available to the other modifies the “date modified” timestamp, which is used by both apps to assign videos to dates. neither app allows changing a video’s date internally (yet?), and there’s no native feature in android to change a file’s timestamp. basically, once you run into a problem that requires file handling (and/or want to migrate videos from one app to the other), you’re stuck.

that’s a rather unsatisfactory realization, so i decided to look for a workaround: [more...]

how to: add individual css classes to sidebar widgets in wordpress using widget logic

[posted: ]  [0 comments]

how to: add individual css classes to sidebar widgets in wordpress using widget logic there are some wordpress themes which, for some reason, remove the individual widget wrap css-classes, and just add one generic class to all the widgets, e.g.
<div class="widgetwrap"> ... </div>

this is a real pain if you want to change the appearance of just one specific widget in your sidebar.
at the same time, widget logic is (1) a very powerful widget plugin, and (2) known to have incompatibilities with some other widget plugins (or is it the other way round?).

to solve this problem while keeping widget logic, i wrote a little script and thought i’d share.

[more...]

what to do if wordpress plugin or theme settings are not saved or modifications are ignored

[posted: ]  [0 comments]

in another wordpress blog (version 3.1), we’ve recently had problems with plugins and themes, where new dynamic options of wordpress 3+ (including plugin settings, theme settings and menu settings) would not get updated.
new input or changes in the values on the respective administration page were just ignored, despite the confirmation message on top of the page, saying “changes were saved” etc.

i just found the cause of the problem: [more...]

wp downloadmanager: how to change the default sort order in the admin overview page

[posted: ]  [0 comments]

the problem:
WP DownloadManager, a very handy plugin for wordpress, sorts all downloads by name in ascending order on the admin overview page. i find this impractical, because i mainly open that page to (1) see how my downloads are doing in terms of clicks and (2) edit one of the most recent links.

the solution:
…is quite simple. just open the built-in wordpress plugin editor, choose the correct plugin to edit in the top right dropdown menu (“WP-DownloadManager”), click “choose” (or “wähle” in german), …

open the built-in wordpress plugin editor, choose the correct plugin to edit in the top right dropdown menu ("WP-DownloadManager"), click "choose" (or "wähle" in german),

[more...]

[category: computers & technology] [tags: , , ]