Newbies Bastian_Atrayu Posted March 14, 2011 Newbies Share Posted March 14, 2011 HI im a newbie to FileMaker, have had experiences with DB programming basics before but that was 7 years ago. I'm currently trying to see if it's possible to trigger an email to be sent automatically by filemaker once the value of a drop down list changes. While on the layout view, i set the button set up to "Send Mail" and upon testing it did send, but it was after clicking the list and not even changing anything. Hope someone can help. thanks, you help will be greatly appreciated. Link to comment Share on other sites More sharing options...
djc728 Posted March 14, 2011 Share Posted March 14, 2011 I would hold the original value of the drop down list in a global variable ($$OrigValueDropDown) using the On Record Load layout trigger. And then for the field with the drop down list, use the On Object Exit field trigger and compare the original value to the changed value. If it has in fact changed - send email. HI im a newbie to FileMaker, have had experiences with DB programming basics before but that was 7 years ago. I'm currently trying to see if it's possible to trigger an email to be sent automatically by filemaker once the value of a drop down list changes. While on the layout view, i set the button set up to "Send Mail" and upon testing it did send, but it was after clicking the list and not even changing anything. Hope someone can help. thanks, you help will be greatly appreciated. Link to comment Share on other sites More sharing options...
comment Posted March 14, 2011 Share Posted March 14, 2011 Script triggers are available in version 10 and higher. In earlier versions a plugin is necessary. Link to comment Share on other sites More sharing options...
Newbies Bastian_Atrayu Posted March 19, 2011 Author Newbies Share Posted March 19, 2011 I would hold the original value of the drop down list in a global variable ($$OrigValueDropDown) using the On Record Load layout trigger. And then for the field with the drop down list, use the On Object Exit field trigger and compare the original value to the changed value. If it has in fact changed - send email. Hey thanks, will surely try this. Thought i'd be at my wits end to figure this one out. :-) Link to comment Share on other sites More sharing options...
bcooney Posted March 19, 2011 Share Posted March 19, 2011 Curious use of email, imho. Is this an audit approach? Seems like lots of emails, and I would think there's a better way to achieve your goal--whatever that is. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4784 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now