Hi super Heroes
Is this possible? An anonymous person could login to a database and only update one field. I would like anyone to search my database and if they see an error or mistake they could set a flag to alert me that one of the fields, probably a text field, has inaccurate information.
Thank you
Editing only certain fields.
-
kanklovitch
- Veteran Member
- Posts: 159
- Joined: 2019-02-03 17:26
Re: Editing only certain fields.
Thanks Jim, sounds like it will be difficult for now.
Re: Editing only certain fields.
Sorry,
I am new as well...
Jim
I am new as well...
Jim
Re: Editing only certain fields.
Hi,
you could solve your issue by adding the same table again to you APPGini app, put all field to read-only and leave only your "comment" field read-write.
After regenerating your app you need to replace the tabledefintion in your database by a view to the original table.
Drop table
create view tablecopy as select * from table
Like this you have a table that you can allow anonymous users access which will only have the comment field read-write, but will also get all all new entries from the original table.
Note that you should not allow "INSERT" on this copy.
Hope that helps.
you could solve your issue by adding the same table again to you APPGini app, put all field to read-only and leave only your "comment" field read-write.
After regenerating your app you need to replace the tabledefintion in your database by a view to the original table.
Drop table
create view tablecopy as select * from table
Like this you have a table that you can allow anonymous users access which will only have the comment field read-write, but will also get all all new entries from the original table.
Note that you should not allow "INSERT" on this copy.
Hope that helps.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.