Notification emails going out even when nothing to report

Question

We set up a report to send out a list of missing receipts from an app that has all the credit card transactions in it. The box to send out the report even if there is nothing on the report is not checked and one of the filters is that the Quickbase user ID is the current user, which was supposed to make it so that the report showed as blank for that user if they did not have any missing receipts and therefore no notification would be sent. However, people without any missing receipts are still getting a notification email which is causing a lot of confusion. If anyone knows of a way to prevent this, it would be much appreciated.

------------------------------
Michelle Woolley
------------------------------

evanmartinez · Answer

Hi Michelle,Is that email going out to all of the users who would get that subscription and don't have records or is it only going out to one or two of the possible recipients? Sometimes what happens is that if it is only going to one or two user who can't find records it could be because records are edited or change statuses before the user actually opens the email. Also is that user in a role where they have permissions to view the field you are using to filter that report?------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

michellewoolley · Answer

Hi Evan,Thanks for your response.&nbsp; The report is set up to go to all QB users and then the filters are trying to make sure that if there is nothing to report, no email goes out.&nbsp; But some people that do not have any records and should not have any records are getting an email about missing receipts.&nbsp; There is nothing showing in the records section of the notification, which is correct, but they shouldn't get the email at all.&nbsp; We are trying to use the QB user id (since all the people involved are users) as a filter but I think the field we are using for the QB user id has some issues.&nbsp; I am hoping there is a better way to exclude people who do not have anything to report and should not have anything to report from the email notifications without setting up a separate report for each person.------------------------------Michelle Woolley------------------------------

evanmartinez · Answer

Hi Michelle,Basing a subscription off a report that filters by current user having records is something I've done plenty of times in my own apps and helping with customer apps in the past to help send out the subscription only when the user has relevant records. In the past it usually only doesn't work when something makes that field and data unreliable in the app. What issues do you think the field has? Is it part of a relationship or based on a formula that could be having its values changed somewhere outside the table so you aren't able to track that change?------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

michellewoolley · Answer

Hi Evan,Can you give me an example of how you would set up one subscription that will only send an email if the person that the email is going to has records?&nbsp; The current subscription we have is set up to go to all QB users to try to catch everyone, but some of the QB users don't have anything to do with this QB table (i.e. they don't have a company credit card) so filtering based on a field in the report is tricky.&nbsp; That is one of the problems with how we set it up currently because some of the people are not identified in the table at all and they got the notification because they did not get filtered out.------------------------------Michelle Woolley------------------------------

evanmartinez · Answer

Hi Michelle,To get the set up you are looking for you would set up the report the subscription is based on to filter for the user field in your table that you are using to be equal to the current user. Then so long as that checkbox you mentioned is not checked to send the email when there is no records as long as they don't have a valid record to show up using your filters they wouldn't get an email even if it is set to go to everyone. I have done that with apps with 5 users and apps with 500 users where many users have nothing to do with the table the subscription is based on.In your instance where you have a user getting that email are they the only user that shouldn't have gotten an email but did or are there other users who shouldn't have gotten an email based on your filters and did indeed get no email? For example it is going to all users and it correctly went to 20 users who did have records, correctly did not go to 20 users who had no records, but then went to a user who had no records? That would more indicate that there is something special about that case (for example is that user in a special role in your application that could effect how they view relationship data or formulas that could impact the way they see that report) or alternatively that one user had a record that was edited either on the parent or child level.------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

Forum Discussion

Notification emails going out even when nothing to report

7 Replies

Related Content

email notification error

New email notification beta has arrived

Director notification via email

Track Email Notifications

Email Notification

Recent Discussions

Filter Monthly, Quarterly, Yearly from one Date field

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record