Get id of linked record via "lookup('Field1', 'id')" or similar function

I would propose a function that gives the id(s) of a linked record, or add that functionality to “lookup()”.

This would be helpful for checking if linked records in different fields to the same table are equal, without having to rely on the left-most field being unique in the other table.

Current workaround:
Make a formula field in the other table that just displays the id, then compare those via “lookup()”

But this feels kind of unnecessary.

Hello @fjodorsch, thanks for sharing your idea :heart_hands:

I’ll discuss the request with the team.

Hello @fjodorsch :wave: I just wanted to let you know that your request has been accepted. I’ll make sure to keep you updated on any progress and share it here.