Reference values from views

Sheetnode doesn't currently support pulling data from other nodes or views. This could be a feature request.

However, did you try putting your calculations in a single view using a Sheetview style? You can place any field you want in the sheet, along with formulas.

I suggest the following:
* For each individual view, convert the view style from Views Calc to Spreadsheet. Set the spreadsheet template (in the Style settings) to place your fields, as well as an additional cell that contains the SUM function (or any other aggregate function).
* Then create a Sheetnode that references the external SUM cells in each view.

Sorry, my suggestion doesn't work because the spreadsheet that is generated by a view is currently not referenceable like ordinary sheetnodes. I'll think of a better way and get back to you.

I committed a fix to this feature request. Here's how to test it:

* Clear your caches
* In each of your sheet views, add a new Feed display with Style = SocialCalc format.
* Edit the settings of this style and make sure that "Inherit spreadsheet settings" is ON.
* In your overall results sheet node, refer to the relevant cells in each sheet view using the format "view_internal_name"!CellRef.

What's missing is the ability to send arguments and exposed filter values to the view, I'll be adding that in as well.

Let me know how it works for you!

Hello.
This is defiantly a great module.

"What's missing is the ability to send arguments and exposed filter values to the view, I'll be adding that in as well."

I would like to ask you if there is any improvement on this.

Thank you in advance.

@costas: no, not yet. Have you been using the view reference feature? Does it work well for you? If you need to send arguments and/or exposed filters to a view reference, please open a new feature request. I'd be grateful if you could post about your usage of Sheetnode as well :-)

I'm asking to re-open this issue because I have an almost identical use case as the OP, in D7, and have run into the problem of not being able to use the exposed filter on the referenced views fields. In other words, I have a master spreadsheet which references views calc fields from many other pages in the same view, but I am unable to use the exposed filters to filter the referenced data in the main spreadsheet. Has there been any progress on this issue, as I see Karim makes reference to this issue in post #9 above.

CobraMP = Did you ever come to a resolution on this? As I said, my use case is almost identical to yours.

Thanks very much.

@devnyc, if I understand your post correctly, you want to send exposed filter values to referenced views. Is this what you mean? Right now, only arguments are supported, and they have to be explicitly entered (as opposed to being read from the URL for example).

Ok - was hoping there was at least a workaround I could implement to solve this issue. Thanks for the response.

Hi @infojunkie,

Any progress on the above, i.e. sending exposed filter values to references views? If not, could you provide a little guidance on the alternative you mentioned above, i.e. explicitly entered arguments?

Thanks

The syntax for referencing an external view from a cell is:

="view-name/arg1/arg2/..."!A1

where argN are the arguments defined in the view as contextual filters. Note that this external view *must* contain a feed display of type "SocialCalc". This is the display that is used to get the referenced cell data.

Thanks, Karim. I've noticed however that on export, these references do not translate. For instance, for the reference "view-name/arg1/arg2"!A1, the arguments work on the spreadsheet view, but on export they are ignored and the cell value is equal to the value of "view-name"!A1, as if there are no arguments. Which over the course of a table, renders the same values for all columns in a row.

Any ideas?

Thanks.

Exporting references should pull the referenced sheet as a new worksheet in the exported file. If that's not happening, please open a new issue. You can close this one if the references as I described them are functioning properly.

Closing because the references as infojunkie describes them are working properly.