Page 1 of 1

need help, how to send email based on document date meta

Posted: Wed Jul 27, 2022 9:11 am
by smeyer
firts of all, thank you for this GREAT software ;)

My problem:
how to do a workflow to send email based on invoice date ?
the goal is to send a reminder if some invoices are not paid after * days....

My documents values are:

Meta_FactureDate_R (in format dd/mm/aaaa)


I would like to do an action in a workflow with this condition but don't know how to write it:

if datenow - document.metadata_value_of.Meta_FactureDate_R # = the number of days since the invoice is in the system
>30 and document.tag <> "Paid" then SEND AN EMAIL else do nothing

how to do this ?