Want to check task fulfilments

[Andonisz_Haroni]

Hi,

We have been using Airtable for a while to collect real time data from commercial units where our field agents checks the stock available.

This is how it looks like:

Date / Product / Commercial Unit …

Each report has a deadline.

For example:

in row 10. For Biotech USA (product) at Hodmezovasarhely Interspar (commercial unit) the report has to be fulfilled each Monday and Thursday recurrently.

For each product and commercial unit we have different fulfilment date that has to be checked. We must notice if we don’t receive a report in time. Remaining with the example above:

Biotech USA at Hodmezovasarhely Interspar
09.20.2021.
09.23.2021.
09.27.2021.
09.30.2021.
ETC.
ETC.

Any idea how to work this out?

I will appreciate any support.

Thanks,

Andonisz