Send an email when data is submitted if a flag is set to YES

[PhotoHog]

Any help would be appreciated.

I need to send an email if certain criteria are met during when a user is inputting data. If the user has indicated there is problem with a vehicle I want an automatic email to be sent notifying their manager.

When the user is completing the form, they indicate if there's a problem with the lights on the vehicle. If they indicate YES (drop down control) then a Check Box control appears and they can check the items that need to be fixed and a flag to send an email is set to TRUE.

I created an EMAIL button that only appears when the flag is true. If I send the email before hitting the submit button the values from the Check Box controls do not appear in my email, but the values from the drop down boxes do.

When I press the SUBMIT button the data, including the data selected in the check boxes is updated and in my tables.

What I would like when the user presses the submit button, the email is automatically composed and sent if the flag is TRUE and the data is updated.

Thanks

[GGandhi]

Re: Send an email when data is submitted if a flag is set to YES

I think this is the logic:
they input the data then either they save or discard the changes. if they discard the changes that is it well and good. if they save the data then look for the items that needs to be fixed, you mentioned one but there could be few. then send the email telling the items that needs to be fixed. if this logic seems applicable ( we both are on the same page then ) you could tackle this in a different way than lighting up an email button that they have to push.

I am assuming this is done via dialog - ux in your case. then go to afterdailogvalidate event and where you have your submitData - put your cursor & right click, you will see a popup and select the variables exposed. it will show rtc.flagRecordWasSaved. that will be either true or false.

then there you can compose your email using xbasic including the datasubmitted to the person and using email_send2 function if true. the function will be placed in an if end if statement
like

if flag.recordwassaved then
compose email and send it
end if

[GGandhi]

Re: Send an email when data is submitted if a flag is set to YES

correction:: if this route is not good, then you can use yours by placing the email button. if the dropdown is showing but not the checkbox may the naming convention is wrong. please check that.

[PhotoHog]

Re: Send an email when data is submitted if a flag is set to YES

Thanks I will give that a try.