I, Community,

I need your help.

Shopify is connected to Airtable.

I have all my product with stock quantity on Airtable.

I sell plant, i have loss product and i want limit it.

Is there a formula to know : since when do I have this plant in stock ?

and more precisely, in my stock of plant “A” for example, I have 3 plants which date from July 12 and 7 plants which date from August 15. Is it possible to have a view by stock update?

These different visibilities will allow me to limit my losses of plants.

Thank’s for your help.

Matthieu

Thank’s a lot for your help.