Page 1 of 1
Editing only certain fields.
Posted: 2020-05-16 02:18
by kanklovitch
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
Re: Editing only certain fields.
Posted: 2020-05-16 03:15
by jangle
Re: Editing only certain fields.
Posted: 2020-05-16 03:53
by kanklovitch
Thanks Jim, sounds like it will be difficult for now.
Re: Editing only certain fields.
Posted: 2020-05-20 15:00
by jangle
Sorry,
I am new as well...
Jim
Re: Editing only certain fields.
Posted: 2020-05-21 10:01
by pbottcher
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.