Hello
How do I create a project that adds users to one table and adds their monthly payments to a second table? and How do I link or join the two tables using SQLite by “inner join”? How do I show each user with their monthly payments and confirm whether they paid or not?
Thank you for the thorough explanation Mr. Vladimir_PV
This is beautiful
Please help me in the following cases:
1-In the users table, we add a date column and a cost column, and automatically every week, the cost and date are transferred to the payments table automatically or when a button is pressed for one user.
2-Is it possible to transfer the cost to the payment schedule for all users with the click of a button?
Thank you for the thorough explanation* Mr. Vladimir_PV
This is beautiful
Please help me in the following cases:
1-In the users table, we add a date column and a cost column, and automatically every week, the cost and date are transferred to the payments table automatically or when a button is pressed for one user.
2-Is it possible to transfer the cost to the payment schedule for all users with the click of a button?
test4.flp (38.7 KB)
To do this, you can implement an analogue of the repeat loop with countdown.
Also note that I created a new id for the user, this is necessary because the line number cannot be a user identifier, because the line number is not individual
Для этого можно реализовать аналог цикла repeat с обратным отчетом.
Так же обратите внимание, я создал новый id для пользователя, это нужно потому, что номер строки не может являться идентификатором пользователя, потому что номер строки не является индивидуальным
Thank you for the beautiful explanation, and this indicates your extensive knowledge and broad horizons. Thank you again…
- If you have time to convert the files that you attached test.flp, test2.flp, test4.flp to pma format, because the flp format does not open for me, knowing that I have By updating the editor to version 2.5, and it gives me this message in the image:
Conversion will not work, you need to use a new version of the program
Конвертировать не получиться, нужно использовать новую версию программы
Knowing that my editor version: Flipabit 2.5.0326 for flp format.
Knowing that the previous version : Flipabit 2.4.0706 for pma format.
The new version supports working with the old format.
This is good.
I will update and try it.
Thank you very much, Mr. Vladimir_PV
Thank you , Mr. Vladimir_PV