Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Expose RecordID in Formulas for Filters

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
alexagora
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

When building a filter for the sake of linking a row to another row in the same table, it would be helpful to eliminate the accidental selection of the same row. For example, we are trying to match buy and sell transactions to each other inside the same table. We we build the filter to limit which rows are shown in the selector list, we filter on things like "SKU = This SKU" via dynamic data to pull in the current record's SKU. However, often the selection criteria causes the record we are editing to show in the quick select list, leading to easy mistakes. We'd like to add a filter to say something like "RecordID != This RecordID" but the recordID is an internal/API field only it seems.  I suspect I could assign an autoID field, but those are dynamic and we see a warning about dynamic fields not matching correctly when trying that.  To be able to do it on the recordID without a synthetic extra step would be an improvement anyway.  

1 Comment
ScottWorld
18 - Pluto
18 - Pluto

 

You can expose the Record ID with the formula RECORD_ID(), but unfortunately, Airtableโ€™s dynamic linked record selection doesnโ€™t work with formula fields, so you would need to create an automation to copy that value into a normal text field to be able to use it for your dynamic linking.

ScottWorld โ€” Expert Airtable Consultants