Guadalupe Barba
03/23/2021, 2:06 PM<table class="itemtable" style="margin-top:10px;width:100%;"><!-- start items --><#list record.item as item><#if item_index==0>
<thead>
<tr>
<th align="center" colspan="3">${item.quantity@label}</th>
<th colspan="12" style="width: 248px;">${item.item@label}</th>
<th style="width: 97px;"> </th>
<th colspan="1" style="width: 92px;">${item.istaxable@label}</th>
<th align="right" colspan="4" style="width: 58px;">${item.rate@label}</th>
<th align="right" colspan="6">${item.amount@label}</th>
</tr>
</thead>
</#if><tr>
<td align="center" colspan="3" line-height="150%">${item.quantity}</td>
<td colspan="12" style="width: 248px;"><span class="itemname">${item.item}</span><br />${item.description}</td>
<td style="width: 97px;"><#if itemurl?has_content><img src="${itemurl}" style="width:100px;height:100px;background-color:#999;" /> <#else>
<div style="width:100px;height:100px;background-color:#999;"> </div>
</#if><br /><span class="itemname">${item.upccode}</span><br /> </td>
<td colspan="1" style="width: 92px;">${item.istaxable}</td>
<td align="right" colspan="4" style="width: 58px;">${item.rate}</td>
<td align="right" colspan="6">${item.amount}</td>
</tr>
</#list><!-- end items --></table>
David B
03/24/2021, 10:11 PM<#list record.item as item><img src="${item.custcol_myurlfield}" /><#list>
David B
03/24/2021, 10:14 PM@filecabinet
element you can use, but haven't looked into it:
<@filecabinet nstype="image" src="URL for image"/>
Guadalupe Barba
03/31/2021, 7:51 PMvar imageid = rec.getValue({fieldId:'custitem81'});
if(!isEmpty(imageid)){
var lookup = search.lookupFields({type:'file',id:imageid,columns:['url']});
var imageurl = lookup.url
if(!isEmpty(imageurl))
imageurl = imageurl.split('&').join('&');
customData.itemurl = imageurl;
}
Is there a way for me to do something similar within the Advanced HTML/PDF Forms environment using Freemarker syntax? I am at a loss as to what I can call to pull the image URL. The custom label that points to the image, <custitem81>30012</custitem81>, stores the file number. Inside the file details screen, I can see the various URLs generated but I just don't know how to pass that data back to the estimate record. I don't see any of that when trying to source that data to a custom transaction line field. Any help with this is greatly appreciated. Thanks in advance.