Many sites have a light notification sound. Say when you get a new order from a customer or a new message. You can have such notification tones in your Bubble app as well
After the sound has been uploaded, copy the S3 file link by going to the data tab and copying the link. You can have as many notification tones as you'd like. Just make sure to upload them to your database to get the S3 link.
let src = '//s3.amazonaws.com/appforest_uf/f1598429253106x343351561325749800/apple_msg_tone.mp3';
let audio = new Audio(src);
Replace the S3 link of your notification sound with the text that is bold and italics between the quotes.