I'm building a multi-score personality quiz that assesses different parts of the personality through a series of different sections (question groups).
In the first question group, each answer a user chooses is set up to add “1” to a numerical custom variable. At the end of this question group, I want to calculate which of 8 numerical custom variables has the highest numerical value, in order to score which “type” they are—and then store the result in a custom text variable to use to display to the user with recall (@).
I understand how to set up custom variables and have many set up, and I have the proper if/then statements set up inside Branching Logic to store 1 point inside the proper variable based on their answers. Branching Logic seems like the only place to calculate using custom variables, but when I try to add rules that compare a custom variable to another custom variable, I'm blocked by the fact that I can only enter numerical values for any kind of compare or calculation… I can't calculate using more than one custom variable at a time.
Is it possible to do calculations using more than 1 custom variable?? This seems like a really important feature lol but maybe I'm just thinking and going about this wrong.
I guess I’m basically trying to figure out how to do spreadsheet formulas that recall specific cells to calculate something, though I can see there might be a better way to go about this scoring strategy? Or perhaps a better quiz making platform for what I’m trying to do? Or are people doing this using integrations with Google Sheets? Pleeeeeasseee help!!!!!
