Hey TF Gurus! I’ve peeked at the template exchange and didn’t see anything. I’m embarking on a new TF database project: a repository for household expenses, specifically for organizing home-buying associated receipts (hooray!).
As a secondary purpose, I’d like to capture monthly expenses, likely through data-mining electronic downloads of my bank account.
My idea now is to use a similar framework as I have for my business:
Form 1: Companies
Form 2: Expenses
Form 3: Expense Categories
Picklist 1: Created from Form 3, used on Form 2
Form 1 joined to Form 2 on Company Name
Form 3 joined to Form 2 on Expense Category value
I’d consider myself a firmly average user of TF. I can code in Python, but don’t know any JS. Just looking for any friendly advice or ideas from other users, or inspiration to spend the time to develop some scripting knowledge, for example to automate the record creation from the bank download.
Thanks for reading!
I guess you can only edit a post twice? The edit button disappeared. I want to update this post as I tweak the design.
My idea now is to use a similar framework as I have for my business:
Form 1: Companies
Form 2: Expenses
Form 3: Expense Categories
Picklist 1: “Company Name” Created from Form 3, used on Form 2
Picklist 2: “Expense Category” Created from Form 1, used on Form 2
Form 1 joined to Form 2 on Company Name (picklist)
Form 3 joined to Form 2 on Expense Category value (picklist)
I believe it’s a timing issue with being able to edit a post. I think it’s 30 minutes or something like that before editing is disabled.
Turns out it’s 20 minutes before editing is disabled.
.
