I need to create a database to keep track of our material inventory in FileMaker Pro or MS Access. My manager would like to be able to set assignments/send individual request to the employees through the database (database notifications or emails), like to request someone to take 5 units of the material and update the database according, a user would get an email from FileMaker Pro or Access with this request. I know it sounds like we need a Project Management software, but is it possible to create such feature in FileMaker Pro or Access? How?
Asked
Active
Viewed 156 times
1 Answers
1
I can only speak for FileMaker, and this is indeed possible, even easy to do. FileMaker can send emails either through the user’s email client or directly through a smtp server. A simple script would accomplish this.
AndreasT
- 2,317
- 1
- 17
- 14
-
Thank you for this information. WIll this script create a button or easy point and click way for my manager to send email requests to individual users? I would greatly appreaciate if you could include such script and at least let me know what it called so I could find it online. Thank you! – Mainta Jun 22 '18 at 16:02
-
Yes, you can. You will need some basic FileMaker skills, such as making buttons and attaching scripts to them. It’s all very simple. I suggest downloading the trial from FileMaker.com and doing a couple of tutorials. Lots of them on YouTube and there is also FileMaker’s own material included with the program. As for the script, it is basically a one-liner using the Send Mail script step. – AndreasT Jun 22 '18 at 17:59
-
Thank you! Is it possible to write script that will open a window with a free text box where my manager could type his message and the email address of the recipient? – Mainta Jun 22 '18 at 19:40
-
Sure. As FileMaker is a database application, I expect your manager would want to have individual records for recipients and would then be able to easily send emails to any or all of these. – AndreasT Jun 22 '18 at 20:22