Page 1 of 1

Custom sub grid table inline cell editing page

Posted: 2019-08-29 20:57
by cwesthuizen
Good day all
I am really hoping someone can give me guidance, or a quote, to what I am planning to do.

Please see the three images attached.

I need to split up a transactions sub table into income and expenses and give totals, and outstanding fees calculated like in the sheet image I attached.
I need to choose the month then the records for that month needs to appear according to the sheet image, then to be edited directly on that page.
If the current month is opened it should show records already added, and extra records for each transaction type not already added, then one needs to be able to just click or tab on the cells and add or change the values like one do in excel, and the date automatically updated if not manually changed. When done one should be able to click on save to submit all changes. If a record locked field is locked one should not be able to edit the record. If month end button is pressed then no records <= lock month date should be able to be added, deleted or edited.
I really want to do this myself but don't have any experience with AppGini accept for what I did by auto generation. Where do I start?
Anyone willing to guide me. I promise to pay it forward, like I always do :-)
Thanks a lot, Chris

Re: Custom sub grid table inline cell editing page

Posted: 2019-08-29 21:20
by pböttcher
Hi Chris,

maybe this is not the answer you are looking for, but with the standard AppGini features you will not be able to acheive this, as AppGini has no grid editing functions and no multi row editing.

Re: Custom sub grid table inline cell editing page

Posted: 2019-08-30 06:57
by cwesthuizen
Hallo pböttcher. Thank you. I realize that, thus have to improvise. AppGini saved me hours and hours of development though. Thank you AppGini.
I will have to manually create a tab net to the transactions tab, and implement my own code in it. That I believe I will accomplish with a hook. I have a lot to learn :-) I'm taking my first baby steps hehehehe. :-) I am now going to search for a grid I can manipulate and add, and then figure out how to add that extra tab, and making use of AppGini's functions to query the db etc. Keep your thumbs.

Re: Custom sub grid table inline cell editing page

Posted: 2019-08-30 07:27
by cwesthuizen

Re: Custom sub grid table inline cell editing page

Posted: 2019-08-30 12:20
by pböttcher
Hi,

are the transactions that you show as excel-sheet related to the property from the 1_Property_Page1.png?
Do you have a query that would output all the data in the excel-sheet needed?