coreyjames
Board Regular
- Joined
- Apr 19, 2011
- Messages
- 71
I am putting together a template file for my co-workers to use with their daily tasks. I work for a hospital and when we do our daily analyses a total of 24 hospitals should show up in our data. I would like a popup box to pop up on the screen when they try to save the file and their isnt a total of 24 hospitals.
So to clarify I have a formula that gives me a hospital count. If this count is less than 24 I want a pop up box to pop up on the screen when the user trys to save the file to let them know not all hospitals are shown. I will also have a comments box to the side of the hospital count. If there is a comment in the comment box I do not want the popup box to show up because the analyst has given a reason as to why it is not on the list.
If possible I would like the popup box to ask for the reason not all hospitals are on the list. I would like to be able to type the reason in the box and have it appear as a comment beside the hospital count.
Any help would be greatly appreciated. Thanks!
So to clarify I have a formula that gives me a hospital count. If this count is less than 24 I want a pop up box to pop up on the screen when the user trys to save the file to let them know not all hospitals are shown. I will also have a comments box to the side of the hospital count. If there is a comment in the comment box I do not want the popup box to show up because the analyst has given a reason as to why it is not on the list.
If possible I would like the popup box to ask for the reason not all hospitals are on the list. I would like to be able to type the reason in the box and have it appear as a comment beside the hospital count.
Any help would be greatly appreciated. Thanks!