I’m glad to share the app for family finances. Meet Finanso! Our family is happy using Finanso for 3 months so far.
Finanso is powered by Glideapps.
Glideapps ensures the data is synchronized between spreadsheets and the App. When I enter the data to my phone, I see it in Google Sheet and vice verse.
GlideApps _______________^_______________ | | 📱 Mobile App ←·→ 📗 Google Sheet
Glideapps is a no-code constructor for mobile apps. It allows to create and develop a fully customizable mobile app:
#gallery-0-9 { margin: auto; } #gallery-0-9 .gallery-item { float: left; margin-top: 10px; text-align: center; width: 33%; } #gallery-0-9 img { border: 2px solid #cfcfcf; } #gallery-0-9 .gallery-caption { margin-left: 0; } /* see gallery_shortcode() in wp-includes/media.php */
Easy to change all, even the icon
Their beautiful web-interface lets change every little detail of the app, even the icon. I love it! 😍
Anyone can create as many free apps as she wants. The limit for free usage is 500 rows per app.
Quiz: Create a Free App Limit: 500 rows of data, according to Pricing Growth: My real data is growing with the speed ~4 rows a day Time left: We have about 4 monthes to exceed the limit Task: Create a free app. How?
I thought of limiting the amount of data in the app. My needs were: daily expenses and the report. I wanted to copy my daily data to a separate spreadsheet. I did not know the real amount of data at the time and decided to clear the data daily. Happily, no need to copy and modify data manually, Google Script does it for me:
GlideApps Google-Apps-Script _______________^_______________ _________^__________ | | | | 📱Finanso App ←·→ 📗Finanso Sheet ←-----·→ 📗Fananso Backup Sheet
Every night the Script does his job. The script reads the data we entered, converts it into tabular form, copies it to the Backup file, clears entered data, and creates the report.
The limit was 500 rows, I’ve done with 24:
I’ve spent about 5 hours on developing Finanso. You may see the result and create your own copy, of course (see how in the next section)!
Finanso has two separate tabs for my wife (Lu) and me (Max):
Here’s a sample usage of Finanso. You spend $500 and need to enter the expense. Your actions are:
go to your tab: ( Max for me, but could be your name),
fill in Sum (500) and Comment (For Mum)
There are 5 slots for Sums and Comments. We’re usually alright with 1-3 entries per category, so 5 must be enough.
You’ll need to enter every expense into Finanso. As a reward, you’ll have a report like this:
The report adjusts every 24 hours. It is always up-to-date, showing the last 30 days stats. The expenses are sorted by sum. The total is shown at the top. Each row is clickable.
You’ll also have the backup — the Spreadsheet with all your data:
Separate data table: my Backup Spreadsheet
Installation is not simple yet, I’m working on it 👷♂️… If you’ we read so far, then you may be still interested in your own Finanso app (I hope so). Please follow these 2 steps to setup:
Copy the app & linked file.
Copy the backup file and script and create a trigger
To get the app, follow this link on your PC:
https://finanso.glideapp.io
(be sure to open the PC version)
You’ll see the page like this:
↑ Click COPY THIS APP button $)
You’ll need to create a new Glideapps account.
When you copy the app, you’ll be redirected to your GlideApps editor:
↑ The place where you create and modify the app.
You’ll see the newly created app, your copy of Finanso. This copy will belong to your account, and no one else will have access yet.
You may then easily modify and share it. Please see the guide here: https://www.glideapps.com/learn-to-glide
One more thing, you’ll also have a copy of the linked Google Spreadsheet. Please open it via editor:
Click Edit sheet in the left panel of the editor to see the file. This will open the spreadsheet in a new tab:
↑ This file will be also a part of your Google account, so you could also find it in your Google Drive. Please copy the ID of this file, we’ll need it later. To copy the id, go to the browser URL:
You’ll need this ID in step 2.
Step 2. Copy the backup file and launch the code
To get the backup file, follow the link:
Copy Finanso Backup (Spreadsheet + Code)
As you start using the app, please delete the data from sheets: \Data/ and \Dates/. These sheets contain sample data, and you’re going to create your own!
↑ The Backup file contains dummy data. Please delete it.
Now you’ll need the ID from Step1. It was an ID of the linked file. Paste this ID to the sheet \_Jobs_/ to the cell B2:
Now the script is ready to go. You’ll need to launch the script to run on a daily basis. Go to menu Tools > Script Editor to see the code (or use a keyboard [Alt → T → E] in Chrome).
↑ A new tab with the code
The code is here, but it does nothing yet. You’ll need to create a trigger. Click on the timer icon (1) and create a new trigger (➕). The function of a trigger is called test_Jobs (2). Please use these settings:
Your own app is ready now! The bad news is that your copy is currently running on the same tabs as mine. You may ensure it if you go to your linked Spreadsheet, you’ll see 2 tabs: Lu and Max. You may also notice that the app has the same 2 tabs: Lu and Max.
I assumed that your family needs the same 2 tabs and you’re ok to name them Lu and Max. It is not true of course! I also assumed that your expenses have the same categories: Food, Life, Party, Gifts, Health, Clothes, Rent, and Other. This may be true, but I doubt it.
Let’s fix this inconvenience and modify Finanso to your needs. I’ll cover the engine details and modification points in Part 2.
Family Expenses App. Glideapps + Google Script. Part 1 of 2 👋 Greetings! I'm glad to share the app for family finances. Meet Finanso! Our family is happy using Finanso for 3 months so far.
