Just realized that I could achieve that by inserting my values in vtiger_field table.... Anyway if you are interested by the project or just want to comment please do.<br><br><br><div><span class="gmail_quote">On 6/7/07, <b class="gmail_sendername">
clement chazarra</b> <<a href="mailto:chazarra.clement@gmail.com">chazarra.clement@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello people,<br><br>I need some help to understand more deeply how vTiger works..<br>I decided to try merging phpscheduleit(<a href="http://www.php.brickhost.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.php.brickhost.com/</a>) in vTiger. <br><br>How I see it:
<br>We have resources in the scheduler (with associated properties), the best would be to visualise those in vTiger as products categorized as 'resources' so if you edit your product, the changes will occur in phpscheduleit tables. I no want to touch the databases, All I need to understand is how in vTiger we retrieve the custom fields on the form, to be able adding a condition like:
<br><br>if category == 'resources' {<br> select * from scheduleit_resources fields<br> show fields in vTiger form as customfield<br>}<br><br>Sorry if I am not being clear.. Which files are used to retrieve custom fields? especially product custom fields?
<br>I also had a look to the api (<a href="http://api.vtiger.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://api.vtiger.com/</a>), but it didn't help much... I need to see the whole picture from the template to the retrieve of the database fields.
<br><br>
If I can achieve that, the next step is to customize the products view in each module concerned (SaleOrder, Invoice, Quote, etc.) to display data from scheduleit db again.<br><br>I already managed to log in scheduleit with vTiger user details.
<br><br>How to retrieve and display data from another table in vTiger modules?<br><br>Thanks in advance,<br>Regards,<br><br>Clem<br>
</blockquote></div><br>