Have tried going through the other topics to find what i need but doesnt seem there is an answer or a way to do what i need but will try ask with specifics or what i need and go from there.
I have a base that imports entries from an airtable form of tool movements aka date, plant no, original location and new location. This could mean multiple tools so i made a linked plant no column to another table with our inventory.
For the information to pull through to the inventory i have made look up columns to pull the information through for one tool vs them in a group but with the look up field i would like it only to show the most recent information or at least fill them in most recent to oldest for easier viewing.
Is that possible?
I have also tried an automation to update each listing but with no luck at separating the bulk entries into separate tool listings.
Thanks in advance