Automatic detection of foreign keys, display of data

Wish to see a specific feature/change in future releases? Feel free to post it here, and if it gets enough "likes", we'd definitely include it in future releases!
Post Reply
grimblefritz
AppGini Super Hero
AppGini Super Hero
Posts: 336
Joined: 2015-12-23 16:52

Automatic detection of foreign keys, display of data

Post by grimblefritz » 2015-12-24 22:55

Since fields named 'id' are automatically configured as primary keys, it would be useful if fields named 'tablename_id' we detected as foreign keys and automatically configured as lookups. Basically, set the field datatype to integer and make the lookup into the 'tablename' and use the first field that's not 'id' as the display value.

Related, it would be useful to have 'autofill' be complemented by a "display fields' list. This would lookup the field(s) and display it(them) in forms and views, but it would no be part of the table. For example, if the lookup is by id into the customer table, we might want to display "name" and "phone" number for the customer record, but neither edit nor retain it as part of the current table.

This could also be accomplished by allowing computed fields to be defined. Part of the form display structure, but not input/edit elements.

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: Automatic detection of foreign keys, display of data

Post by a.gneady » 2015-12-27 19:08

Thanks a lot for your valuable feedback. We have plans to implement these improvements in future releases indeed. Stay tuned!
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply