Asking for help multiple choice lead score

[Shadenhorlet]

Hi so im stuck with 1 of the variables im not sure if, im doing it correctly or if i am doing it really wrong

im using google sheets as a baseline for the computation inside make

so this is where im having problems the idea of it, is if it shows lets say Referral it gives 5 points else 0, my problem is if i place down event for example it should output 2 points but whatever i do it keeps out putting 5

as seen in the screen shot

but in other aspect of this scenario its working fine except that area and other areas where there is 2 or more answers

[Henk-Operative]

Hi @Shadenhorlet,

Welcome to the Make community!

You should use the ‘set multiple variables’ module instead of separate ‘set variable’ modules, for less operations. Then, if you want to show a result, it is best to use the switch() function in this case:

{{switch({{3.leadsource}}; "Referral"; 5; "Website"; 3; "Event"; 2; "Advertisement"; 1; "else")}}

Cheers,
Henk

[Shadenhorlet]

Hi @Henk-Operative

Thank you for replying, im pretty new but i want to learn the basics for the functions, thats why im not using the tool compose string but when i learn how this works i intend to shorten it like what was shown in the make academy.

but you basically taught me that switch should be used for choice items which is very helpful in the long run

Thank you
Shaden