Lookup that only displays linked records that have a specific check mark?


#1

I’m looking to create a field that only shows linked records (or text strings from that linked table) if those records have a specific check mark. Does anyone know if there’s any way to do that?

Thanks!


#2

I’d create a formula field on the table you intend to roll up:

IF({specific_checkmark},{field_for_rollup})

This will only show you field if the checkbox is checked. Then you can just roll it up in your other table.

*You might have noticed I didn’t do ‘CheckMark = 1’. Any positive number computes to true so I leave out the ‘= 1’. You can also do the same with ‘= 0’ because that computes to false.


#3

Could you use a lookup field to pull the checkbox into the linked table and then use a filter to only view the fields that are checked?

That’s what I did here: https://airtable.com/shru2SaCdPCUJ23ck/tblubgfWfPz5I7OUo/viw47gr3gSfvBNAVi


#4

Thanks! This worked, but the record comes in as a string, unfortunately. When I use the Template Block, it essentially comes in as a single string instead of a bulleted list of the checked records.

This might be the best option available, but curious if there’s another way that would allow the formatting in the Template Block to still work?


#5

Hi @Jason_Chen !

I haven’t used Page designer block that much, but it looks like it can only make a bulleted list from linked records. The formula field is always going to compute to be either a string, number, or date.

There is a quick copy past work around though:

  1. Create a empty linked record field ‘filtered_records’
  2. Copy the formula field into
  3. Use this new field for your bullets
  4. Repeat anytime you have to print this :neutral_face:

You’ll have to be pretty careful if you forget the information will be outdated. Because of this I’d suggest clearing out the column after you print.


#6

Ypu can roll up the target values using an aggregation function of ARRAYJOIN(values,'\n'). That will put each rolled up entry on a separate line. If you want a bulleted list, create a forula field in the target table that prepends a bullet character followed by a space (’'• '’) to the text you wish displayed and roll up that field. (The newline-terminated text will display properly in a grind view with row-height set to anything other than ‘short’ and in Page Designer.)