AnsweredAssumed Answered

AutoFill depending on value in range

Question asked by JasonHyde on Sep 15, 2010
Latest reply on Sep 15, 2010 by philmodjunk

Title

AutoFill depending on value in range

Post

Hi,

I am struggling with creating an autofill type field based on another fields value. I'll explain.

I enter a date in to field1, I also have records that have this structure:

Range1 - Start Date, End Date

Range2 - Start Date, End Date

So if my date entered is within Range1 I would like field2 to autofill to Range1's Label. Each range is unique and does not overlap, so there is no conflict. It's a tracking problem - I need to know where something is depending on the date it was created.

Anyone suggest a solution?

Cheers,

Jason.

Outcomes