counting the first record

[Aussie John]

Im adding automated clause numbers to a portal using an auto entry calculation and the Count function.

Unfortunately I cant get the first row to number (presumably because it hasnt been fully created yet). I tied a case statement to no avail.

Case(Count(minutes::minutes)="";"01";

Count(minutes::minutes))

What else could I use? i also tried isempty and isvalid. thanks

[Vaughan]

Have you tried @@ in a text block in the portal row? That won;t really number the portal records, only display numbers in the portal rows.

Alternatively, try creating a cal field in the parent record to count the related records. Then put an auto-enter in the related records that = parent::countrelated + 1

It might not work because auto-enters don't always like pulling in info from related tables.

[Aussie John]

basically i have a series of meetings (and different projects) and a number system of 01(meeting number).01(minute number) so @@ wouldn't work. I havent tried your alt solution but i think it would suffer the same fate as my solution in that the first minute doesnt fully exist until after the auto calculation count.