Hello,
please make a auomativ value "owner" (owner of this record)
Thanks much, Kai
Automatic Value "Owner"
-
- Veteran Member
- Posts: 45
- Joined: 2015-04-15 06:33
- Location: Hyderabad
- Contact:
Re: Automatic Value "Owner"
Hi,
You mean that creating ownership to a record right?
You mean that creating ownership to a record right?
-
- Veteran Member
- Posts: 45
- Joined: 2015-04-15 06:33
- Location: Hyderabad
- Contact:
Re: Automatic Value "Owner"
Hi kai,
it may help you....
place the below code in after insert function of the related file in hooks folder
$qry="SELECT `groupID` FROM `membership_users` WHERE `memberID`='".$data['ClientID']."'";
$groupid=sqlValue($qry);
$qry2="INSERT INTO `membership_userrecords`(`tableName`, `pkValue`, `memberID`,`groupID`,`dateAdded`, `dateUpdated`) VALUES ('tablename','".$data['ID']."','".$data['ClientID']."','".$groupid."',UNIX_TIMESTAMP(now()),UNIX_TIMESTAMP(now()))";
sqlValue($qry2);
//here $data['ClientID'] is logged in member id
it may help you....
place the below code in after insert function of the related file in hooks folder
$qry="SELECT `groupID` FROM `membership_users` WHERE `memberID`='".$data['ClientID']."'";
$groupid=sqlValue($qry);
$qry2="INSERT INTO `membership_userrecords`(`tableName`, `pkValue`, `memberID`,`groupID`,`dateAdded`, `dateUpdated`) VALUES ('tablename','".$data['ID']."','".$data['ClientID']."','".$groupid."',UNIX_TIMESTAMP(now()),UNIX_TIMESTAMP(now()))";
sqlValue($qry2);
//here $data['ClientID'] is logged in member id
Re: Automatic Value "Owner"
Thanks much,
i´ll try it. But it would be better to have this from within the appgini app. I do not like the hooks. It´s confusing after you have some mods.
Thanks much, Kai
i´ll try it. But it would be better to have this from within the appgini app. I do not like the hooks. It´s confusing after you have some mods.
Thanks much, Kai
-
- Posts: 28
- Joined: 2017-03-12 09:26
- Contact:
Re: Automatic Value "Owner"
I want to update the ownership of a record by a value from a drop down field.Satya Kavala wrote: ↑2015-05-15 06:50Hi kai,
it may help you....
place the below code in after insert function of the related file in hooks folder
$qry="SELECT `groupID` FROM `membership_users` WHERE `memberID`='".$data['ClientID']."'";
$groupid=sqlValue($qry);
$qry2="INSERT INTO `membership_userrecords`(`tableName`, `pkValue`, `memberID`,`groupID`,`dateAdded`, `dateUpdated`) VALUES ('tablename','".$data['ID']."','".$data['ClientID']."','".$groupid."',UNIX_TIMESTAMP(now()),UNIX_TIMESTAMP(now()))";
sqlValue($qry2);
//here $data['ClientID'] is logged in member id
I tried this code and replaced the ClientID with my own dropdown field but in the ownership table i have blank in owner field.
Best Regards,
Ionut Bocanet
Ionut Bocanet