UPDATE trigger

[mak]

Can someone help with the syntax of update trigger?

i have a formula for example if(h5>3;"BACK";"") where & how can I add the UPDATE function?

I need to update the odds if my submitted bet is far behind the available odds

thanks

[GaryRussell]

1) Put "UPDATE" in the trigger column
2) Change the odds in column R to the new odds
3) Column T should change to a new ref to indicate is has been updated. It may have "N" appended if you have selected this option when setting up the Excel link.

The best thing to do is try it manually first to understand what happens.

[mak]

Gary thanks just test it
Is there a way to have the UPDATE trigger in my formula or it must be placed with vba ?

if it can be done with formula can you give an example please?

[GaryRussell]

There's no reason it can't be used in a formula. You just have to decide what conditions should trigger the update. You need to explain exactly when you want the update to trigger for someone to be able to provide an example.

If you don't intend to use VBA then you should make sure that "UPDATE trigger appends 'N' to new bet ref" is not ticked when you set up the Excel link because you will have no way of removing the "N" which will block further UPDATE triggers.

[mak]

It is OK now I figure out the formula
Thanks Gary