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 для пользователя, это нужно потому, что номер строки не может являться идентификатором пользователя, потому что номер строки не является индивидуальным
1 Like
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.
1 Like
This is good.
I will update and try it.
Thank you very much, Mr. Vladimir_PV
Thank you , Mr. Vladimir_PV