I am looking for a formula that will calculate historical orders placed with the option to query 14, 30, 60, 90 and all time order history. Is there a way to do this? I am very new, go easy on me :slightly_smiling_face:
I don’t have the pro plan (yet) I’m trying to teach myself (with your help) Airtable before deciding to invest. Ideally id have a list of products and then a field that allows me to choose how that specific products purchase history is referenced.
for instance, for milk products (which expire in 2 weeks) I only want to see purchase history for the past 2 weeks. Alternatively paper towels which don’t expire id like to reference for a longer history.