save a form and it changes other records to be the same

[angelogabeira]

guys, I have a record being edited in the form, this form has a status field, when saving changes to this record, I want the records of the same group to have their status also changed.
That is, I change on a group record, and when I click save, it updates the status of all group records.

 

[lousyfool]

Typical job for a PHP form plugin: http://fabrikar.com/forums/index.php?wiki/php-form-plugin/

 

[angelogabeira]

could you kindly give me an example php code that i could use?

 

[troester]

http://fabrikar.com/forums/index.php?wiki/php-form-plugin/#decrease-a-value-in-another-table
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/#update

 

[henk]

Alternative ways to do this (in a nutshell):
1. Create another table where you set the group status.
2. Assign users to be a member of a group
3. Join the newly created group tabel with the current table

Or you can use a database trigger to update records.