Anybody remember Hypercard? Ahhh, first love…
Anyhow, if I recall correctly, Hypercard gave you the ability to define local and global variables. The local variable type was specific to the card it was one, while the global variable applied across all cards. Translating to Coda-ese, I’m wondering if there are section-specific variables as opposed to variables which apply across the entire document.
My use case: I have a table of projects, where each project is a row. I want to have a section in my document for each project. On that section, I use formulas to dynamically insert data from columns (from both the base table and related tables). The only thing that differentiates the formula for the Project A section from the formula on the Project B section is the value of Nth(). On Project A section, the formula includes “Nth(1)” and on Project B section the formula includes “Nth(2),” etc.
Right now, I have to manually change every formula on every section, and do the same for new section. What I would like to do is use a local variable (or even a constant) from the page, as in Nth(thisPage). I would set the value for each page manually, but I wouldn’t have to change the formulas from page to page.
Anybody have an idea of how this could be done?