I'm trying to take input from a user and then do some sums based on that input. I thought I should be able to this using sheetnode and views; something like this:

A1 contains =B1*C1
B1 contains a fixed value
I want to use a view's argument as input for C1, i.e. something like C1 == %1

There are a couple of issues that seem to suggest this is possible, but I was unable to understand the solutions given, so please forgive me if I'm duplicating effort. Is it possible? If so, how? If not, could someone give me an alternative?

Thanks in advance....

Comments

glowkeeper’s picture

glowkeeper commented

infojunkie, some code you posted in reply as to how to pick up data from sheetnode cells in cck computed fields gives me a way of doing this (http://drupal.org/node/946526).

Using that method, I've been able to get input into a cck numeric field from a user and then use that data in a computed field which references fixed values in a spreadsheet. Neat :)

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Fixed

You can also use the spreadsheet function ORG.DRUPAL.PARSEURL which gets the value of a key in the URL query string (e.g. http://mydrupalsite/node/1?key=value).

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

(not verified) commented
Issue summary: View changes

Didn;t think my first post was very helpful so I've amended to try and be more so :)