View Last entered portal in List View

[projay]

I have a simple check out/check in...system of tools

I made a record for Tool One

This record contains portal rows for People that will checkout and check in this tool. (Everything is work like it should.)

Lets say..,

TOOL ONE is

CheckedOut(date) and CheckedIn(date) by BOB

(after its check in it is AVAILABLE again to checkout)

Lets say...again

Tool ONE is

CheckedOut(date) and CheckedIn(date) by LARRY

In List view i want to view the most recent

CheckedOut and CheckedIn information it only shows

me the FIRST CheckOut and CheckIn Information of BOB.

How do I view the most recent? Which would be LARRY's CheckedOut and CheckedIn information in list view.

I hope I was able to lay this out in a simple way...Jay. Thanks again fo all the help.

[Matthew F]

How are you attempting to identify the records of interest in your list view? Are you performing a Find, or are you using a relationship (e.g. the 'Go to related records' script step)? Or are you not viewing records as a list, but actually viewing related records in a portal? If you are using a relationship in either of these ways then it would help to know the names of the tables and how the relationship was constructed.

[projay]

Hi, thanks for response.

I am performing a find.

It is in a list view.

It is a relational dbase.

Jay.

[Matthew F]

OK. So your find is not retrieving the records that you want to view? What are your Find criteria? What values are you placing into what fields. If they are in related records, what is the relationship to the current table?

[comment]

In List view i want to view the most recent

CheckedOut and CheckedIn information

Option 1:

Sort the relationship by CheckedOut, descending (you will probably want to sort your existing portal the other way).

Option2:

Place a one-row portal on your list layout and sort it as above.

Option 3:

Define a calculation field (in the Tools table) using the Last()) function.

[projay]

Well i a have tried the option 1 & 2 and still show the most recent portal line input.

Not quite understanding option 3.

Jay.

[comment]

Well i a have tried the option 1 & 2 and still show the most recent portal line input.

Isn't that what you wanted?

[projay]

OOps, I meant it doesnt show the most recent.

[comment]

I am not sure where you your difficulty lies. The attached file show options 2 and 3. I cannot show #1 in the same file, because it would break #3.

LastDate.zip

[projay]

Hey Comment, Thanks for the sample it works great and I will give it a try and create that additional field Last() now the that i actually seen how you did it. Appreciate your prompt assistance.

Will let you know how it goes.

Jay.

[projay]

I made the clast() calculation field and instead of a date I just get ie..734087 in that field and not a date. Any thoughts on this?

Jay

[comment]

Set the result type to Date.