md-advanced-tables icon indicating copy to clipboard operation
md-advanced-tables copied to clipboard

Support for regular text in formulas

Open patrickcjwall opened this issue 3 years ago • 3 comments

Hi,

Thanks for this really super plugin. One thing I would love to be able to do is include further text in the output, like you can do with a formula in excel using quotation marks and the ampersand - eg: entering ="The answer is "&1+1 in excel results in The answer is 2

This would be particularly cool for automatically generating links to notes of meetings in my daily note. I could put in the name of a person I was meeting with, for example, and the plugin could automatically generate a link to a new note of the meeting, like this:

Meeting Note
John Smith [[Meeting note: John Smith]]

Using the Excel approach, the formula could be something like $2="[[Meeting note: "&$1"]]"

Or maybe this is already possible and I have missed it?

patrickcjwall avatar Nov 05 '21 08:11 patrickcjwall

Hello, this definitely isn't current possible, but is probably something that could be added. This is a larger feature though, so I'm not sure when I will be able to work on this.

tgrosinger avatar Nov 26 '21 16:11 tgrosinger

Thanks for considering it!

patrickcjwall avatar Nov 27 '21 09:11 patrickcjwall

Just wanted to add a vote for this feature. My use case is due to wanting to have inline Dataview strings in my table next to a link, something like this:

| [[Moonrise Kingdom]] | `=dateformat([[Moonrise Kingdom]].last-watched, "dd-MM-yyyy")` |

In this scenario, it would be really useful if I could automatically have $1 placed into the middle of that Dataview string in $2.

bendodson avatar Feb 23 '24 14:02 bendodson