How To Add Another Trigger to an Existing Notification
In this How To we will be using the Notifications Example Sheet used in the Notifications Builder tutorial.
1 Open the Notifications Example Sheet and select the ‘Notifications Page’ sheet.
2 You should have something similar to the following:
3 In this example we want to add a new trigger such that if the P&L value exceeds 1000 to send another alert with a different message. To achieve this we will use the following formulas:
=IF(PnL_Table[Total P&L] > 1000,TRUE,FALSE)
="Good News ! - P&L has exceeded 1,000 : Current P&L = " & PnL_Table[Total P&L]
4 To add the new trigger, we will need to add the line to Excel, this can be done by adding in the required values into cells B4:F4 (using the above formulas in cells D4 & F4), you will end up with something similar to this:
5 Finally we need to Push the new range to your Notifications Page. Select the complete range in this example B2:F4. From the ipushpull ribbon select the arrow under Push and click on Live. Select your Notification Page and click Live Push.
6 When prompted to Insert live push select the current cell used to push your page (in the example A1) and this will then over write your existing Live Push.
Don’t forget to check Auto Updates has been Started in the ipushpull ribbon in Excel.
7 Log into the WebApp and view your Notifications Page to confirm it has been pushed up correctly.