none
Access 2013 Web App "On Update" RRS feed

  • Question

  • Hi,

    I need your help, I'm not an expert but I've achieved to send an email every time a record on the table is updated. I was able to create localVar to create the body of the email with info that we need.

    My issue and what I don't know how to do is, how can I show what field on the table was modified?

    Hope you can help me.

    Thanks.

    M.

    Thursday, June 16, 2016 1:07 PM

Answers

  • Hi mparrad,

    According to your description, you could use the new SendEmail action when you’re working with data macros—both named data macros and data macros attached to table events (On Insert, On Update, and On Delete). When you’re working with named data macros, which you can run from control events on views displayed in your web browser, you can, for example, send an email about a specific record you’re viewing. 

    For more information, click here to refer about Introducing Send Email in Access 2013 web apps

    • Proposed as answer by David_JunFeng Sunday, June 26, 2016 2:58 PM
    • Marked as answer by David_JunFeng Monday, June 27, 2016 9:48 AM
    Friday, June 17, 2016 7:06 AM

All replies

  • Hi mparrad,

    According to your description, you could use the new SendEmail action when you’re working with data macros—both named data macros and data macros attached to table events (On Insert, On Update, and On Delete). When you’re working with named data macros, which you can run from control events on views displayed in your web browser, you can, for example, send an email about a specific record you’re viewing. 

    For more information, click here to refer about Introducing Send Email in Access 2013 web apps

    • Proposed as answer by David_JunFeng Sunday, June 26, 2016 2:58 PM
    • Marked as answer by David_JunFeng Monday, June 27, 2016 9:48 AM
    Friday, June 17, 2016 7:06 AM
  • Hi,

    Thank you for your reply.

    I have around 12 different fields on the table, my goal is to know which of those fields changed, I've achieved to send an email every time a record in the table has changed, what I need to know is which field on that record changed. Otherwise, when the user reads the email and see that record changed, it won't know what changed.

    As an example:

    The table is a network inventory. I'm sending in the email the Network, Hostname and Portname fields so that the user is able to find the record. But there are 9 more fields in that specific record that could have changed.

    Another way to do it is to highly the field that was changed when the user opens the record. But, again, I don't know how to do that yet...

    All help is really appreciated.

    Thanks.

    M.

    Friday, June 17, 2016 1:50 PM
  • No help? :(
    Monday, June 20, 2016 4:58 PM
  • >>>what I need to know is which field on that record changed. Otherwise, when the user reads the email and see that record changed, it won't know what changed.

    According to your description, you could use Update Function to return whether an INSERT or UPDATE operation was attempted on the specified field.

    For more information, click here to refer about Update Function (Access custom web app)

    • Proposed as answer by David_JunFeng Sunday, June 26, 2016 2:58 PM
    Tuesday, June 21, 2016 8:15 AM