Problem with weighting and mapping typeform - tools - google sheets

[Belito]

What is your goal?

I want to enter total value and category into a Google Sheets sheet to display it in Looker Studio

What is the problem & what have you tried?

I tried using three Tools modules: one with if statements to weight each response, since the value differs depending on the statement (20 in total) and the entered response (4 possible answers). Another module sums the total score, and a final one assigns the corresponding category based on the total. Then I used Google Gemini, which generates a document with all this information, but I had to design a prompt for it to make its own estimate because the Tools modules always provide an average value.

[Donald_Mitchell]

Hello @Belito and Welcome to the Make Community!

In the “contains” function, you should only use double quotation marks for the value if you are actually expecting double quotes to be found in the array you’re searching. Otherwise, you should remove those.

Do you have an example of input data to share? That would help a lot!

---

Hola @Belito y bienvenido a la comunidad de Make!

En la función “contains”, solo debes usar comillas dobles para el valor si realmente esperas encontrarlas en el array que buscas. De lo contrario, debes eliminarlas.

¿Tienes algún ejemplo de datos de entrada para compartir? Sería de gran ayuda.