Jan 04, 2019 11:05 AM
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?
Jan 04, 2019 01:05 PM
I’d create a formula field on the table you intend to roll up:
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.
Jan 04, 2019 01:15 PM
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
Jan 14, 2019 02:37 PM
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?
Feb 08, 2019 01:20 PM
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:
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.
Feb 08, 2019 07:11 PM
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.)
Jun 02, 2020 11:45 AM
This is the closest question I could find to the hurdle I’m facing. Is it possible to pull data based on a checkmark field?
Looking at my current setup if a project is reinstated, after being on hold, canceled, etc. the record will go back to the proposal table, after updating the record. I’d like an easy way to show additional details without adding all the extra fields. Is this a formula? Or am I missing the part of the conditional options in a checkbox field?