Look Up Field Help

Hi,

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.