This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Help with getting most recent value from list

Posted on 03-28-2019 01:35 PM
McKenna_Killion
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

I have two tables for tracking tool inventory/locations. “Tool Transfer” is filled out as a form to track when and to where the tool is being transferred. I then have a “Current Tool Locations” table where I want to just show where each tool is currently. I have the following virtual columns in Current Tool Locations:

Related Tool ID
REF_ROWS(“Tool Transfer”, “Tool ID”)

Most Recent
MAX(SELECT([Related Tool ID][Timestamp], true))

Current Location
LOOKUP([Most Recent], “Tool Transfer”, “Timestamp”, “Transferring to”)

The problem I’m experiencing is with the Most Recent column. The timestamps being returned are not always the most recent. When I test, the list that it’s returning from SELECT() has the same timestamp several times, when they should all be unique values. (Returning 3/7/2019 when the most recent was actually 3/26/2019)

1X_298dec80dfed0847966771f6632bda8c3de52cd9.png

0 1 771
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
LeventK
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

@McKenna_Killion
I believe use of MAXROW() expression could be more beneficial in your case. As it will return the key column value, you will also have the chance of using de-ref expression to retrieve another value from that referenced table. You can read the further details from this page:

0 Likes
Top Labels in this Space