Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple time frames based off item select

Topic Labels: Formulas
523 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am trying to do a date diff formula and i need help. Lets say it has to do with aging. Products a for a 1 week, product b for 2, etc. If I have product type in column “Product” and start date in “last active”. I need “aged” column to look at “product” to get the type know how many weeks it needs to age and do a date diff from “last active” to tell me either “within min time” or “time met”. Any ideas?

1 Reply 1

basic structure,

1st, create a table that has product names and aging times

2nd table has list of instances(ex. specific wheels of cheese), and has the date you got the wheel, has a linked field to the appropriate product type in table 1, and then use a Lookup field of the linked field to pull the aging time from table 1. You can probably do the datetime_diff() from there.

5f73751092c6afb3485d0dfe997b3809227f5002.png

Linked record fields

A linked record field allows you to represent the relationships between related records by creating links between them. This is particularly helpful when you have multiple tables of related items o...