I didn't think of this dimension. As a developer I have access to see everything here and I am still not seeing it in the notifications. The others receiving these emails should also have pretty 'high clearance' for most of the information so I don't think access is causing the problem here.
Where do I go about making the notification open? I do not see an option for that on the notification editing screen?
If thats the route you're going you would need to create a new version of the notification and during the setup / create process there first input is to send to a recipient (current users) or open (any email you input)
If you're sending to recipient Quickbase will identify the access that user has and show data where applicable. Open emails are a little less restricted. Everything else in your setup will be the same more or less, unfortunately that setting can't be changed for already created notifications.
This is NOT the route I would like to go, I want to have the data populate in the email messages using the existing set up (ie: i want to fix what is already there, not create a copy of it). i asked this out of curiosity and for future reference.
Given this relationship diagram for the rich text formula field in the table, do you see anything that could be preventing the data from flowing properly to the email notification for the table?
You would need to work from the roles to start, the field diagram won't provide that detail.
Have you tried testing as one of the affected users? What happens when you test as one of them and you look at Jobs? Do they see all Jobs and all the information that would be in the email?
I am not able to perform a test as the user who I am fixing this notification for (error dialog "you must have access to all the applications in cross-app relationships to test as this user") but after looking at the Access table for the table I am working with I can see that everyone has access to view all the records in the table. When checking the field settings, I did notice the override access setting was unselectedwould this be potentially causing an issue with notifications accessing the information?
