<div dir="ltr">Glad to hear that. :) <div><br></div><div>+1</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 30 April 2013 10:31, Vikas Jain <span dir="ltr"><<a href="mailto:vikas@vtiger.com" target="_blank">vikas@vtiger.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Team,<div><br></div><div>We have decide to retain role based picklist and it will be available in vtiger6, in vtiger.5.x by default any picklist field that </div>
<div>was created from Layout Editor was role based picklist, but in vtiger6 we will provide an option to create non role based picklist <br>
field also. </div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On 22 March 2013 13:42, salim <span dir="ltr"><<a href="mailto:salimcmd@gmail.com" target="_blank">salimcmd@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi Vikas,</div>Yeah its. What i have mentioned in previous mail is just a rough idea. <div><br><div>
Also, I don't want people from Kerala select Karnataka in State pick list. So i should have to make that Pick list as Role Based. right?</div>
</div><div><br></div><div><br></div><div>Thanks</div><span><font color="#888888"><div>-- </div><div>Salim</div></font></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">
On 22 March 2013 13:09, Vikas Jain <span dir="ltr"><<a href="mailto:vikas@vtiger.com" target="_blank">vikas@vtiger.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_quote"><div>Salim,</div><div><br></div><div>I think you could have done this a better way than create large number of roles and picklist values associated to each roles.</div>
<div>This could have been easily solved using <b>Picklist Dependency</b> where you have a picklist for States and another for Branches </div><div>within the states, set up dependency by associating state value eg:Karnataka state to all the Karnataka branches picklist value. </div>
<div>This would have reduced the complexity of the system also by eliminating lot of roles and profiles you have created.</div><div><br></div><div><br><div class="gmail_quote"><div><div><div><div>On 22 March 2013 10:27, salim <span dir="ltr"><<a href="mailto:salimcmd@gmail.com" target="_blank">salimcmd@gmail.com</a>></span> wrote:<br>
</div></div></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div><div>
<div dir="ltr">Hi,<br>This one of my use case, We have a client, They have branch's in 20 states in India in every states they have 2 to 5 branch's. <div><br></div><div>In our custom module we have a field like this</div>
<div><ol style="margin:0px;padding:0px 0px 0px 48px;background-color:rgb(248,248,248)"><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic">/*</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> * Field for Associated Branch</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> */</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,0,136)">$associatedBranchField</span> <span style="color:rgb(51,153,51)">=</span> Vtiger_Field<span style="color:rgb(51,153,51)">::</span><span style="color:rgb(0,64,0)">getInstance</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,255)">'branch'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,136)">$module</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(177,177,0)">if</span> <span style="color:rgb(0,153,0)">(</span><span style="color:rgb(51,153,51)">!</span><span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(0,153,0)">)</span> <span style="color:rgb(0,153,0)">{</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span> <span style="color:rgb(51,153,51)">=</span> <span style="font-weight:bold">new</span> Vtiger_Field<span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">name</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">label</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'Associated Branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">columntype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'VARCHAR(100)'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">uitype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(204,102,204)">15</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">typeofdata</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'M~O'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$infoBlock</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">addField</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,136)">$associatedBranchField</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><font color="#000000" face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, monospace, serif"><span style="font-size:12px;line-height:21px"> </span></font><span style="color:rgb(0,0,136);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">$associatedBranchField</span><span style="color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">-></span><span style="color:rgb(0,64,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">setPicklistValues</span><span style="color:rgb(0,153,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">(</span><span style="color:rgb(153,0,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">array</span><span style="color:rgb(0,153,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">(</span><span style="color:rgb(0,0,255);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">'branch Kerala 1'</span><span style="color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">,</span><span style="color:rgb(0,0,255);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">'branch Kerala 2'</span><span style="color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">,</span><span style="color:rgb(0,0,255);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">'branch Kerala 3'</span><span style="color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px;background-color:rgb(248,248,248)">,</span><span style="background-color:rgb(248,248,248)"><font color="#0000ff" face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, monospace, serif"><span style="font-size:12px;line-height:21px">'branch Karnataka 1'</span></font></span><span style="background-color:rgb(248,248,248);color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">,</span><span style="background-color:rgb(248,248,248)"><font color="#0000ff" face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, monospace, serif"><span style="font-size:12px;line-height:21px">'branch Karnataka 1'</span></font></span><span style="background-color:rgb(248,248,248)"><font color="#0000ff" face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, monospace, serif"><span style="font-size:12px;line-height:21px"><span style="color:rgb(51,153,51)">,</span>'branch Karnataka 1'</span></font></span><span style="color:rgb(0,153,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">)</span><span style="color:rgb(0,153,0);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">)</span><span style="color:rgb(51,153,51);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">;</span><font color="#000000" face="Consolas, Menlo, Monaco, Lucida Console, Liberation Mono, DejaVu Sans Mono, Bitstream Vera Sans Mono, monospace, serif"><span style="font-size:12px;line-height:21px"> </span></font><span style="color:rgb(102,102,102);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px;font-style:italic">// Branch list goes here. the values will be more than 60</span></div>
</li><li style="color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px">
<div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,153,0)">}</span></div>
</li></ol></div><div><br></div><div><br></div><div>Then i have Created roles to every states and associated the values. So i could accomplish this easily by role based pick list, </div><div><br></div><div>
My module script will be look like this. if you guys drop the support.</div><div><br></div><div>-</div><div><ol style="margin:0px;padding:0px 0px 0px 48px;color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px;background-color:rgb(248,248,248)">
<li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic">/*</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> * Field for Associated Branch</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> */</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,0,136)">$associatedBranchField1</span> <span style="color:rgb(51,153,51)">=</span> Vtiger_Field<span style="color:rgb(51,153,51)">::</span><span style="color:rgb(0,64,0)">getInstance</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,255)">'branch'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,136)">$module</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(177,177,0)">if</span> <span style="color:rgb(0,153,0)">(</span><span style="color:rgb(51,153,51)">!</span><span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(0,153,0)">)</span> <span style="color:rgb(0,153,0)">{</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span> <span style="color:rgb(51,153,51)">=</span> <span style="font-weight:bold">new</span> Vtiger_Field<span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">name</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">label</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'Associated Branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">columntype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'VARCHAR(100)'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">uitype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(204,102,204)">15</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">typeofdata</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'M~O'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$infoBlock</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">addField</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchField1</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">setPicklistValues</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(153,0,0)">array</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,255)">'branch Kerala 1'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,255)">'branch Kerala 2'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,255)">'branch Kerala 3'</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span> </div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,153,0)">}</span></div>
</li></ol></div><div>- So in this Case i need 20 PICKLIST .. OHHH NO WAY....</div><div><ol style="margin:0px;padding:0px 0px 0px 48px;color:rgb(172,172,172);font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono',monospace,serif;font-size:12px;line-height:21px;background-color:rgb(248,248,248)">
<li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic">/*</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> * Field for Associated Branch</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(102,102,102);font-style:italic"> */</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,0,136)">$associatedBranchFieldN</span> <span style="color:rgb(51,153,51)">=</span> Vtiger_Field<span style="color:rgb(51,153,51)">::</span><span style="color:rgb(0,64,0)">getInstance</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,255)">'branchN'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,136)">$module</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(177,177,0)">if</span> <span style="color:rgb(0,153,0)">(</span><span style="color:rgb(51,153,51)">!</span><span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(0,153,0)">)</span> <span style="color:rgb(0,153,0)">{</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span> <span style="color:rgb(51,153,51)">=</span> <span style="font-weight:bold">new</span> Vtiger_Field<span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">name</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">label</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'Associated Branch'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">columntype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'VARCHAR(100)'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">uitype</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(204,102,204)">15</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">typeofdata</span> <span style="color:rgb(51,153,51)">=</span> <span style="color:rgb(0,0,255)">'M~O'</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$infoBlock</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">addField</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span></div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"> <span style="color:rgb(0,0,136)">$associatedBranchFieldN</span><span style="color:rgb(51,153,51)">-></span><span style="color:rgb(0,64,0)">setPicklistValues</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(153,0,0)">array</span><span style="color:rgb(0,153,0)">(</span><span style="color:rgb(0,0,255)">'branch N'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,255)">'</span><span style="color:rgb(0,0,255)">branch N</span><span style="color:rgb(0,0,255)">'</span><span style="color:rgb(51,153,51)">,</span><span style="color:rgb(0,0,255)">'branch N'</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(0,153,0)">)</span><span style="color:rgb(51,153,51)">;</span> </div>
</li><li><div style="padding:0px 5px;vertical-align:top;color:rgb(0,0,0);border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);background-color:rgb(255,255,255)"><span style="color:rgb(0,153,0)">}</span></div>
</li></ol></div><div>-</div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On 22 March 2013 04:27, Richard Hills - TechnologyWise <span dir="ltr"><<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<div bgcolor="#FFFFFF" text="#000000">
<div>Another + for keeping this. This
feature is important to a number of our clients and is also used
within our own organisation.<br>
<br>
Hope to see this one stay.<div><div><br>
<br>
On 22/03/13 07:51, Joe Bordes wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div>FWIW, I vote for keeping it. It shouldn't be
eliminated<br>
<br>
Joe<br>
Tsolucio<br>
<br>
<div class="gmail_quote">Doug <a href="mailto:sailsfast@gmail.com" target="_blank"><sailsfast@gmail.com></a>
escribió:
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<p dir="ltr">Hey, I don't know if someone happened to mention
this..</p>
<p dir="ltr">But maybe a database cache might be a fix for
this problem. :-)</p>
<p dir="ltr">It seems like it might be easier to fix the
problem than to provide a migration path to 6.0 for everyone
who has used a role based pick list... Like possibly
everyone who has edited pick lists via the Module Manager<br>
</p>
<div style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On
21/03/13 14:26, Doug wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
It seems that it is a huge performance issue.<br>
<br>
Check out Allen's earlier post about performance issues
related to the<br>
feature.<br>
</blockquote>
<br>
It is, but do bear in mind that that was a module that had
~50 role-based picklist fields alone! The customer added
them via the Module Manager so they will *always* be type 15
(role based). Some of them had almost 100 values too!<br>
<br>
It seems to me from the comments so far, that it might be
preferable to support the creation of *either* type of
picklist in the Module Manager and explain the pros &
cons of each.<br>
<br>
And of course, use a database cache ;-)<br>
<br>
<br>
Al<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</div>
<pre style="white-space:pre-wrap;word-wrap:break-word;font-family:sans-serif;margin-top:0px"><hr>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
</div>
<br>
-- <br>
Enviado desde mi tablet BQEdison con K-9 Mail.
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre><span><font color="#888888">
</font></span></blockquote><span><font color="#888888">
<br>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
PO Box 2228, Tauranga, NZ
ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571 1060</a> | fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571 1061</a></pre>
</font></span></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><span><font color="#888888"><br></font></span></blockquote></div><span><font color="#888888"><br><br clear="all"><div>
<br></div>-- <br>Muhammed Abdul Salim<br>
</font></span></div>
<br></div></div></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><span><font color="#888888"><span><font color="#888888"><br></font></span></font></span></blockquote></div><span><font color="#888888"><span><font color="#888888"><br>
<br clear="all"><div>
<br></div>-- <br>Regards<br>Vikas<br>Vtiger Team
</font></span></font></span></div><span><font color="#888888">
</font></span></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br>Regards<br>Vikas<br>Vtiger Team
</font></span><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Muhammed Abdul Salim<br>
</div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards<br>Vikas<br>Vtiger Team
</div>
</div></div><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Muhammed Abdul Salim<br>
</div>