Referencing Cards in Formula

One of the most powerful features on Snapboard is the ability to reference other cards in any formula - similar to how you can reference other tabs in Excel formula.

Every card on Snapboard automatically has a set of associated data - you can think of each card as it's own mini-spreadsheet or tab, and you can view a card's data by selecting "View Data" from the card menu.

Formula references on Snapboard look a little different to Excel, but they're still easy to understand. You just need to include the name of the board / name of the card (enclosed in #) - e.g.

#Name of board/Name of card#

If both cards are on the same board - then you can omit the board name, and simply use the name of the card.

#Name of card#

Selecting a subset of card data

Using the above, will reference all the data associated with a card (like referencing an entire tab in Excel) - but sometimes we just need a subset like an individual cell value. 

Different cards store different types of data, and you can see this by selecting "View Data" from the card's menu (and looking for the type at the bottom left of the window).

[Insert image of viewing a card's type]

Here's how you reference each type of data.

1. Basic Values - Numbers, Strings, Booleans - are already the smallest unit, so just use the card reference (as above).

#Name of board/Name of card#

2. Tables - are similar to an Excel spreadsheet - you can reference these by row, column or both.

Use the @ character to reference a column:

#Name of board/Name of card#@Column Name

Use [row index] to reference a row (rows start at 0, not 1):

#Name of board/Name of card#[0]

3. Hash -  a hash can be referenced using a dot and then the name of the field.

#Name of board/Name of card#.Field in Hash

4. Arrays/Lists - can be referenced using square brackets and the position in the array (starting from 0).

#Name of board/Name of card#[0]
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.