Skip to Content
avatar image
Former Member

How to Use Variable in Alerts Text

Hi,

I want to use variable or value in the Alerts Text. Let me explain with an example. I will be using Database alerts and will write a macro to generate alerts

I have written macro like this

If

Supply Shortage > 0

Then Update Alert " Supply Shotage"

I want to include the Quantity figure also in the text "Supply Shortage". I want Alert Text " Supply Shortage 100 PC"

I have tried using "&" but still not getting value in alert text. Maybe i am missing something or it is not possible.I am able to diplay the value in the column "Act. Val." but not in the alert text.

Regards

Sunil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 07, 2012 at 12:08 PM

    Hi Sunil,

    Compare your macro implementation with the following screenshot. You may get some clue.

    Thanks,

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded