Page 1 of 1

Database independent display fields

Posted: 2013-01-09 04:09
by Johnk
These are fields we can place anywhere on the Detail View to assist the user. They should be able to display something that's NOT stored in the database:

Sub Total: (qty * price). There's often no need to store this value in the database.

Or in my case: Membership Status: (if due date >= today, status = "Financial", else status = "Unfinancial".

Re: Database independent display fields

Posted: 2013-01-09 05:05
by a.gneady
Yes, I plan to implement such feature in future releases, but haven't decided yet if I'll implement it as an actual field with a calculated value, or as a "virtual" field that is only displayed in AppGini application but not stored in the database.

What do you think?

Re: Database independent display fields

Posted: 2013-01-09 09:12
by Johnk
Hi Ahmad, I hope the new forum is kind to you.

I was thinking Virtual fields, mainly because I'm looking at designing a general ledger and lots of calculations don't need to be stored in the database. Virtual fields would hopefully change as soon as the variable us updated, rather than hang on to old values until the database is re-accessed.

When you say "only displayed in Appgini", I assume you mean the generated Appgini PHP application.

Re: Database independent display fields

Posted: 2013-01-09 15:52
by a.gneady
When you say "only displayed in Appgini", I assume you mean the generated Appgini PHP application.
Yes, that's what I meant. Sorry for the confusion.

Re: Database independent display fields

Posted: 2013-01-10 05:25
by KSan
I think supporting both virtual calculated fields as well as calculated db fields would be terrific. If I had to choose only one I would go for virtual option as we can already do calculated db fields through the use of hooks. Thanks for your efforts.

Database independent display fields

Posted: 2013-01-10 10:05
by uwe
I think, it is a 'must', to have non-database fields.
And it is necessary to have fields to make a brake or linefeed in the view.

I have a table with about 40 fields, you can see it not at one page. I have to scroll sideward.
Thats not comfortable!!!!!!
If you have a field 'new line' or some else, you have the hole table in one view.
And it would be nice, to have only view-fields, no databasefields.

And I think, when I pay about 64 € it is a must.

Uwe