I am using sheeted, and token to reference values from a sheetnode into a field of a different node. I manage to get the values, but not the format. Is there a way to add token that will return the text value of the cell as formatted?

Comments

shaisamuel’s picture

shaisamuel commented
Title: Referencing the formatted value of a cell using token » How to format the result of value shown in node using token and entity reference?

I appreciate this module very much.
After some testing and trail and error, I manage to get correct value using EntityReference field, which relate to the sheeted I need. The token looks like [node:field-refsheetnode:sheetnode:cell:B6].
Originally in the cell there is value formatted to show custom format "$"#,##0. Using something like [node:field-refsheetnode:sheetnode:cell:B6:custom:"$#,##0"] (I am guessing here).

delacosta456’s picture

delacosta456 commented

hi shaisamuel
i would like to know how you build with Entityrefeence.

What i have already done

- I already have two spreadsheet with formula saved as template . In both spreadsheet the result of formulas cell depend on value entered in another cell.

Now what i want is:

- Create a node type with some fields:
-fieds that will hold values that will be sent to spreadsheet cells in with values are suppose to be entered
- field to select a template that will be used when submitting the node

--------------
i have seen in documentation that it is possible to use Token , and node id... but what off if didn't know the node id on node creation, how will spreadsheet cell will get value?