Workflow Trigger, i need help

[animax]

Hello,

In an entity, a date is stored in a date field.

Now the problem:
If today is the day specified in the date field, an email should be sent to a specific address. How can I set this up?

The complete data record with the date field is not touched for months, nothing is changed.

So far, I have not gotten around with workflows. Maybe you have to create a business rule? Could someone help me?
Crons are working...

I would be very thankful for help.

Stephan

[Maximus]

Hello,
Please try to make this:
1. Create a list report, set a filter (if the field 'date' = 'today');
2. Create a workflow: trigger type = 'Scheduled' (0 1 * * * ), choose the report, set an action 'Send Email'.
0 1 * * * means that workflow will start and run your report every day at 1 am.

[animax]

Hello,

it works perfectly! Thank you so much!

[jarmito1971]

I have list report and I create a workflow: trigger type = 'Scheduled' (30 19 * * *), choose the report, set an action "Send Email" but it doesn't anything and don't show any log. What's wrong?

[Maximus]

Hello.
Please check if your cron is configured. This can be helpful https://www.espocrm.com/documentatio...re-not-working.
If it is ok, go to Administration -> Settings and check if the Disable Cron checkbox is unchecked.

Also, it can be linked to this issue https://forum.espocrm.com/forum/gene...eport-by-email

[jarmito1971]

Where is Optiong Disable Cron checkbox?
I also have this messages inside my Cron Sheduled jobs

[Maximus]

The Disable Cron checkbox is in the Administration -> Settings. Such function has appeared in the EspoCRM v.5.6.0.

[jarmito1971]

I have opened SSH Console in my hosting web server and I followed steps of this article https://www.espocrm.com/documentatio...etup-a-crontab
Something changed at my Crontab Sheduled with new jobs but follow State Pendent. Attached print screen

[jarmito1971]

I have version 5.6.2 now but sheduled jobs at state pendent yet, where is option "Disable Cron checkbox" is unchecked.

[jarmito1971]

I have found option at General Setting, Disable Cron checkbos is unchecked

[jarmito1971]

Now I have this line * * * * * cd /var/www/vhosts/tabisam.es/desarrollo.tabisam.es; /opt/plesk/php/7.3/bin/php -f cron.php > /dev/null 2>&1
I add SSH Console my crontab file

[jarmito1971]

I have that message to run cron.php in SSH Console following documentacion about crontab

root@dns72156:/var/www/vhosts/tabisa...llo.tabisam.es# php cron.php
PHP Catchable fatal error: Argument 1 passed to Espo\Core\Container::get() must be an instance of Espo\Core\string, string given, called in /var/www/vhosts/tabisam.es/desarrollo.tabisam.es/application/Espo/Core/Application.php on line 48 and defined in /var/www/vhosts/tabisam.es/desarrollo.tabisam.es/application/Espo/Core/Container.php on line 41

[Maximus]

To make cron works you should add the cron command to your crontab file. This command you can find in the Administration -> Scheduled Jobs (in the top of the page). This will help you https://www.espocrm.com/documentatio...etup-a-crontab.
Note that the crontab file should be configured by a user who is the owner of your web server.

[jarmito1971]

Hi, I have crontab file with this command that appear at my Administration --> Sheduled Jobs
* * * * * cd /var/www/vhosts/tabisam.es/desarrollo.tabisam.es; /opt/plesk/php/7.3/bin/php -f cron.php > /dev/null 2>&1
My file crontab is called

[jarmito1971]

I have active Cron Tasks en my hosting panel working but add cron task and doesn't work