B4A-budget app tutorial using B4X pages, a tabhost, a SQLite database, a CLVDragger class and a calendar dialog library class.

P

PaulMeuris

Active Member

Licensed User

• May 28, 2022

• #1

In this step-by-step guide you can build a budget app.
You will be using code from the previous tutorials (B4A-lists and B4A-calendar).
A database class will be set up to use SQL queries to add, change or remove records from database tables.
You will also learn how to use 'prepared statements' to prevent SQL-injection.
The app uses dialog views for the database changes and for the selection of a date.
Check it out via this link: B4A-budget
Happy coding!

 

Last edited: May 28, 2022

Xfood

Expert

Licensed User

• May 28, 2022

• #2

congratulations, nice app, and for a while I had in mind a similar app, so simple, and very useful

 

P

PaulMeuris

Active Member

Licensed User

• May 29, 2022

• #3

Xfood said:

congratulations, nice app, and for a while I had in mind a similar app, so simple, and very useful

Click to expand...

Thank you for the kind words, Xfood.
Did you implement the assignment at the end of the tutorial?
Greetings,
Paul

 

Xfood

Expert

Licensed User

• May 29, 2022

• #4

not for now, as soon as I find some free time I'll do it

 

LucaMs

Expert

Licensed User

Longtime User

• May 29, 2022

• #5

Thanks, Paul, for those great tutorials.

If you don't provide the source project as well, @Xfood may feel bad until next Christmas (at the very least) ?

We know him well, he is a collector of source projects (and he knows we joke about it).

 

P

PaulMeuris

Active Member

Licensed User

• Jun 2, 2022

• #6

EDIT: there was an issue with the checking of the start date and end date when the user selects a date in db_dialog layout.
Only the default values were taken and not the settings from the database table settings!
At the end of the section wrapping up - 1. functionalities check I have put the extra code to fill the strstartticks and strendticks variables from the database table settings.
Have a look and you will understand.
Do you have any more questions? Start a new thread in the forum and I will be glad to look at them.
Happy coding!
Paul

 

aeric

Expert

Licensed User

Longtime User

• Jun 2, 2022

• #7

PaulMeuris said:

there was an issue with the checking of the start date and end date

Click to expand...

I am also having some trouble with the ticks in sqlite recently and quite mess up. We need to be careful when using B4X DateTime.Now and the SQLite localtime/unixepoch. The problem become worse when I upload my data to a server having UTC+0 while my local timezone is UTC or GMT +8.
I come up with a way by setting a DEFAULT value in SQLite table for created_date field with (strftime('%s') * 1000) as INTEGER value. For the server, I need to add 8 hours to display the time following my local timezone since the VPS doesn't allow me to change the MySQL timezone.

 

P

PaulMeuris

Active Member

Licensed User

• Jan 24, 2023

• #8

In the attached zip-file you can find a newer version of the budget app.
I share this project to make sure @Xfood doesn't feel bad anymore...
As always, happy coding!

 

Attachments

• budget_with_accounts.zip

  160.5 KB · Views: 294

Xfood

Expert

Licensed User

• Jan 25, 2023

• #9

Very kind @PaulMeuris
Thanks for sharing the project link,
I didn't mean to bother you, I've done a lot of searching here in the forum, I can't find the calendar_dialog3 library
Could you kindly pass the link to download it
Thanks you are a friend

 

P

PaulMeuris

Active Member

Licensed User

• Jan 26, 2023

• #10

In the attached zip-file you can find the calendar_dialog3 library files. Unzip and copy the files to the additional libraries folder to use.
The source code is explained in the tutorial and you can also find a class version in the B4XDialog examples (caldialog).
Enjoy.

 

Attachments

• calendar_dialog3.zip

  5.7 KB · Views: 250

G

Galigar

New Member

• Mar 10, 2023

• #11

Nice work, where are the shared files on compiler programs not find

 

P

PaulMeuris

Active Member

Licensed User

• Mar 10, 2023

• #12

Galigar said:

Nice work, where are the shared files on compiler programs not find

Click to expand...

Which files are you referring to?

 

R

RogerGCollin

Member

Licensed User

• Aug 12, 2023

• #13

Thank you Paul for this tutorial it is just what I was looking for! As a new programmer I find it really hard to find easy information on how to use B4x to develop an app. Sure all the information can be found in the documentation and on the forum but putting it all together to actually build a working app is a real challenge. We need more tutorials like yours!!
I am sure a lot of people are put off using B4x just because there is virtually no step by step instructions for making a nice menu bar, using a database and the coding to make an app. Stuff to do this is scattered everywhere!
This will be my 4th attempt at using B4X. Hopefully with your tutorial I will have enough background information to start building apps of my own.
Thanks again