ShareFile

Set Due Date Based on Frequency Field

The aim is to set a recurring due date for tasks or inspections in Podio based on a frequency field. Additionally, you want to account for weekends by ensuring due dates fall on the next weekday if necessary.

You can use Podio Workflow Automation to create a calculated variable that dynamically sets the next due date based on the specified frequency (e.g., daily, weekly, monthly, etc.). Add a condition to adjust the date if it falls on a weekend.

Example:

Var Frequency

(
[(Inspections) Frequency] == "Daily" ? "1 weekday" :
([(Inspections) Frequency] == "Weekly" ? "1 week" :
([(Inspections) Frequency] == "Monthly" ? "first day of next month" :
([(Inspections) Frequency] == "Quarterly" ? "3 months" :
([(Inspections) Frequency] == "Yearly" ? "1 year" :
"")))))
<!--NeedCopy-->

Without Weekday Factor

Var nextDue1

date('N', strtotime([(Variable) nextDue1])) >= 6
? date("Y-m-d", strtotime("next Monday", strtotime([(Variable) nextDue1])))
: [(Variable) nextDue1]
<!--NeedCopy-->

With weekday factor

Set Due Date Based on Frequency Field