Forums

Need to change data in multiple records!

JeLu 27 Feb, 2013
Hi!

I need to change 3 fields and add data in a couple of fields in my ChronoForms table. Is it possible to do that with latest CC or can I use CF. I am not sure where to start and how it can be done and some hints would be gratefully received.

//JeLu
GreyHead 27 Feb, 2013
Hi JeLu,

If you need to modify the table then you can't do that in the current version of ChronoForms. PHPMyAdmin is probably the simplest way to do this.

Though, if there is no data in the table that you need to keep, you could delete the existing table and us the Create Table icon in ChronoForms to create a new one version.

Bob
JeLu 27 Feb, 2013
Ok thanks!

If I would restrict access in CC to more than one user how can I do that. Today I have current user to see only his/her own records. But I would like a user to grant access to his/hers records to another user for viewing and edit.

//JeLu
GreyHead 27 Feb, 2013
Hi JeLu,

Hmmm . . . tricky question. The only way I can think of would be to build a look-up table with two columns: owner_id, viewer_id then hand-code a permission check to see which records the current user is allowed to see. Possible but not simple. I'd probably do it with a little check-in form before the listing, do the check there then pass the result to the CC listing, or tell the User 'Sorry, No'.

Bob
JeLu 01 Mar, 2013
OK Thanks! That got me some idees to test.

//JeLu
This topic is locked and no more replies can be posted.