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

nukac
Tera Contributor

sorry to say



its not working from my end


@sampth can you show me the ur catalog form


Just to confirm, did u uploaded the document and copied the sys_id in the ui macro?


If so, this would work for sure.



Refer the below screenshot.



find_real_file.png




Regards,


Sampath.


nukac
Tera Contributor

variable:


find_real_file.png




ui macro script:


find_real_file.png




find_real_file.png




i copied the attachment sya_id in jelly scripting even i am unable to see any variable or attachment on catalog item form


nukac
Tera Contributor

your end looks awesome but my end


Follow these steps:



1. Upload the excel sheet in your catalog item and save the form.


2. Navigate to sys_attachment table by typing sys_attachment.list in the left navigator.


3. Find your attachment there and copy the sys_id of the attachment.


4. Create a UI Macro and replace the sys_id in the code mentioned by Shloke.


5. Create a Variable of type 'Macro' and under type specification section give the name of the Macro created (as you did in the screenshot).



Save the changes and try ordering your Item.



Let us know if any concerns.