Skip to main content

Hi 

If it’s doable, I’d like to solve this problem. For the sake of simplicity, there are two tables in the base: Projects and RFPs. In the Project stable, there’s a single select “Project Type”, with options “Project; RFP”. I would like a lookup field in the Projects table that’s only enabled when “Project Type” is “RFP” to look up the relevant record from the RFPs table. Can it be done?  

Lookups in Airtable show information from a linked record in another table, but they don’t create the links themselves. You can add a filter to a lookup field if you’d like, but It sounds like what you want is to automate linking the records between the RFP and Project tables? 

That’d be something to build as an automation, along the lines of When Project Table Record option= RFP, Find Record in RFP table where Name=Project Name, Update Record in Project Table to link found record.

If you provide a screenshot of what you want accomplished that can be helpful too.

If your issue is about the linking, then DisraeliGears’ solution should sort you out.  Is there a unique ID that the Project and RFP share that you could use to link them?

---

If you’ve already got everything linked and it’s about display, then maybe you could use a rollup field with the following formula:

IF(
  {Project Type} = 'RFP',
  ARRAYUNIQUE(values)
)

 

Terms & Conditions