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