This discussion is archived
7 Replies Latest reply: Sep 7, 2013 3:58 AM by Priyasagi RSS

How to restrict the user from inserting/updating into others user columns?

Vijetha Explorer
Currently Being Moderated

Hi Everyone,

I have a question for which i'm not able to find an answer.

I have prepared a form in which there are fields for unit users as shown in the table below. My form looks exactly like the table below.


Comp_detailsDue_dateUnit 3Unit 4Unit 5Unit 6Unit 7Unit 8Unit 9Unit 10Unit 11Unit 12Unit 13Unit 14Unit 15Unit 16Unit 17
Name 15/3/2013
Name 22/3/2013
Name 35/9/2013
Name 48/6/2013
Name 295/8/2013
Name 303/3/2013


Here all the Unit Users enters the data in their respective Unit fields only like Unit 3 user enters the data in 'Unit 3' only.

Now i want to restrict the users , such that they must not be able to enter the data in other unit columns.


For that i can use the following code:



set_item_property('IN_TAX.UNIT3', insert_allowed, property_TRUE);

set_item_property('IN_TAX.UNIT3', UPDATE_allowed, property_TRUE);


set_item_property('IN_TAX.UNIT4', insert_allowed, property_FALSE);

set_item_property('IN_TAX.UNIT4', UPDATE_allowed, property_FALSE);



/*and set all the other Units to FALSE */



set_item_property('IN_TAX.UNIT17', insert_allowed, property_FALSE);

set_item_property('IN_TAX.UNIT17', UPDATE_allowed, property_FALSE);


But I should do this for all the columns that is for all the Units. The code will be too lengthy & tedious.

Is there any other way to do the same in a simple & short length code?


Thank You...


  • Correct Answers - 10 points
  • Helpful Answers - 5 points