how to attach the excel sheet by default in catalog item variable

nukac
Tera Contributor

i have one requirement i need to create a one variable that variable contain by default one attachement,kindly suggest how to do this requirement

20 REPLIES 20

Sampath8
Giga Expert

shloke04
Kilo Patron

Hi,



This can be done as per the steps mentioned below:



1) First of All Upload the Attachment file which should get downloaded on click of the Variable to the Catalog item which contains that Variable.


find_real_file.png



2) Create a UI macro as per the below script:



Script:



<?xml version="1.0" encoding="utf-8" ?>


<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">


<p><a href="/sys_attachment.do?sys_id=ca72962870e8960020d27bce9ea54623" title="Click Here to Download the Attachment">Click Here to Download the Attachment</a></p>


</j:jelly>



Navigate to sys_attachment Table and copy the Sys_id for the latest file uploaded as per Step 1 and replace the same in the UI macro script shared above.



find_real_file.png



find_real_file.png



3) Once the Macro has been created, create a Variable with Type as "Macro" and attach the macro created above in the Type Specification tab of the Variable.



find_real_file.png


Have tested this on my Personal instance and it worked. Kindly test the same from your end also.




Hope this helps.Mark the answer as correct/helpful based on impact.



Regards,


Shloke


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hi Shloke,



I tried it and it worked great




Thanks,


Sampath.


Glad to hear that!!



Regards,


Shloke


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke