Change Trigger on Variable not working

[#1]

I am currently working an application and trying to make a variable trigger another action when the value of the variable changes.  This is the formula:

=if(min(floor(Date))>=floor(addmonths(MaxDate,-24)),1,0)

I see the value of this variable change, but it is notcausing the trigger to activate on a change.  Do you know if there is a limitation on the variable triggers based on the formula above?

Thanks

Nilesh

[swuehl]

I think this should work.

Could you upload a small example app which shows the issue (Upload is available in advanced editor)?

What kind of trigger / action do you use?

Regards,

Stefan

[#3]

Hello

The problem is that the trigger action is activated when de variable content/expresion changes, not when de value changes.

In this case the variable content is always the same:

" =if(min(floor(Date))>=floor(addmonths(MaxDate,-24)),1,0) "

so, the trigger isn't fired.

I don't know why... I also have the same "problem".

It would be nice if the trigger being also fired when the evaluated value changes.

Regards,

Cristian

[#4]

Hi,

I have similar problem. I dont know whether you found a solution or maybe its mentioned somewhere in the reference manual... I will try to do some more research.

What I've noticed so far, it works when the value of the variable is displayed somewhere on the document sheet. The bad thing is if you have more sheets and you want it to work it must be on all of them just in case you are on another sheet.

Its not difficult workaround but I am surprised by that.

You can create a text object with =YourVariable, change transparency to 100 for background and font colour...

I wont work if you hide it

Regards,

Lukasz

[#5]

Have you found any solution on that??

I have exactly the same issue and I have not been able to solve it yet.

[#6]

Check the attached one.

[#7]

I don't think this will work in my case. As in my example I have 5 sheets and I have a trigger on change on vShow:

Trigger on vShow to activate sheet:

if($(vShow)=1,'SH07',IF($(vShow)=2,'SH08',IF($(vShow)=3,'SH09',IF($(vShow)=4,'SH10',if($(vShow)=5,'SH11')))))

vShow=if($(vSeconds)<30,1

,if($(vSeconds)<60,2

,if($(vSeconds)<90,3

,if($(vSeconds)<120,4

,if($(vSeconds)<150,5)))))

vSeconds=mod(round((now()-now(2))*86400),150)

[#8]

I think , Trigger is not required for this

You can write sheet con dition on all sheets

Ex:

Sheet7

Cond : =if($(vShow)=1,1,0)

Sheet8

Cond : =if($(vShow)=2,1,0)

etc...

[#9]

The problem is that I don't want to hide all sheets apart from one, I just want to activate them as I have another more complex trigger system that activates certain sheets.If the sheets are hidden they wont be able to get activated I guess.

[#10]

according to the manual reference page 536

"Note!

Actions that trigger other actions, so called cascading actions, may cause unforseen consequences and are not supported!"