I am currently developing a finance app and I'm trying to implement a function which ranks the categories that the user spent their salary on. Here's how it going to work:
The app calculates the budget and actual amount of the user’s expenses for each category, it will make a list of the budget and actual amounts for each category.
The app will then find the differences between the actual amount and budget amount for each category.
The app will then rank the list from the smallest to the largest differences in budget and actual for each category.
The app will then take that ordered list of categories and insert it into a temporary database.
The app will then turn the differences in each category that it represents (Home Expenses, Utilities, Food, etc).
The app will then display the text from the database into the notifier that will pop up.
I've so far done coding all the procedures up until procedure/step/number 5 where the app will turn the sorted differences into their supposed categories. I have attempted this by using dictionaries but it gave me an error message. I've searched for solutions and played around with the blocks to try to find a solution for way too many hours. Below are my blocks and project download, if you see something wrong with my blocks, please reply to this post ASAP. However, if anyone has a different way of doing this in a more efficient way, please feel free to send out your method of how you would achieve this.
PS: in the project, the blocks in the screenshot can be found in the near top right hand corner of the blocks
You open Screen1 instead of closing your current screen
Your blocks image looks like a box of combs, because you did not work from lists and use parameterized procedures, which would have reduced your number of blocks by 90%.
The month is a data value like 202112 (December 2021), not a name that needs to be hard coded in blocks.
to init a global variable with textbox.text values is useless, since the init happens at screen startup, before the .text values have been typed in. Better to init global variables with the textbox components in a list or dictionary, matched against their categories ('home', etc.) so you can loop through them later.
More errors:
You have an Windows executable file in your Media folder, masquerading as an mp3 file, like a Trojan. Run a good virus checker on your PC and delete that useless evil file.
You kept your head down and grinded away in error for to long before coming up for air to ask for advice.
Here is a table (list of lists) structure for your data, that will let you do your data collection:
month (yyyymm format, like 202112)
category name ('home')
budgeted money amount (999)
actual money amount (000)
Here is the Lists FAQ, which has several sorting solutions:
unfortunately not, as @ABG already explained earlier
you first should do some more tutorials to learn the basics...
additionally it does not make much sense to copy blocks like you did for each of the categories.... and this is only one month... now the same monster block for the other months? you are repeating over and over again...
Oh... now I'm confused about this table. So am I supposed to do this in a csv document? I am not so sure on how I'm supposed to complete the table correctly. I'm trying to understand the document that @ABG shared with me. I've honestly never attempted something like this on App Inventor before. @Taifun
Also, when I complete this table/database, am I able to turn the values back into their specific categories? Or is this supposed to replace the TinyDB that I've implemented into my code? Pls explain. @ABG@Taifun
I'm not sure on how my csv sheet is supposed to look like. What is the format or do I just add commas? What are those symbols highlighted in black? I think I can work it out if I understand how csv sheets work in App Inventor since I can understand majority of the blocks in this post and your documents so far. Pls explain how I can create one properly. Thanks!
The CRLF in black is Notepad++'s way of telling its users there are two otherwise invisible characters (carriage return and Line Feed) at the end of each line, typical of a text file on the Windows platform.
How is your CSV file supposed to look like?
A CSV file is typically used to transport a table across machines as a text file.
If you want to transport your monthly budget and spending data by category,
your CSV file would contain 4 columns, as I described at Turning Ranked Numbers Into Word Tags - #2 by ABG
Comma Separated Values (CSV) files have the data items in each line separated by commas (,). Don't ask for trouble by putting commas inside your data items without protecting them with quotes ("Bond, James Bond"), otherwise your column count will be off when you try to read that row.
CSV files, while good for data transport and long term storage, are inconvenient for updating and accessing individual data items. TinyDB would be easier during the current month, if you built tags containing enough information to home in on just the value you want to retrieve and update, like
tag : value
202112/snacks/BUDGETTED : 20.00
202112/snacks/ACTUAL : 25.00
202112/travel/BUDGETTED : 50.00
202112.travel/ACTUAL : 20
(Bottom line, I stayed home and snacked this month.)
Every day as I spend money, I would retrieve the ACTUAL for that item and update it in TinyDB.
At end of month, I would take a TinyDB Taglist, and build a CSV file for export or an in-memory table if I want to do list manipulation (filtering, sorting, summarizing.)
Ohhhhhh, everything makes sense now! Thanks a lot! I don't need the CRLF right since I don't use notepad++ or do I need it? If it is required, how am I supposed to find that symbol? Thanks again for the detailed explanation!
