<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">The fact that your field still shows ‘tapez pour rechercher’ would indicate that it hasn’t picked up the relationship at all – if it were showing a blank value, you wouldn’t see this text (we’ve
had that issue before). And also your not getting the ‘x’ button to remove the relationship, which only shows if the relationship has been set – this leads me to believe the relationship is NOT being set at all.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Arnaud <johnthe5th@gmail.com>
<br>
<b>Sent:</b> 12 August 2022 10:10<br>
<b>To:</b> Martin Allen <martin.allen@exe-squared.co.uk>; vtigercrm-developers@lists.vtigercrm.com<br>
<b>Subject:</b> Re: [Vtigercrm-developers] UItype 10 field stay blank when use VGS Related Field Generator<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Martin, I tried adding the entry but that didn't help me. <o:p>
</o:p></p>
</div>
<div>
<p class="MsoNormal">Are you sure my problem can come from this table? <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Maybe I misspoke to explain the problem, it looks like more a javascript problem.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I made a screenshot for better understanding : <a href="https://i.ibb.co/7bR96sQ/vtiger-problem.png">
https://i.ibb.co/7bR96sQ/vtiger-problem.png</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The problem occurs before clicking on save and therefore before any addition to the database. There is no javascript error in the console.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Le ven. 12 août 2022 à 09:32, Martin Allen <<a href="mailto:martin.allen@exe-squared.co.uk">martin.allen@exe-squared.co.uk</a>> a écrit :<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Also check the value for the record in vtiger_crmentity in the label column – if I remember correctly it will use the details from vtiger_entityname to populate the correct value
in vtiger_crmentity.label. So if you had no entry in vtiger_entityname for your module when the record was created, then it won’t have a value in this column. Any new record should be populated with a value since you put the entry into vtiger_entityname.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">
vtigercrm-developers-bounces@lists.vtigercrm.com</a> <<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a>>
<b>On Behalf Of </b>Martin Allen<br>
<b>Sent:</b> 11 August 2022 16:23<br>
<b>To:</b> Arnaud <<a href="mailto:johnthe5th@gmail.com" target="_blank">johnthe5th@gmail.com</a>>;
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a><br>
<b>Subject:</b> Re: [Vtigercrm-developers] UItype 10 field stay blank when use VGS Related Field Generator</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">It will be in vtiger_entityname database table.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">It records the module (by tabid and module name), the db table (tablename) and id field name and column (so it know how to look up the correct record in the table), and then fieldname,
which is the actual entity name field. It’s the value of this field that would be shown in a related field to that particular record.
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:currentcolor currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Arnaud <<a href="mailto:johnthe5th@gmail.com" target="_blank">johnthe5th@gmail.com</a>>
<br>
<b>Sent:</b> 11 August 2022 15:54<br>
<b>To:</b> <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">
vtigercrm-developers@lists.vtigercrm.com</a>; Martin Allen <<a href="mailto:martin.allen@exe-squared.co.uk" target="_blank">martin.allen@exe-squared.co.uk</a>><br>
<b>Subject:</b> Re: [Vtigercrm-developers] UItype 10 field stay blank when use VGS Related Field Generator</span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi Martin,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">You mean in Vtiger_fields table ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Regards,<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Le jeu. 11 août 2022 à 15:20, Martin Allen <<a href="mailto:martin.allen@exe-squared.co.uk" target="_blank">martin.allen@exe-squared.co.uk</a>> a écrit :<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid windowtext 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">What is the entityname field for the module its relating to? If that value is blank for the related record then it will show as blank.
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div style="border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">
vtigercrm-developers-bounces@lists.vtigercrm.com</a> <<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank">vtigercrm-developers-bounces@lists.vtigercrm.com</a>>
<b>On Behalf Of </b>Arnaud<br>
<b>Sent:</b> 08 August 2022 10:49<br>
<b>To:</b> <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">
vtigercrm-developers@lists.vtigercrm.com</a><br>
<b>Subject:</b> [Vtigercrm-developers] UItype 10 field stay blank when use VGS Related Field Generator</span><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p>Hello,<o:p></o:p></p>
<p>UItype 10 field stay blank when use VGS Related Field Generator only on custom module, (with original there is no problem).<br>
I can select entry in the POP when I click on magnifying glass, but once POP UP close, the field stay totally empty.<o:p></o:p></p>
<p>Even if I create manually the field manualy into database instead of using VGS Related Field Generator I have the same problem. This issue is not VGS Related Field Generator relative.<o:p></o:p></p>
<p>Many thanks for your ideas.<o:p></o:p></p>
<p>Regards,<o:p></o:p></p>
<p>Arnaud.<o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</body>
</html>