Allow referencing variables from other sheets
complete
Mike Schinkel
This is similar to allowing global variables to be defined in a sheet, but is not actually the same thing.
Basically I am asking for access to variables in other sheets like you can do in a spreadsheet like Excel or Google Sheets. This would mean a sheet would need a name, likely the heading but it would be good if a user could optionally give is a more concise name, maybe like the first image.
Then in another sheet be able to reference those variables with a qualified reference something like in the second image.
Zac @ Soulver
complete
Defining variables in a "definition header" and using them across multiple sheets (tabs) in a document is a tentpole feature in a new experimental version of Soulver called X1. More details here: https://soulver.app/x
M
Mark Aronszajn
Zac @ Soulver This is great, but how do we try it out? I've looked through the site, https://soulver.app/x but don't see a way to download/install it. And btw if X1 is installed can it run in the same environment as Soulver 3.11.2 without conflicts?
Zac @ Soulver
Mark Aronszajn: Soulver X1 is available on GitHub to sponsors of any amount.
More details here: https://github.com/sponsors/soulverteam
There is no conflict with running it on the same Mac as Soulver 3, they're completely separate apps.
M
Mark Aronszajn
Zac @ Soulver... I committed a modest amount as a monthly donation, and it says that I'm now a sponsor, but I still don't see how to download the current stable version of Soulver X1. Can you provide some directions please? Thanks.
Zac @ Soulver
Mark Aronszajn: As a monthly sponsor, you get access to a private GitHub repository which contains X1 and some other Soulver goodies (also eventually X2, X3, etc as they are created).
Zac @ Soulver
Merged in a post:
Set global variables within sheets themselves
It would be excellent if I could set a global variable in a sheet, rather than only in the application settings. e.g. "Expenses" is a list of all my monthly costs, which are summed into a global variable, which I can then refrence via my "Income" sheet. Thus adding or removing expenses automatically updates my Income sheet.
M
Mark Aronszajn
Any word on when you'll have this feature released? I await each new Soulver version with eagerness because I know it's planned :)
Zac @ Soulver
Mark Aronszajn: It's part of a larger feature that's still in development. The iPad app is currently my #1 priority, after that I'll be back on this.
M
Mark Aronszajn
Zac @ Soulver: Thumbs up! Soulver rocks...
Zac @ Soulver
planned
M
Mark Aronszajn
Zac @ Soulver: Great!
M
Mark Aronszajn
Or a different approach for the same benefit would be to allow imports of properties by referencing source sheets ('#<sourceSheetName>') at the top of the working sheet, as in bash/z-shell property files.
M
Mark Aronszajn
Yes, please, or in the manner of interpolated variables in Apache Configuration .property files. Source a specified sheet at the start, and then reference values of any variables defined in that specified sheet using '${VAR_NAME}'