record filled and completed

[Andy74]

hello,

I have a form in which users input reports of "sales visit". Usual fields as "customerID", "meetingDAte", etc and the main field is the "minute of meeting". The last field is the most important, users type in long texts and sometimes past from word or emails.

I have included a cmd button that the users can press and this will generate an automatic email to notify some other users that a new visit report has been input and showing the content on the email. Everything is fine but the problem is that many users keep on forgetting to hit that button!

I am trying to automate this, which I do on other forms but:
If I include the "sendEmail" call in the AfterUpdate event of the record that there will be several repeated emails becuase the user sometimes skip from the "minute of meeting" field to a subform and this will trigger the afterupdate event.

Maybe I can use the me.newrecord form property? I already added a boolean field "HasBeenSent" on the underlying table so that the email will be sent only once.

Any other idea? thanks

 

[NauticalGent]

Does the form have a Modal property? You could set it and then disable the close ability and include that on the cmd button. This way the user would have no other option than to "hit that button!"

 

[Andy74]

no, the form is not modal. But there are also users that will only navigate the records for reviewing the reports and they will open and close the form but they will not need to trigger that email notification.

 

[NauticalGent]

Ok, in that case, you could put an AfterUpdate event on the "minutes" field that triggers the same events you tied to the cmd button.

 

[Andy74]

yes, that is the right one. But the issue is that the field "minutes" is normally a long text, and the user sometime stop filling it and then hit somewhere else on the form and then goes back to the minute and this will trigger the event more times. See the attached screenshot below. One of the colored button below (ugly icon) is the "publish" button, which should be hit when report completed.

 

[NauticalGent]

Is the minute field a field that only gets updated once or does it get updated several times over its lifetime?

 

[Andy74]

Normally only once


Inviato dal mio iPhone utilizzando Tapatalk

 

[NauticalGent]

It appears the "minutes" is a memo field?

I have a form that I use for my application. It is bound to a several tables which has a memo field that stores updated notes from more than one user.

I do not want anyone to be able to edit or delete previous notes, but I want them to be able to add new notes. To do this, I have the field's Enable property set to "No". I have an unbound text box (txtAddNewNote) that is above the "Notes" field . A user will enter new notes in that field and then clicks a cmd button (cmdAddNewNote) to add the new entry in
the "Notes" field, in my case at the beginning of the field. It will also add the date that the note was added and them add the users name so I know who made the entry. For example:

23/4/16 - This is a New note. - James.Smith

You could modify my method by removing the date and user function (or keep it) and then add the e-mail code as part of the OnClick event.

 

[Andy74]

Correct, it's a memo field. I will try with this interesting idea, thanks


Inviato dal mio iPhone utilizzando Tapatalk