In my form screen I want users to be prompted to a table/list of times with only the items they selected from the from. I have a Max choice of two. I have my choice component column in my user table and the choice selections are writing to that column.
I’ve tried multiple different filtering methods, navigation choices on the submit button but I can’t seem to figure this out. I can get to the table of information I want but it keeps showing all of the items instead of just the list items from the choices selected in the form screen.
I figured out the filtering part, but now I’m running into an issue where my relation column isn’t recognizing a few of my rows, It will recognize all but two of my categories.
Set up is…
I have a choice component in my users form. That component is sourced from the table where my categories are. The choice component is written to my users table. I then created split column for multiple choice selections. Then I created a relations column from my split column to my source table where my categories are and then a relation column from my categories table back to the users table.
Everything seems to be working fine, I can select multiple and it customizes the choices but for whatever it will not show 2 of categories (total of 8) I went through my google sheets cleaned out the test data, deleted the relations column and re added them but get he same result. I even tried selecting just the one category and it still didn’t populate.