Re: Multiple time frames based off item select

FENIX_RI5ING · ‎Mar 28, 2019

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?

Mike_McLaughlin · ‎Mar 28, 2019

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.

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...