@petrs @olgatrykush Hi everyone! Can someone help me?
I’m using Baserow to store some personal financial management data. I made a csv list of the main banks in Brazil that operate in the financial area. My idea would be to have a list of banks that I can check if they are present in the bank slips I pay monthly on things like: netflix, amazon, online games, etc.
For example, let’s say I’m going to enter a value of 100 $ for some cloud service that I pay monthly, the cloud service company usually has a bank associated with this. So, I add to the base rom the value of 100 dollars that is associated with this company with which I have a contract. In that sense, my database shows the list of banks.
I check the amount of the bill that was paid and the associated bank. So I have a list of permanent records on the inflows and outflows of my personal money. It turns out that in my case, I have some people I want to share my personal expenses with, for example, my husband, husband or girlfriend.
Hence the problem, this person who is with me has another bank account to which he also makes payments. That’s why it’s interesting to have a list of banks - because when you share it with someone and if someone is interested, you can create your own list of bank records to which you are associated with a bank of your interest.
These data that I have access to here are open data. So the license is open - that is, it is public and available to anyone. This same list of banks that I put could be used for several countries. There is one more problem: we can have different banks for each country, which can be difficult to maintain in the Baserow database.
So I wanted to share this template on Baserow as the list would be updated from person to person so I don’t have access to someone else’s finance data, only the list of banks people make updates to in the template from Baserow.
a good visual example:
a good source-code example 1:
id,code.bank,to describe,bank.name,recurrence,year,type,value
2,003,food,BCO DA AMAZONIA S.A.,diary,26/08/2022 02:46,output,20
128,265,clothing,BCO FATOR S.A.,monthly,01/08/2022 02:46,output,20
174,630,apartment,BCO INTERCAP S.A.,monthly,10/05/2022 02:46,output,5
200,202,netflix,BCO INTERCAP S.A.,monthly,08/08/2022 02:46,output,10
201,111,money,BCO FATOR S.A.,monthly,18/08/2022 02:47,input,100
a good source-code example 2:
https://pastebin.com/raw/if7tC9Ui file.csv