Function based on a Repeating Field

[Thompson]

I have developed a database for our new employees to track their initial 3 years developmental assignments. The assignments are to be limited to 9.

To track dates, I created 2 fields

Layout.pdf

Layout.pdf

[transpower]

Sure. In Specify Calculation, Date_Out (which would be a repeating field with 8 instances) =

Let ( [ R = Get ( CalculationRepetitionNumber ) ] ;

Date_in[R+1] - 1

)

[-Queue-]

Not so easy for version 5. Status(CurrentRepetitionNumber) doesn't work in field definitions, so another auto-entered 'index' field is necessary to track the repetition. And the GetRepetition bug makes this much more complicated. I wasn't able to make it work when I messed with it yesterday. Since you're trying to get the next level down instead of the current one, it doesn't seem to want to return anything. It would probably be much easier to either script this process or make it relational with a separate file, one record for each project.

[Ugo DI LUCA]

Hum...

Surely a relational solution would be better.

In the meanwhile, following the first DateOut calc example, I can't see what's wrong with a calc repeating of type cDateOut = DateIn+1 ?

Ooops...Got it now. Sorry !

[-Queue-]

I couldn't get GetRepetition( DateIn, index + 1 ) & TextToDate("") + 1 to work yesterday. It's the date one level down that you want to use to determine the DateOut, not the date in the current repetition.

[Ugo DI LUCA]

Got it.

Did you say Status(CurrentRepetitionNumber) wasn't introduced with 5 ?

[-Queue-]

Not for use in calculations. It only works in scripts.

[Ugo DI LUCA]

You may grab it with another calc too...

[Ugo DI LUCA]

Like this may be....

assignements.zip

[transpower]

I upgraded from version 5 to version 7 specifically to take advantage of all the new features, as discussed; I'm never going back to version 5 or 6. I recommend that Thompson bite the bullet and upgrade.