Hola!,
I think this solution applies to your case.
Here my step by step:
1- You have something like this, an Answer List table to save your answers
2- and another table where you set up your answers to have a kind of order/definitions
3- The trick is to bring all answers (one by one) to this table and create a list by using a Joined List column,
when your will have 3 answers lists in the table, the screen should look like this:
4- Now, create a new column using the Template type to merge 3 previous answer lists and have a single and larger answer list:
- finally, we need to use a small JS code to avoid creating more columns and got the final results you are looking for!
the JS code is this:
const arr=p1.split(",")
x= arr.filter(function(valor) {
return valor == p2;
}).length
return x
I suppose that another no-code idea/solution (100% pure) can be used here but this is very efficient and quick to avoid creating many columns.
Espero te sirva y puedas seguir avanzando en tu APP!
Saludos @Priscilla_Garcez