How to turn off alert sound for a specific app

Hi, is there any way I could turn off alert sound for a specific app (ex. Adobe Illustrator)?

Certain apps make unnecessary beeping alerts too often, and this is driving me crazy :(

The only solution I have so far is to turn it off entirely from [Settings > Sound] , which prevents me from getting important notifications from all the other apps as well.

I just want to turn it off for certain apps only.

I'd really appreciate your help!