[SOLVED] How do I check if the 'next year' appears in an autoaction?

I wish to check if 'next year' does not appear in a field in an autoaction.

I can see I can use the:
[cb:parse function="time"][cb:date format="Y" /][/cb:parse]
to get the current year in a filter.
Is it then just make a filter like this
[cb_year] DOES NOT CONTAIN [cb:parse function="time" time="+1 YEAR"][cb:date format="Y" /][/cb:parse]
?

The time function is just strtotime. With the time parameter it's the same as doing the following.


Without the time parameter it's the same as doing the following.


None of this is relevant if your year field is not actually a date or datetime string as it can't be properly parsed by strtotime. If it's simply 2016 for example you'll need to use the math format function to add 1.

Aside from that you'll need to provide sample values you expect cb_year to be set to in addition to an example of what you're trying to accomplish for me to suggest anything further.

Hi Kyle

Ok, the field I'm checking against is just a multicheck field that I've entered the following in:
2012
2013
2014
2015
2016
2017
2018
2019
2020

Then we just tick of for the years paid.

So when we receive payment for 2017, we just tick of 2017, and then in november we check if it's ticked, and if it's not, we activate the 'reminder' flag, which then in turn triggers them to be added to an acymailing list.

I'm currently doing this with an external sql script, but would very muck like to move it 'inside' joomla.

I could also change it, so that we just have a flag that marks if 'next year' is paid, and we clear that in august or something like that, and then set it again when payment is received, but it's nice to have the 'history'.

I'm unsure why you need to increment it then. If in November you're checking if the current year is ticked you'd just do the following.

[cb_year] Does Not Contain [cb:date format="Y" /]

In the above case you'd send a reminder or do whatever behavior you need for the reminder as it means the current year isn't checked. If you need the next year then the below will probably work.

[cb_year] Does Not Contain [cb:parse function="math"][cb:date format="Y" /] + 1[/cb:parse]

I'm trying to test if it works.
So I click 'click here to execute' 'inside' the action, as I understand it, it will only run for the currently logged in user?
No matter if I tick 2017 in the multiselect for my user, I get added to the reminder list, so it seems to not work?

Is there a way I can get to see what the formula outputs?

The execute button does not execute it on the current viewing user unless you've set User to User. Otherwise it's always going to be ran on an empty user object, which means the condition will always pass because cb_year will always be empty.