How to make available the excel file through variable to download and upload

[sony8]

Hi ,

I have below requirement.

we have a record producer form .

there are 3 variables,

type is select box with question choices as below

new,renewed and corrected

if it is new type then the below variable are shown comments and requestor.

if it is renewed type then below variables need to be shown requestor,  comments and one variable need to contain file(I. e., excel file is attached on variable)

for renewed type the requestor can able to download excel file and add the updated excel file .

how to add excel file on variable and show to the end user to clickable and download it and upload?

I have create attachment variable and added in annotation tab with attachment in instructions.

the annotation is getting hidden on the form so the end user cannot be able to see the attachment until and unless he clicks on preview .

can someone help me how to add excel to variable and allow user to download and upload.

[Harsh_Deep]

Hello @sony8 

You can upload that attachment on the record producer's paper clip icon.

Then go to the sys_attachment.LIST and copy url of uploaded attachment.

You can give the variable as rech text leble. And in the link section you can provide copied url.

And write there click here to download.

Here's we go.

Please accept solution and mark as helpful. If this resolves your query.

Thanks

[Danish Bhairag2]

Hi @sony8 ,

You can create a "custom" type variable where u can create a widget & add it to the custom variable. Please see the screenshots below. Note: U might also need to create a Read ACL for allowing a certain set of Users to download via the link as the attachment will be stored in the attachment table & the non admin users will not have access to it.

Variable Snips:

ACL Snip: Here I have provided snc internal role users to have read access on only 1 attachment

The final Output on Service Portal

For Uploading attachment u can create one more new variables as type attachment & based upon condition it will appear along with the custom field which we see above. Else you can just ask them to upload on the catalog item form on the portal where data is being filled.

Thanks,

Danish