Computed 'Conflict' columns (built from a Users→Allergies relation and lookup) don't appear as filter options on the Recipes screen, even though they calculate correctly in the Data tab

Ask for Help
1

“I built ‘Conflict’ columns (If-Then-Else type, checking a User Profile lookup against a recipe allergen column) — they calculate correctly in the Data tab (Y/N), but they don’t appear as filterable options on the Recipes screen’s Filter Data. Only the raw ‘Contains X’ and ‘Current User X Allergic’ columns show up. Is there a column-type restriction here, or a different pattern I should use to filter a list by a computed comparison?”

2

Is the table a Big Table?
This sounds like one of the limitations of Big Tables.

3

Thanks for checking! It’s a regular table with only 20 rows, so I don’t think it’s a Big Table. Any other ideas what might cause this? Happy to share more screenshots of my setup if helpful, otherwise how do i check for sure whether its a big table?

4

You can tell by the icon next to the table name. If you show me a screen shot I can tell you.