Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Highlight matching data in look up fields in a record.

Topic Labels: Base design Data Formulas
490 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Henry9902
4 - Data Explorer
4 - Data Explorer

Hi all,

I'm using Airtable for a recruitment company. I have a table for candidates and for job listings. I want to be able to enter a new job with a salary, location and function and then have candidates who match the 3 criteria highlighted.

So far I've created tables for salary, location and function then put linked fields for each in my job listing table and candidate table. 

So I can now tag the roles and candidates with each criteria and then using look-up fields show the candidates who have matched each criteria individually against the role.

It would be great if there was a way to show candidates who match each of the 3 criteria. So a way of comparing the data across 3 lookup fields and highlighting any matches.

 

Or is there an easier way to achieve this?

Many thanks

0 Replies 0