path to js file should be starting from your custom module.

From your error log, it looks like appointments_ph is your module name and not appointments.

Try path

appointments_ph/static/src/js/frontend.js  // module_name/path__to_frontend.js

Thanks