Can you confirm that you have security setup so that these uses can actually see the underlying Job Data? If the user does not have access to the data through their current role they will not see the underlying data in the email unless you make it an 'Open' Notification.
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?
