This part is easy – data updates in a form only appear when the form is in data mode, not in graphics mode. Switch to data mode and the data will update.
The Mac has a special invisible temporary folder that programs can use to temporarily store a file. The system will automatically delete any files in this folder after a period of time. A program like Panorama can call the system to find out the location of the temporary folder. This folder location may change and will definitely be different on different systems, but it is always similar to the path you are seeing
So, when you ask Panorama to display a preview, it makes a PDF file in this special folder and then asks Preview to open the PDF file. Preview has special provisions for this, so it hides the fact that the PDF is in this invisible folder.
Normally all this proceeds without a hitch, totally invisible to the user. In fact, I’ve never heard of a problem like this before. The only thing I can think of is that there is something wrong with your system and it isn’t allocating the temporary folder properly, or there is a permission problem on this folder.
It is possible to display this folder in the Finder. To do this, open a new Finder window, then choose Go To Folder from the Go menu. Then copy and paste the folder location, in your case this is:
If your system is like mine, there will be a bunch of files in this folder, but the most recent one should be the PDF file you just tried to preview (at least it would have been if you opened this folder right after choosing File>Preview in Panorama).
If you look and this PDF file isn’t there, maybe there is something in your form that is causing the PDF generation to fail. As I say, I’ve never heard of that or seen that, so if that is the case I would be interested in getting a copy of the database with this form to see if I could duplicate the problem on my system while running with the Xcode debugger. If rebuilding the form from scratch consistently fixes the problem for you then maybe this is a possibility.