Customer html field using {ID}

**jne** · 2006-09-18, 01:46 PM

I am running Sugarcrm Open Source version 4.5 and am attempting to add a custom field of type 'html' in my Contacts view. This html code contains a URL of type

Code:

http://mylink.php?id={ID}

and I was hoping that this would result in a link of type:

Code:

http://mylink.php?id=76c4fb47-74d3-d5b3-74f1-4329386gbb7b

where 76c4fb47-74d3-d5b3-74f1-4329386gbb7b is the id of my contact. Unfortunately the {ID} variable is not interpreted and is just showing up as such in my URL.

Any possibility to get this working (without having to hack the DetailView.html source code) ?

Thanks in advance,

PS: congratulations to the sugarcrm developpers team for adding the custom fields and improving the way to manage them !

Jordi

**jne** · 2006-09-20, 01:42 PM

Mmmmm ... not a single reply yet. I can seriously use some help with this thing. Anyone able to guide me on the right path... i'd really appreciate it.

Thanks, Jordi

**holzchines** · 2006-11-10, 07:43 AM

i have the same problem. i need the bug_id and account_id for transmitting it to an innerframe-src-attribute. i hope for help here.
my backup-plan is to find the needed data somewhere in the html around my innerframe via javascript. in worse-case i can create some hidden fields, containing this data. but that solution isn't very beautifull...

**holzchines** · 2006-11-10, 01:26 PM

i got a solution:
fist i tried to read, like written in my former reply, in my destination frame via javascript the data from the surrounding mainframe. there ist the important data stored in some hidden fields in the DetailView-Frame. But browsers can't read from one frame to another, when both frames aren't on the same domain.
so i open my frame with a html-custom-field and created in addition a hidden div in the same html-custom-field. this hidden-div contain a formula witch targets my iframe. some hidden fields in my form are filled via java script with the current module and the recordid. the other fields of the module can be recieved via soap (all i need there is a recordid).

html-custom-field-content-example:
<div width="100%" align="center">
<iframe name="fproject" width="800" height="600" src="http://xxx.xxx.xxx.xxx/myProject.php?mode=crm"></iframe>
</div>
<div style="visibility:hidden">
<form action="http://xxx.xxx.xxx.xxx/myProject.php" method="post" name="project" target="fproject">
<input type="hidden" name="mode" value="crm">
<input type="hidden" name="prog" value="crm">
<input type="hidden" name="mod" value="">
<input type="hidden" name="record" value="">
</form>
<script language="JavaScript" type="text/javascript">document.project.mod.value = document.DetailView.module.value; document.project.record.value = document.DetailView.record.value;document.project. submit();</script>
</div>

with the myProject.php can i disply the information from other applications...
it is important, that the java-script contains no cr/lf, because sugarcrm will replace them by "<br />" and this will cause a javascript error....
it's not the straightes solution, but it is one