auto action for send email whith date condition

mfe13
OFFLINE
Posts: 572
Thanks: 26
Karma: 5

12 years 1 month ago #228671 by mfe13

auto action for send email whith date condition was created by mfe13

Hello,
I need to create an auto action to send an email to a user when he logs on to the site after a certain period, for example one month. But I do not understand the condition setting for the field [lastvisitDate].
thank you

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 49372
Thanks: 8452
Karma: 1465

12 years 1 month ago - 12 years 1 month ago #228711 by krileon

Replied by krileon on topic auto action for send email whith date condition

Not sure you can even do that easily. There is no relative date feature. You'll probably need to calculate the date with a CB Query Field then use that in your conditional. Example as follows.

Code:

SELECT COUNT(*) FROM `#__users` WHERE `lastvisitDate` <= ( NOW() - INTERVAL 1 MONTH ) WHERE `id` = '[user_id]'

The above example will return 1 if the user last logged in less than or equal to 1 month from the current datetime. It'll return 0 if the user logged in within the last month from current datetime. So for example you'd use the below conditional.

[cb:userfield field="cb_queryfield" /] Equal To 1

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Last edit: 12 years 1 month ago by krileon.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon