So I've create a view of type sheetnode that uses a template to display sheetnode types. The basic functionality is all there, which is great. For my own uses, these sheetnode nodes have a spreadsheet plus some other fields added via cck.

I would like to have my view template not just grab the fields (which it does perfectly) but also grab certain cell values from each sheetnode. Unfortunately, the only way that seems to work is with the following syntax:

"Node name"!Cell reference or "nid"!Cell reference.

Which works, except that I want to use something like $(Title)!d2 in the template since each row represents a new node. And that does not work. What am I missing?

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented
Category: bug » feature

That's a feature that's not in the module currently. I'll work on it.

infojunkie’s picture

infojunkie
Location Vancouver
commented
Version: 6.x-1.2 » 6.x-1.x-dev
Status: Active » Fixed

Fixed in the latest dev release. Please try it (12 hours from now) and let me know if it works.

To reference an external sheet in the template, use the following syntax:

${"$nid$"!A1}

Note that the quotes are necessary because the SocialCalc engine expects them. You can use nid or title as an external sheet reference. Of course, replace A1 with whatever cell reference you need.

zunix’s picture

zunix commented

Karim,
You ROCK! Test and works perfectly.

Thanks very much for the quick turnaround. You've done the Drupal community a real service integrating SocialCalc. Keep it up!

Alf shakur,
David

Status: Fixed » Closed (fixed)

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