API / Named Ranges
Google Apps Script Documentation
Named Ranges
These are the current Named Ranges that are safely consumable by [email protected] projects. If there's data in the core Aspire Budgeting sheets you'd like to reference, please let me know and we can likely get a Named Range created for that data.
Values
Reference
Format
Notes
v_Version
String
A string that represents the version of the current spreadsheet.
Example: '3.3.0'
v_Today
Number
This value represents today's date in integer format.
v_ReportableCategorySymbol
String
Value: ✧
v_NonReportableCategorySymbol
String
Value: ※
v_DebtAccountSymbol
String
Value: ◘
v_CategoryGroupSymbol
String
Value: ✦
v_ApprovedSymbol
String
Value: ✅
v_PendingSymbol
String
Value: 🅿️
v_BreakSymbol
String
Value: *️⃣
v_AccountTransfer
String
Value: ↕️ Account Transfer
v_BalanceAdjustment
String
Value: 🔢 Balance Adjustment
v_StartingBalance
String
Value: ➡️ Starting Balance
Ranges (single column)
Reference
Format
Notes
trx_Dates
Range
Column of Dates on the Transactions tab
trx_Outflows
Range
Column of Outflows on the Transactions tab
trx_Inflows
Range
Column of Inflows on the Transactions tab
trx_Categories
Range
Column of Categories on the Transactions tab
trx_Accounts
Range
Column of Accounts on the Transactions tab
trx_Statuses
Range
Column of Statuses on the Transactions tab
ntw_Dates
Range
Column of Dates on the Net Worth Reports tab
ntw_Amounts
Range
Column of Amounts on the Net Worth Reports tab
ntw_Categories
Range
Column of Categories on the Net Worth Reports tab
cts_Dates
Range
Column of Dates on the Category Transfers tab
cts_Amounts
Range
Column of Amounts on the Category Transfers tab
cts_FromCategories
Range
Column of From Categories on the Category Transfers tab
cts_ToCategories
Range
Column of to Categories on the Category Transfers tab
cfg_Accounts
Range
Range of Bank Accounts on the Configuration tab
cfg_Cards
Range
Range of Credit Cards on the Configuration tab
Ranges (two dimensional)
Reference
Format
Notes
r_ConfigurationData
Range
A two dimensional array of the user entered categories and groups from the Configuration tab
r_DashboardData
Range
A two dimensional array of the values in the header of the Dashboard
Last modified 1yr ago