What i can understand from the description on the Drupal project page of Sheetnode, is that it integrates to some extend with Drupal nodes and fields. It says also that calculations are possible inside the Sheetnode.

My question is the following: would it be possible to create a Sheetnode, which contains cells that are field references of other nodes, and that there also cells that contain formulas that apply calculations to the referenced cell values?

What I am looking for, is a sort of replacement or improvement of Views in order to perform calculations on field values.
Currently Drupal is lacking with regard to calculations and modules that support calculations between entities and fields.
The Views Calc module has no Drupal 7 version yet, and it appears also to be quite limited in its formulas.
There is also the Views PHP field, but that cannot be used to perform calculations in Views, as far as i know.

If my idea mentioned above is possible, then Sheetnode would be the ideal solution where a lot of people have been waiting for (or at least me), which is using a spreadsheet to perform calculations between nodes/entities and fields.

Comments

scott859’s picture

scott859 commented

subscribing

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Fixed

Yes, it's possible. Here's how:

The spreadsheet function ORG.DRUPAL.FIELD(field-name, oid, entity-name) allows you to read any field from any entity, given the entity's ID and type. You can insert these values in your formulae.

You can also create views with the Spreadsheet style that can perform such calculations on all results. Please check this issue for more information: #1229312: Is there documentation for view field calculation format in spreadsheet ? .

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.