Comments (4)
Actually, I've been wondering about this for a while as well, so I decided to do some research since I'd like to use this repo to setup my own finances, and this question seemed important. I think the reason why it's not in the docs or readme is because there isn't a simple way to do it. Arguably, that's exactly why it should be documented.
If I had to guess, adding a template during setup was supported in 1.x.x via the setup script, and somehow this didn't make it to 2.0's setup script. But porting the config from 1.x.x supports persisting the template. So all the old users (and developers) that were already using the software are happy, and new users either give up or just don't use a template.
You need to manually edit the mintable.jsonc
config file. The config file has an "integrations" field. You'll need to modify the google
entry (from here)
Within the Google config, you have a template field:
export interface GoogleConfig extends BaseIntegrationConfig {
...
template?: GoogleTemplateSheetSettings
}
Of type GoogleTemplateSheetSettings
Now, I haven't tested this yet (will update once I do), but I believe something like this in your config file should do the trick:
mintable.jsonc
{
...
"integrations": {
"google": {
...
"template": {"documentId": "....", "sheetTitle": "Title of the template sheet."},
}
}
from mintable.
Thanks for the help, this worked for me. Since this seems to still work past 2.0, it would be nice if this feature was referenced in the documentation, unless it's deprecated (sad if that's the case).
For anyone else trying to achieve the same thing, make sure to delete existing sheets to apply the template, because existing ones don't seem to get completely overwritten if you suddenly add a template. You also don't have to make another google sheets document to make the template, since in the config you are providing the document id and the sheet title.
from mintable.
Thanks for the help, this worked for me. Since this seems to still work past 2.0, it would be nice if this feature was referenced in the documentation, unless it's deprecated (sad if that's the case).
For anyone else trying to achieve the same thing, make sure to delete existing sheets to apply the template, because existing ones don't seem to get completely overwritten if you suddenly add a template. You also don't have to make another google sheets document to make the template, since in the config you are providing the document id and the sheet title.
Can you tell me how you implemented this change? I don't know how to use my own fork.
from mintable.
@Sean0203 Any update on this? I am trying to implement this myself, but I am not understanding how it is supposed to work. So, I create a spreadsheet that uses data from my transactions (like any sum formulas and whatnot) and then when I implement this change is it supposed to automatically move my formulas to the new month?
from mintable.
Related Issues (20)
- Include URLS in mintable setup to allow browserless setup HOT 1
- Error: Unable to set up Plaid Integration.
- Where to find Transaction.rules and how to edit institution names HOT 2
- Error: Error exporting account=<redacted> HOT 1
- Setting start date or count of transactions to download HOT 2
- Plaid not connecting HOT 3
- How do I get non-US bank support working? HOT 4
- Regex findPattern for empty google sheets cells?
- How do you prevent having to change google api credentials?
- Enhancement: Allow user to define transaction time grouping in place of Month Start - Month End default behavior
- Plaid accounts not actually being added
- Access token only lasts a day. HOT 1
- country_code no longer working HOT 4
- No sign in link opening in browser HOT 1
- Allowing another to commit to master?
- How to use my own fork over the original?
- Error: Error creating Plaid link token.
- On June 20, 2024, the Plaid Development environment will be decommissioned. HOT 1
- authorized_date not getting data HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mintable.