What’s a good workaround for having a global parameter, that is to say a value that stays the same for all records but might be used in multiple formulas in various Fibery spaces?
Some example of “global parameters”:
I sell dog toys, to calculate profit margins on various SKUs we have a lot of costs that are specific to each SKU but also costs that are the same for every product such as: default shipping materials cost, default prep labor cost, etc.
I manage an orchard, we have a lot of formulas that calculate when to do certain orchard management activities based on a few specific dates (last frost date, first bloom, etc.) these values are updated once a year
I want to create a really fancy birthday event planner Space where a lot of the formulas are based on the parameter myBirthdayDate. I want to share this space with another person but instead of telling them to update all the formulas with their birthday I want them to just change it in one place.
Unfortunately, formulas are limited to only using fields in the database where the formula lives (or fields belonging to linked databases) so any solution will be klunky, requiring relationships to one or more of the ‘Global store’ database(s)
Probably ends up being at least as much hassle as ‘hard-coding’ the parameters…
There might be something you could achieve using automations, since automation formulas can utilise ‘database queries’.
So you could have a database called Global, with fields for every datatype (Date, Number, etc.) and then you can query that db:
Of course, using automations to populate field values has disadvantages:
it needs to be triggered by something, and the result can be manually overwritten.
But perhaps you can think of ways of living with those drawbacks…