Forum Discussion
- QuickBaseCoachDQrew CaptainYou can have a formula field which calculates if the eetl is valid in terms of �every other� and add that as s condition in the steps in the Automation.
So the automation will run every week, but the individual steps will not fire.
To calculate if it�s a valid week, you can use the FirstDayOfPeriod function. Post back if you need help with that. - GideonAnsellQrew TraineeYeah... I'm not following you. I know how to construct the FirstDayOfPeriod formula to test for each 2 weeks, but not sure how you're proposing to use it in the automation.
- QuickBaseCoachDQrew CaptainI think I was confused, because it runs on a schedule and not a trigger. Can you tell me the nature of what the Automation does? If it was just perhaps an import, then the import could be cased to not actually do anything on the off weeks.