What I’m trying to do
I am trying to set up a template that includes the use of data view functionality to perform basic calculations. The intent was to be able to store the variables in a table. Access that table to perform the calculations.
Things I have tried
FROM [[Input Values]]
compute answer:: number = val1 + val2
The parsing fails on line 3 “compute answer”
Could someone with more experience in this topic provide guidance?
I don’t think that’s possible with dataview, because dataview works on frontmatter/metadata & notes, not on table values or tables for that matter.
You may want to check out the Numerals or Solve plugins instead, which allow creating inline formulas (look at their published screenshots), but they don’t work with tables either afaik.
If, however, tables are desired, you may want to look at the Excel plugin, which allows creating Excel-like tables that can be embedded inside notes along with calculations (look at its published screenshots)
I was headed down that path because of this video:
(14) Obsidian - Dataview (Lookup Table) - YouTube
I think you’d be better off with the Excel plugin mentioned earlier, which is easier to use than writing a lot of boilerplate custom JS code, which is not even guaranteed to be possible.
But hey, if someone else has another idea or can think of an approach to tackle this, I’ll be all eyes & ears.
If you want to do simple calculations within the table in a given note you might also use the advanced tables plugin. Then you set up the formulas under the table, and hit the recalculate button every now and then when you change the input.
Woah, didn’t know advanced tables supported formulas, I thought it was just for designing tables.
Thanks for the update, cool beans!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.