<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Uma,<div class=""><br class=""></div><div class="">Somehow I solved it!</div><div class="">As you say UI Type 61 and have added this </div><div class=""><br class=""></div><div class=""><pre style="background-color: rgb(255, 255, 255); color: rgb(74, 92, 110); font-family: Menlo;" class=""><span style="color: rgb(159, 159, 159);" class="">{*<!--<br class=""></span><span style="color: rgb(159, 159, 159);" class="">/*********************************************************************************<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> ** The contents of this file are subject to the vtiger CRM Public License Version 1.0<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> * ("License"); You may not use this file except in compliance with the License<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> * The Original Code is: vtiger CRM Open Source<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> * The Initial Developer of the Original Code is vtiger.<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> * Portions created by vtiger are Copyright (C) vtiger.<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> * All Rights Reserved.<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> *<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> ********************************************************************************/<br class=""></span><span style="color: rgb(159, 159, 159);" class="">-->*}</span><span style="color: rgb(159, 159, 159);" class=""><br class=""></span>{<span style="color: rgb(242, 137, 49);" class="">strip</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=<span style="color: rgb(166, 202, 145);" class="">"FIELD_INFO" </span>value=<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_MODEL->getFieldInfo()}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=FILE_LOCATION_TYPE_FIELD value=<span style="color: rgb(242, 137, 49);" class="">$</span>RECORD_STRUCTURE[<span style="color: rgb(166, 202, 145);" class="">'LBL_FILE_INFORMATION'</span>][<span style="color: rgb(166, 202, 145);" class="">'filelocationtype'</span>]}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">if $</span>FILE_LOCATION_TYPE_FIELD <span style="color: rgb(242, 137, 49);" class="">eq </span>NULL}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=DOCUMENTS_MODULE_MODEL value=Vtiger_Module_Model::getInstance(<span style="color: rgb(166, 202, 145);" class="">'Documents'</span>)}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=FILE_LOCATION_TYPE_FIELD value=<span style="color: rgb(242, 137, 49);" class="">$</span>DOCUMENTS_MODULE_MODEL->getField(<span style="color: rgb(166, 202, 145);" class="">'filelocationtype'</span>)}<br class=""> {/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=IS_INTERNAL_LOCATION_TYPE value=<span style="color: rgb(242, 137, 49);" class="">$</span>FILE_LOCATION_TYPE_FIELD->get(<span style="color: rgb(166, 202, 145);" class="">'fieldvalue'</span>) <span style="color: rgb(242, 137, 49);" class="">neq </span><span style="color: rgb(166, 202, 145);" class="">'E'</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=IS_EXTERNAL_LOCATION_TYPE value=<span style="color: rgb(242, 137, 49);" class="">$</span>FILE_LOCATION_TYPE_FIELD->get(<span style="color: rgb(166, 202, 145);" class="">'fieldvalue'</span>) <span style="color: rgb(242, 137, 49);" class="">eq </span><span style="color: rgb(166, 202, 145);" class="">'E'</span>}<br class=""><br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=FIELD_VALUE value=<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_MODEL->get(<span style="color: rgb(166, 202, 145);" class="">'fieldvalue'</span>)}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">assign </span>var=<span style="color: rgb(166, 202, 145);" class="">"SPECIAL_VALIDATOR" </span>value=<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_MODEL->getValidator()}<br class=""><br class=""> <span style="color: rgb(172, 120, 14);" class=""><div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="fileUploadContainer"</span><span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_EXTERNAL_LOCATION_TYPE}<br class=""> <span style="color: rgb(172, 120, 14);" class=""><input </span><span style="color: rgb(86, 86, 86);" class="">type</span><span style="color: rgb(149, 185, 64);" class="">="text" </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="inputElement </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_MODEL->isNameField()}<span style="color: rgb(149, 185, 64);" class="">nameField</span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(149, 185, 64);" class="">" </span><span style="color: rgb(86, 86, 86);" class="">name</span><span style="color: rgb(149, 185, 64);" class="">="</span>{<span style="color: rgb(155, 112, 177);" class="">$FIELD_MODEL</span>->getFieldName()}<span style="color: rgb(149, 185, 64);" class="">"<br class=""></span><span style="color: rgb(149, 185, 64);" class=""> </span><span style="color: rgb(86, 86, 86);" class="">value</span><span style="color: rgb(149, 185, 64);" class="">="</span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_EXTERNAL_LOCATION_TYPE}{<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_VALUE}{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(149, 185, 64);" class="">" </span>{<span style="color: rgb(242, 137, 49);" class="">if </span>!empty(<span style="color: rgb(242, 137, 49);" class="">$</span>SPECIAL_VALIDATOR)} <span style="color: rgb(86, 86, 86);" class="">data-validator</span><span style="color: rgb(149, 185, 64);" class="">='</span>{Zend_Json::encode(<span style="color: rgb(242, 137, 49);" class="">$</span>SPECIAL_VALIDATOR)}<span style="color: rgb(149, 185, 64);" class="">' </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">"mandatory"</span>] <span style="color: rgb(242, 137, 49);" class="">eq true</span>} <span style="color: rgb(86, 86, 86);" class="">data-rule-required</span><span style="color: rgb(149, 185, 64);" class="">="true" </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">if </span>count(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">'validator'</span>])}<br class=""> <span style="color: rgb(86, 86, 86);" class="">data-specific-rules</span><span style="color: rgb(149, 185, 64);" class="">='</span>{ZEND_JSON::encode(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">"validator"</span>])}<span style="color: rgb(149, 185, 64);" class="">'<br class=""></span><span style="color: rgb(149, 185, 64);" class=""> </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class="">/><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{<span style="color: rgb(242, 137, 49);" class="">else</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class=""><div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="fileUploadBtn btn btn-primary"</span><span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> <span><i </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="fa fa-laptop"</span><span style="color: rgb(172, 120, 14);" class="">></i> </span>{vtranslate(<span style="color: rgb(166, 202, 145);" class="">'LBL_UPLOAD'</span>, <span style="color: rgb(242, 137, 49);" class="">$</span>MODULE)}<span style="color: rgb(172, 120, 14);" class=""></span><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> <input </span><span style="color: rgb(86, 86, 86);" class="">type</span><span style="color: rgb(149, 185, 64);" class="">="file" </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="inputElement </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_MODEL->isNameField()}<span style="color: rgb(149, 185, 64);" class="">nameField</span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(149, 185, 64);" class="">" </span><span style="color: rgb(86, 86, 86);" class="">name</span><span style="color: rgb(149, 185, 64);" class="">="</span>{<span style="color: rgb(155, 112, 177);" class="">$FIELD_MODEL</span>->getFieldName()}<span style="color: rgb(149, 185, 64);" class="">"<br class=""></span><span style="color: rgb(149, 185, 64);" class=""> </span><span style="color: rgb(86, 86, 86);" class="">value</span><span style="color: rgb(149, 185, 64);" class="">="</span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_INTERNAL_LOCATION_TYPE} {<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_VALUE} {/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(149, 185, 64);" class="">" </span>{<span style="color: rgb(242, 137, 49);" class="">if </span>!empty(<span style="color: rgb(242, 137, 49);" class="">$</span>SPECIAL_VALIDATOR)}<span style="color: rgb(86, 86, 86);" class="">data-validator</span><span style="color: rgb(149, 185, 64);" class="">='</span>{Zend_Json::encode(<span style="color: rgb(242, 137, 49);" class="">$</span>SPECIAL_VALIDATOR)}<span style="color: rgb(149, 185, 64);" class="">'</span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>} {<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_INTERNAL_LOCATION_TYPE && !empty(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_VALUE)} <span style="color: rgb(86, 86, 86);" class="">style</span><span style="color: rgb(149, 185, 64);" class="">="</span><span style="color: rgb(86, 86, 86);" class="">width</span>:<span style="color: rgb(93, 151, 196);" class="">86</span><span style="color: rgb(149, 185, 64);" class="">px</span><span style="color: rgb(242, 137, 49);" class="">;</span><span style="color: rgb(149, 185, 64);" class="">" </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">"mandatory"</span>] <span style="color: rgb(242, 137, 49);" class="">eq true</span>} <span style="color: rgb(86, 86, 86);" class="">data-rule-required</span><span style="color: rgb(149, 185, 64);" class="">="true" </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">if </span>count(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">'validator'</span>])}<br class=""> <span style="color: rgb(86, 86, 86);" class="">data-specific-rules</span><span style="color: rgb(149, 185, 64);" class="">='</span>{ZEND_JSON::encode(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_INFO[<span style="color: rgb(166, 202, 145);" class="">"validator"</span>])}<span style="color: rgb(149, 185, 64);" class="">'<br class=""></span><span style="color: rgb(149, 185, 64);" class=""> </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class="">/><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </div><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class=""><div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="uploadedFileDetails </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_EXTERNAL_LOCATION_TYPE}<span style="color: rgb(149, 185, 64);" class="">hide</span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(149, 185, 64);" class="">"</span><span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> <div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="uploadedFileSize"</span><span style="color: rgb(172, 120, 14);" class="">></div><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> <div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="uploadedFileName"</span><span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>IS_INTERNAL_LOCATION_TYPE && !empty(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_VALUE)}<br class=""> [{<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_VALUE}]<br class=""> {/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class=""></div><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> <div </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="uploadFileSizeLimit redColor"</span><span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{vtranslate(<span style="color: rgb(166, 202, 145);" class="">'LBL_MAX_UPLOAD_SIZE'</span>,<span style="color: rgb(242, 137, 49);" class="">$</span>MODULE)}<span style="color: rgb(89, 147, 190);" class=""> </span><span style="color: rgb(172, 120, 14);" class=""><span </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="maxUploadSize" </span><span style="color: rgb(86, 86, 86);" class="">data-value</span><span style="color: rgb(149, 185, 64);" class="">="</span>{<span style="color: rgb(242, 137, 49);" class="">$</span>MAX_UPLOAD_LIMIT_BYTES}<span style="color: rgb(149, 185, 64);" class="">"</span><span style="color: rgb(172, 120, 14);" class="">></span>{<span style="color: rgb(242, 137, 49);" class="">$</span>MAX_UPLOAD_LIMIT_MB}{vtranslate(<span style="color: rgb(166, 202, 145);" class="">'MB'</span>,<span style="color: rgb(242, 137, 49);" class="">$</span>MODULE)}<span style="color: rgb(172, 120, 14);" class=""></span><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </div><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </div><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </div><br class=""></span>{/<span style="color: rgb(242, 137, 49);" class="">strip</span>}</pre><div class="">Customizing the layouts/v7/modules/Vtiger/partials/EditViewContents.tpl with this </div></div><div class=""><pre style="background-color: rgb(255, 255, 255); color: rgb(74, 92, 110); font-family: Menlo;" class="">{<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_MODEL->get(<span style="color: rgb(166, 202, 145);" class="">'uitype'</span>) <span style="color: rgb(242, 137, 49);" class="">neq </span><span style="color: rgb(166, 202, 145);" class="">'83'</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class=""><td </span><span style="color: rgb(86, 86, 86);" class="">class</span><span style="color: rgb(149, 185, 64);" class="">="fieldValue" </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_MODEL->getFieldDataType() <span style="color: rgb(242, 137, 49);" class="">eq </span><span style="color: rgb(166, 202, 145);" class="">'boolean'</span>} <span style="color: rgb(86, 86, 86);" class="">style</span><span style="color: rgb(149, 185, 64);" class="">="</span><span style="color: rgb(86, 86, 86);" class="">width</span>:<span style="color: rgb(93, 151, 196);" class="">25</span>%<span style="color: rgb(149, 185, 64);" class="">" </span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>} {<span style="color: rgb(242, 137, 49);" class="">if $</span>FIELD_MODEL->get(<span style="color: rgb(166, 202, 145);" class="">'uitype'</span>) <span style="color: rgb(242, 137, 49);" class="">eq </span><span style="color: rgb(166, 202, 145);" class="">'19'</span>} <span style="color: rgb(86, 86, 86);" class="">colspan</span><span style="color: rgb(149, 185, 64);" class="">="3" </span>{<span style="color: rgb(242, 137, 49);" class="">assign </span>var=COUNTER value=<span style="color: rgb(242, 137, 49);" class="">$</span>COUNTER+<span style="color: rgb(93, 151, 196);" class="">1</span>} {/<span style="color: rgb(242, 137, 49);" class="">if</span>}<span style="color: rgb(172, 120, 14);" class="">><br class=""></span><span style="color: rgb(172, 120, 14);" class=""><br class=""></span><span style="color: rgb(172, 120, 14);" class=""> </span>{<span style="color: rgb(242, 137, 49);" class="">if $</span>MODULE <span style="color: rgb(242, 137, 49);" class="">eq </span><span style="color: rgb(166, 202, 145);" class="">'Calendar' </span>&& <span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_MODEL->get(<span style="color: rgb(166, 202, 145);" class="">'uitype'</span>) <span style="color: rgb(242, 137, 49);" class="">eq </span><span style="color: rgb(166, 202, 145);" class="">'69'</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">include </span>file=vtemplate_path(<span style="color: rgb(166, 202, 145);" class="">'uitypes/File.tpl'</span>,<span style="color: rgb(242, 137, 49);" class="">$</span>MODULE)}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">else</span>}<br class=""> {<span style="color: rgb(242, 137, 49);" class="">include </span>file=vtemplate_path(<span style="color: rgb(242, 137, 49);" class="">$</span>FIELD_MODEL->getUITypeModel()->getTemplateName(),<span style="color: rgb(242, 137, 49);" class="">$</span>MODULE)}<br class=""> {/<span style="color: rgb(242, 137, 49);" class="">if</span>}<br class=""> <span style="color: rgb(172, 120, 14);" class=""></td><br class=""></span>{/<span style="color: rgb(242, 137, 49);" class="">if</span>}</pre><div class=""><br class=""></div></div><div class="">But there is problem when editing: the attachments is deleted but not updated with the new upload. I’ve modified CRMEntity.php in this way:</div><div class=""><pre style="background-color: rgb(255, 255, 255); color: rgb(74, 92, 110); font-family: Menlo;" class=""><span style="color: rgb(242, 137, 49);" class="">if </span>(<span style="color: rgb(155, 112, 177);" class="">$insertion_mode </span>== <span style="color: rgb(166, 202, 145);" class="">'edit'</span>) {<br class=""> <span style="color: rgb(159, 159, 159);" class="">//Track the update and update only when needed - vikas<br class=""></span><span style="color: rgb(159, 159, 159);" class=""> </span><span style="color: rgb(155, 112, 177);" class="">$updateFieldValues </span>= @array_combine(<span style="color: rgb(155, 112, 177);" class="">$updateColumnNames</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$update_params</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span><span style="color: rgb(155, 112, 177);" class="">$changedFields </span>= <span style="color: rgb(155, 112, 177);" class="">$this</span>-><span style="color: rgb(155, 112, 177);" class="">column_fields</span>-><span style="color: rgb(167, 95, 0);" class="">getChanged</span>()<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""><br class=""></span><span style="color: rgb(242, 137, 49);" class=""> if</span>(count(<span style="color: rgb(155, 112, 177);" class="">$changedFields</span>) > <span style="color: rgb(93, 151, 196);" class="">0</span>) {<br class=""> <span style="color: rgb(155, 112, 177);" class="">$update </span>= <span style="color: rgb(242, 137, 49);" class="">array</span>()<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span><span style="color: rgb(155, 112, 177);" class="">$update_params </span>= <span style="color: rgb(242, 137, 49);" class="">array</span>()<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> foreach</span>(<span style="color: rgb(155, 112, 177);" class="">$changedFields </span><span style="color: rgb(242, 137, 49);" class="">as </span><span style="color: rgb(155, 112, 177);" class="">$field</span>) {<br class=""> <span style="color: rgb(155, 112, 177);" class="">$fieldColumn </span>= <span style="color: rgb(155, 112, 177);" class="">$updateFieldNameColumnNameMap</span>[<span style="color: rgb(155, 112, 177);" class="">$field</span>]<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> if</span>(@array_key_exists(<span style="color: rgb(155, 112, 177);" class="">$fieldColumn</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$updateFieldValues</span>)) {<br class=""> array_push(<span style="color: rgb(155, 112, 177);" class="">$update</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$fieldColumn</span>.<span style="color: rgb(166, 202, 145);" class="">'=?'</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>array_push(<span style="color: rgb(155, 112, 177);" class="">$update_params</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$updateFieldValues</span>[<span style="color: rgb(155, 112, 177);" class="">$fieldColumn</span>])<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>}<br class=""> }<br class=""><br class=""> <span style="color: rgb(242, 137, 49);" class="">if </span>(<span style="color: rgb(155, 112, 177);" class="">$module </span>== <span style="color: rgb(166, 202, 145);" class="">"Calendar"</span>) {<br class=""> array_push(<span style="color: rgb(155, 112, 177);" class="">$update</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(166, 202, 145);" class="">'allegato=?'</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> if </span>(array_key_exists(<span style="color: rgb(166, 202, 145);" class="">"allegato"</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$updateFieldValues</span>)) {<br class=""> array_push(<span style="color: rgb(155, 112, 177);" class="">$update_params</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$updateFieldValues</span>[<span style="color: rgb(166, 202, 145);" class="">"allegato"</span>])<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>} <span style="color: rgb(242, 137, 49);" class="">elseif</span>(<span style="color: rgb(155, 112, 177);" class="">$updateFieldValues</span>[<span style="color: rgb(166, 202, 145);" class="">"allegato"</span>] == <span style="color: rgb(166, 202, 145);" class="">" 0000 "</span>) {<br class=""> array_push(<span style="color: rgb(155, 112, 177);" class="">$update_params</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(166, 202, 145);" class="">''</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>}<br class=""><br class=""> }<br class=""> <span style="color: rgb(242, 137, 49);" class="">if </span>(count(<span style="color: rgb(155, 112, 177);" class="">$update</span>) > <span style="color: rgb(93, 151, 196);" class="">0</span>) {<br class=""> <span style="color: rgb(155, 112, 177);" class="">$sql1 </span>= <span style="color: rgb(166, 202, 145);" class="">"UPDATE </span><span style="color: rgb(155, 112, 177);" class="">$table_name</span><span style="color: rgb(166, 202, 145);" class=""> SET " </span>. implode(<span style="color: rgb(166, 202, 145);" class="">","</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$update</span>) . <span style="color: rgb(166, 202, 145);" class="">" WHERE " </span>. <span style="color: rgb(155, 112, 177);" class="">$this</span>-><span style="color: rgb(155, 112, 177);" class="">tab_name_index</span>[<span style="color: rgb(155, 112, 177);" class="">$table_name</span>] . <span style="color: rgb(166, 202, 145);" class="">"=?"</span><span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>array_push(<span style="color: rgb(155, 112, 177);" class="">$update_params</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$this</span>-><span style="color: rgb(155, 112, 177);" class="">id</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> if</span>(Vtiger_Functions::<span style="color: rgb(167, 95, 0); font-style: italic;" class="">isUserSpecificFieldTable</span>(<span style="color: rgb(155, 112, 177);" class="">$table_name</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$module</span>)){<br class=""> <span style="color: rgb(155, 112, 177);" class="">$sql1 </span>.= <span style="color: rgb(166, 202, 145);" class="">' AND userid = ?'</span><span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>array_push(<span style="color: rgb(155, 112, 177);" class="">$update_params</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$current_user</span>-><span style="color: rgb(155, 112, 177);" class="">id</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>}<br class=""> <span style="color: rgb(155, 112, 177);" class="">$adb</span>-><span style="color: rgb(167, 95, 0);" class="">pquery</span>(<span style="color: rgb(155, 112, 177);" class="">$sql1</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$update_params</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span>}<br class=""> }<br class="">} <span style="color: rgb(242, 137, 49);" class="">else </span>{<br class=""> <span style="color: rgb(155, 112, 177);" class="">$sql1 </span>= <span style="color: rgb(166, 202, 145);" class="">"insert into </span><span style="color: rgb(155, 112, 177);" class="">$table_name</span><span style="color: rgb(166, 202, 145);" class="">(" </span>. implode(<span style="color: rgb(166, 202, 145);" class="">","</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$column</span>) . <span style="color: rgb(166, 202, 145);" class="">") values(" </span>. generateQuestionMarks(<span style="color: rgb(155, 112, 177);" class="">$value</span>) . <span style="color: rgb(166, 202, 145);" class="">")"</span><span style="color: rgb(242, 137, 49);" class="">;<br class=""></span><span style="color: rgb(242, 137, 49);" class=""> </span><span style="color: rgb(155, 112, 177);" class="">$adb</span>-><span style="color: rgb(167, 95, 0);" class="">pquery</span>(<span style="color: rgb(155, 112, 177);" class="">$sql1</span><span style="color: rgb(242, 137, 49);" class="">, </span><span style="color: rgb(155, 112, 177);" class="">$value</span>)<span style="color: rgb(242, 137, 49);" class="">;<br class=""></span>}</pre><div class="">Still there’s one problem: you can’t delete an attached Item (delete an attachment and have the field empty)… Any idea?</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div class="">
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div>Best Regards,<br class="">Sukhdev Mohan<br class="">———————————</div><div>Cel. (+39) 320 7020345<br class=""><a href="mailto:s.mohan@myti.it" class="">Email s.mohan@myti.it</a></div><div class=""><br class=""></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Il giorno 10 mar 2020, alle ore 09:10, Uma S <<a href="mailto:uma.s@vtiger.com" class="">uma.s@vtiger.com</a>> ha scritto:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi Sukhdev,<div class=""><br class=""></div><div class="">Do try with uitype 61 for file type field. Check this for <a href="https://sc.vtiger.in/screenshots/uma-sc-at-10-03-2020-13-39-29.png" class="">reference</a> (660_to_700.php)</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 26, 2020 at 4:31 PM Alan Lord <<a href="mailto:alanslists@gmail.com" class="">alanslists@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 26/02/2020 10:51, Sukhdev Mohan wrote:<br class="">
> Hi alan,<br class="">
> <br class="">
> Use case is as follows: the sales person need to add documents (PDF or <br class="">
> Images) while adding tasks, that’s why we discarded the relationship <br class="">
> with documents. How can I do?<br class="">
<br class="">
See my earlier reply; it is not trivial.<br class="">
<br class="">
You will need to clone a fair bit of code/functionality from the other <br class="">
relevant modules. Take a look at the Documents and Contacts/Products <br class="">
modules to see how they do it.<br class="">
<br class="">
<br class="">
Al<br class="">
<br class="">
<br class="">
_______________________________________________<br class="">
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank" class="">http://www.vtiger.com/</a></blockquote></div><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div dir="ltr" class="gmail_signature"><div dir="ltr" class="">With<br class="">Best Regards<br class="">Uma.S<br class=""><div class="">Vtiger Team</div></div></div>
_______________________________________________<br class=""><a href="http://www.vtiger.com/" class="">http://www.vtiger.com/</a></div></blockquote></div><br class=""></div></body></html>