2. PHPRunner General questions
  3. Edit Own records..
This topic is locked

Edit Own records..

 		3/23/2008 01:26:24
PHPRunner General questions
I
 indigo author

I am creative an Application where there are multiple projects being tracked.

Every Project Team has defined number of people.
So,

Table --- > Project Details

Field ---> Team -----> Multiselect [A,B,C,D,E,F,G,H]
Now if 'A' has entered the record and chosen B,C,D as his team, it would mean that the record should be editable by the whole team as well.

Using PHPRunner security tab, I am able to get "Edit your own Records" but it cannot validate against multiselect values of [A,B,C,D]
I want the records for the team to be viewable/editable by the whole team and not just the creator of the record. This will enhance collaboration.

Can anyone help here?
J
 		Jane 3/24/2008

Hi,
unfortunately you can't use multi-select value as OwnerID.
I recommend you to create new field (TeamID) on the Datasource tables tab, save value of selected team in this field and use it as OwnerID.
I
 		indigo author 3/25/2008

There are 60 teams and there is a field for TeamID already.

However, when selecting Owner ID for a record, how do I select a team and let it edit the record?
Can someone help?
J
 		Jane 3/26/2008

Hi,
OwnerID variable is filled after login.

Just select TeamID as OwnerID and each member can edit records for his team only.
I
 		indigo author 3/28/2008

There is a team ID but there are multiple team working on the same project.

How do I give multiple team access?
J
 		Jane 3/28/2008

Hi,
generally it's not possible to use multi-select value as OwnerID.
You can publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages. I'll try to find a workaround.