Sample Queried Spreadsheet Page

All sheets are dynamic, meaning a change to the sheet in drive updates the sheet displayed on the website (including updates from a user form). This same approach could be taken to show any queried results from one spreadsheet (e.g. creators and events) and displayed on any page in the website as single sheets. The requirements are that the rows be properly categorised with discrete data (consistent and error free), and that the sheets be made publicly available for viewing in sharing options.

All bloggers

This sheet is a embedded display of ALL the data. I can choose which columns I show – here I am showing them all.

Only Fashion Bloggers

This sheet is the same sheet as above, but a queried set of the data shows only bloggers who are categorised as “fashion” bloggers

Only Male Fashion Bloggers

This sheet is the same sheet as above, but a queried set of the data shows only bloggers who are categorised as “fashion” bloggers AND “mens fashion” bloggers

Test Credits:

Copy and Paste from live spreadsheet works

Avatar Skins Owner Profile Marketplace

Copy and Paste from embedded spreadsheet works

Aebleskiver Thibedeau nothing left to prove http://aebleskiverthibedeau.wordpress.com/ Fashion

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s