Bonus functionality and shortcuts for working with squib.
Include in your squib project:
bundle install squib-extensions
require 'squib-extensions`gsheet allows you to load Deck data using Google Sheets.
First, share your sheet using File > Publish to the web
Select 'Entire document' and '.csv' as the format
Copy the URL like
https://docs.google.com/spreadsheets/d/e/2PACX-.../pub?output=csv
^^^^^^^^^
The code you need to pass is the long ID after /d/e.
If the sheet has multiple tabs, you can specify a later tab using the gid from the non-share URL like
https://docs.google.com/spreadsheets/d/.../edit#gid=123456
^^^^^^
The gid is at the end of the URL after #gid=
usage:
deck = Squib.gsheet('2PACX-1..., 123456789)
Squib::Deck.new(cards: deck['name'].size, layout: ["deck.yml"]) doSimplifies the format for taking a subset of rows and applying it to the range parameter.
Replace:
one_widget = {} ; data['widgets'].each_with_index{ |w, i| if w == 1 one_widget[w] = i end }
text range: one_widget, str: deck['widgets'], layout: 'widget_label'with
one_widget = Squib.subset(deck['widgets'], -> (w) { w && w >= 1 })
text range: one_widget, str: deck['widgets'], layout: 'widget_label'Renders an avatar SVG image using using https://avatars.dicebear.com/. Uses the SVG-specified units and DPI to determine the pixel width and height. If neither data nor file are specified for a given card, this method does nothing.
usage:
avatar seed: deck['image'], library: 'avataaars', layout: 'person'result (if your seed is Jack):
Add the current card index to each card. Aids in locating the card in the CSV for making edits.
usage:
card_num x: 730, y: 1035