#theme help: spreadsheets

[nonspace]

Hi! I've been trying to add Magnus' Isotope Combo Filter to your Succulent for the past couple of weeks with zero success. I've reached out to other people who know coding better than I do (I'm a wee novice), and they said that the filtering built into Succulent won't work with Magnus's combo. I'm very confused. Any guidance would be most appreciated (@ angieshenanigans). Hope you have a good week!

Hi! It does work it just needs some extra steps 😅

I made a version with combo filters for my MIRROR IMAGES theme which uses the same set up as SUCCULENT. You can have a look here: https://github.com/n0nspace/tumblr-themes/blob/main/sheet%20pages/mirror-images/mirror-images-sheets-combofilters.js

The main thing is that the combo filter script needs to be places within the buildLayout() function. That's where you can find isotope as well.

[nonspace]

hi is google sheets integrations still funky? i can get the dropbox version of my spreadsheet to work but not straight from google sheets

Hi! It should work if you follow the updated instructions. Perhaps you're still using an old version?

If that isn't working for you, there may be something else going on. But I'm not able to tell you what without seeing the page or your setup. You're welcome to drop the link to your page in an ask or chat message and I'll have a look. (Please note though that this may take a while depending on when I find the time).

Alternatively, maybe other folks on my discord server may be able to help you along.

[nonspace]

hi! i have a question about integrating spreadsheets on codes! i already made my own code (a simple characters page without images) but i haven't made up my mind about the number of links i want to include. i want to have the option to have 3-6 links, depending on how many tags i need in the future. would it be possible to add columns i can leave empty if i don't need those?

Hi! It's been a while since I did anything with that code but if I remember correctly, you should be able to have empty cells in the current version! You'll want the headline cell filled out to be able to add it to your code though but, depending on what your theme looks like, should be able to leave the content empty.

If that doesn't work out and/or you have more questions it'd be helpful to see your actual code. 😄

[nonspace]

Spreadsheet FIX

For all those impatient to get their pages working again, here's the very quick 4-am-I-should-sleep-update:

For MIRROR IMAGES & DEJA VU (spreadsheet version)

Find "SheetID" under page settings and replace it with:

const sheetID = 'YourSheetID'; const sheetTab = 'YourSheetTabName'; const APIkey = 'YourGoogleAPIKey';

How to get an API Key?

Go to https://console.cloud.google.com/projectselector2/apis/dashboard (of the account the sheet is under)

Create new project

Create credentials, choose API key (copy this)

Libraries > search for Google Sheets > Enable

For SUCCULENT:

I’ve updated the entire code to use the same scripts as the other spreadsheet themes. If you don’t want to replace the entire code because of changes, check out the version history on GitHub. Will write down the details soon. https://github.com/nnspce/succulent/commit/2376140959fa20e5555a2aed8077653f12865fa1#diff-c7554cfe9adb429454a2b7f18f38c23598b1c6e1c2cd07cb98b6faaf5799048f

To do:

Write a proper guide

Update Spreadsheet How To page

Something else probably

DISCLAIMER: It is 4 am, something’s probably wonky still so proceed with caution. Let me know any bugs you find. 

[nonspace]

Update: Spreadsheet Pages

This update concerns the spreadsheet version of the pages: DEJA VU and MIRROR IMAGES (not SUCCULENT)

After the spreadsheets were loading only very very slowly. I’ve updated the spreadsheet script “nnspc-sheets.js” with a (for now) working solution.

What changed?

The pages no longer use a cvs download of the spreadsheet and instead pull the json data directly as it used to be (and still is in the SUCCULENT page).

The sheet no longer relies on/uses Papa Parse and uses my own script. However, I’ll leave it in the pages for now in case we’ll need it again in the future to be able to update people’s themes without you needing to do anything.

The page no longer relies on a CORS service. (which I think might have slowed down the load)

IMPORTANT: You can no longer have empty cells.

Since Google changed a few things with their API this shouldn’t be working any longer? But it does. I haven’t been able to find any documentation about this particular version of the link, I just know other, similar links making use of the feeds endpoint don’t work.

If things change in the future, I’ll have to update the script again.

What do you need to do?

Hopefully nothing.

If your page is no longer working:

If you’re not using the dropbox version: Check the link you’re using under “SPREADSHEET INTEGRATION” it should be: https://www.dl.dropboxusercontent.com/s/wlxk3q4wkqxescn/nnspc-sheets.js

For the dropbox version nothing changed here

Old versions: nnspc-sheets-2-0.js, mirror-images-sheets-3-0-pp.js, possibly others?

Let me know if things aren’t working as they should and I will have a look at it.

With that said, I’ll also be updating the SUCCULENT script to use the same set up as the other two pages which will also make it easier to use.

DEJA VU NOTE: Take out the empty row that was in the Deja Vu spreadsheet by mistake. It won’t work with it. The downside of this way of doing it... it can’t handle empty rows.