Is there a Table Setting? Other then Table View and Design View?? For version 25.10.

[chewliew]

I just installed AppGini, and Xampp. I am a new user to AppGini.

Functions that need:
1) I need to shows the records of a table are own by which user in the UserGroup
2) Also ALLOW the ownership of a record to be change by normal users, rather then ONLY Admin.

When I ask ChatGPT and Deepseek, both keep saying there is a Table Setting, that allow me to set the Table propery such as View the "Records Ownership". But there are no such thing in Version 25.10, revision 1935.

Is that means this functions was previously available and now disable on the newer version??

I learned that in the "Admin Area", we can set the table permission to be view by which user group, but that is only for the whole Table, there is no permission setting for a field?

Thanks for the help in advance!

Liew

[jsetzer]

1. I think easiest would be adding an additional column owner_memberID, then automatically fill values in TABLENAME_init() hook or after_insert/after_update.
2. This is a bit more complicated and it depends on your requirements: If there was an additional column owner_memberID (see before), users (allowed to edit a record) may just select (or input) a different owner_memberID. It would be most conveniant and safe to provide a dropdown list for that. Dropdown list should contain available members of certain groups according to your business needs. Therefore, it would be easiest to create an additional table named members or so, automatically fill it with memberID's you'd like to provide and perhaps additional data like full name (custom0), email etc.. Then setup owner_memberID (see before) as lookup, referencing that new table. Up to this point, half is done. Last step would be changing the owner using built in set_record_owner() function in after_insert/after_update hook. You may require little adjuistments, for example you may set initial owner immediately after (first) insert, disallow guest-user, care for deleted/banned users etc..

In one of my projects I did something similar for an integrated task management where users can assign a task to a different user, then, in the background, I'm changing ownership of the task. Permissions are set up to allow editing for owner, only. So, changing ownership of a task, automatically changes permission to edit a task.

Detail view with dropdown, listing members:

chrome_YBf5QYKJKh.png (20.7 KiB) Viewed 4370 times

User can select a member, then save the record. After save, I'm changing ownership using set_record_owner() function for that record.

In table view there is a column showing the assignee, which, in these cases, this assignee is identical with the owner, because I keep ownership and assignee in sync.

chrome_qRbgGprXex.png (35.14 KiB) Viewed 4370 times

This is a starting point for your own implementation.
I do not expect ChatGPT to know that kind of stuff.

[chewliew]

Thanks jsetzer!

You have given me a good directions to work around! Appreciate this.

I have not been doing coding for more than 20 years.
I use ChatGPT and Deepseek to do coding.
Most of the time it does NOT work, but after multiple try and find tune, some time it works.
The instructions are important for these AI to give good results.

Kind of getting irritated when ChatGPT and Deekseek keep saying there is a "Table Structure" to change the permission, other then "Table View" and "Details View"

The default Group and Members is a great features created by default by AppGini.
However, it is very difficult to fully utilize these AppGini Group and Members tables together with user define tables,

In a way, I do hope AppGini can provide additional "Table Structure" to do setting that allowing the Owners to be VIEW (Not Edit) these tables, so that more user define tables can fully use these hidden table to the best.

I am reluctant to use the Ownersship functions of the hidden table, because it generate quite a number of records (logs), for every changes.
Not sure if there is a way to "Turn off" these logging..