I have an app where users can choose from which postcodes they would like to receive notifications when new postings are made.
Where and how do I insert this action?
Do I put the action on the add page and where?
Which choices should I use in the action, so that only users who have chosen this particular postcode receive notification?
You can use the onSubmit event in the add form. Add a workflow that send the notifications. You will be good to go.
Note: Push Notifications has been deprecated and are not working. If you think that it must be re-enabled, you can vote on this post:
In the meantime, SMS or email, slack, discord and more are the way to go for notifications.
How are you storing the users’ choices?
The workflow would include you adding a relation column in the destination table to relate the posting’s postcode, to the column where you store postcode preferences in the users table.
Depends on which type you want: SMS or email, you use a joined list column to get a comma-delimited list of phone numbers or emails back to use in the next step.
I assume that’s the “Valg postnumer” column.
You can create a split array column that splits that column into an array with the delimiter being a comma.
Then follow the steps here.
I’ve now made the split and the relation. Yay
Where do I put the “joined list column”? In the users sheet or destination sheet?
What should I use to send notifications?
I can read that SMS cost money, right? And I don’t ask for users phonenumber, only their email.
So I think mail would be best.
You’re getting closer!
You would have a joined list of emails in the “Efterlysninger hund” table.
Then, every time a post is made (assuming using a form), you add an on-submit action and send an email to the joined list of emails above.
Yes, that does look correct.
Another question:
How do I go about it if I want to send email to “recipient” when there is a new comment and email to “user” when there is a reply to comment.
I think only I can figure out how to send to the person who made the post
