How to show a downloadable xl file link conditionally when user selects one of choice in a dropdown

[Nitin21]

How to show a downloadable xl file link conditionally when user selects one of the choice in a dropdown field in service portal?

[Ankur Bawiskar]

@Nitin21 

this is possible with this approach

1) store that excel on your catalog item record, grab the sys_attachment sysId for that file from sys_attachment table

2) then use onChange catalog client script on that select box

a) use g_form.addInfoMessage() and show the link to download the file

Something like this

Give correct sysId from sys_attachment, correct choice values to compare

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    var link1 = '<a href="/sys_attachment.do?sys_id=sysId1" target="_blank">Click here to download Template 1</a>';

    if (newValue == 'choiceValue1') {
        // Add the info message with the link
        g_form.addInfoMessage(link1);
    } else  {
        g_form.clearMessages();
    }

}​

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Nitin21 

Thank you for marking my response as helpful.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Nitin21]

Hi, this is working, thank you so much! However, the info message disappears after few seconds. Are there any other solution for this?

[Ankur Bawiskar]

@Nitin21 

Glad to know that my approach worked.

I believe I answered your original question where you wanted a link for user to download file.

Now that you require some other approach, I can share that but you can mark the above response as correct to close the thread.

The discussion can continue on answered thread.