Forum Discussion

Qrew Assistant Captain

8 years ago

Create a Collection Schedule by day of the week

I am trying to build a table for a specific task that I complete. I collect a set of data from some customers once or twice a week. Some are on Monday and Friday, some are Monday/Thursday, some are ju...

MCFNeil

Qrew Captain

8 years ago

Andreonna,

How are you?

If I were to do this, I'd create some formula date fields to identify the date for the collection days. You would need 5 or 6 (one for each day of the week).

Then you would need to take the summary field of the [Last Collection] and compare that to the Minimum date that is after your [last collection] date. Thus, giving you the "next" date.

Does that make sense? Do you need more details?

AndreonnaGarret

Qrew Assistant Captain

8 years ago

How exactly would I set up the formula fields?

Forum Discussion

Create a Collection Schedule by day of the week

Related Content

Preventing Scheduling Conflicts

Scheduling Formula needed

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Create child records from Parent List - User field