I am looking for guidance on implementing a solution in ServiceNow that allows users to submit text through a catalog item, compiles these submissions into a weekly newsletter, and sends it to users who have subscribed to the newsletter. Here are the specific requirements:
- Catalog Item: A Catalog item where users can submit text entries.
- Storage: A custom table to store the text submissions along with relevant metadata (e.g., user, timestamp).
- Monthly Aggregation: A mechanism to aggregate all the text submissions from the past month into a single newsletter.
- Email Notification: An automated email notification that sends the compiled newsletter to users who have signed up for it.
- Subscription Management: A way for users to subscribe/unsubscribe from the weekly newsletter.
Steps I Have Considered
- Create a new catalog item with a text variable for user submissions.
- Create a custom table (u_text_submissions) to store the text entries.
- Set up a scheduled job to run monthly, query the u_text_submissions table for entries from the past week, and compile them into a newsletter format.
- Configure an email notification to send the compiled newsletter to subscribed users.
- Create a catalog item or another interface to manage user subscriptions stored in a custom table (u_newsletter_subscriptions).
Any feedback? Maybe there's a better way to approach all this?
