Trouble using Google Quiz "Score" as condition to merge / send certificate

[Nathan Stump]

I'm trying to only merge / send a certificate to people who score 7 / 10 (or higher) on a Google Quiz that feeds my Google Sheet. Everything works if I don't apply any conditions.

The issue seems to be that Autocrat doesn't recognize the "Score" values to be used in the conditions. The Google Quiz is generating a customer number format (0" / 10") for the Score when it creates the row. I've tried using "10", "10/10", "10 / 10" with no luck. (Both with and without quotes)

Has anyone been able to use Google Quiz Scores as a condition successfully???

Thanks!

[asm...@newvisions.org]

Hello,

For this issue, I think you would either have to change the number formatting on the 'Score' column or insert an extra column on your sheet with a formula to determine if the value in  'Score' meets your criteria.

 To change the number formatting, highlight all the rows under the 'Score' column and go to the menu that runs across the top of your spreadsheet → Format → Number → Automatic. This for example will change a '10/15' to '10' and then '10' would work as your Autocrat merge condition.

However, I think it would be much more efficient to just add a new column to the right of your 'Score' column and insert a formula such as  =IF(GTE(B2,10),"yes","")  which will tell you 'yes' if the number in the 'Score' column is greater than or equal to 10.

Then you would point Autocrat to look at this column and use 'yes' as your merge condition. Hope this helps!

(if you are running this job on a form trigger, I would suggest either wrapping this formula in an array formula or using an add-on like Copy Down that will the formula down onto new form submission rows)

[Nathan Stump]

I was able to get this to work by creating 4 different jobs on my sheet. One for each "Score" value... i.e., 10 / 10, 9 / 10, 8 / 10, and 7 / 10. The problem turned out to be that I couldn't have 4 conditions in the single job, as the conditions appear to be "and" statements instead of "or" statements. 

Unless there is another way to create the condition(s) to accept any of the 4 different passing scores, I can't see a way to do to it unless I do something like you did above? 

[asm...@newvisions.org]

Hello,

You are correct, merge conditions entered in the job settings cannot be "or" statements, they need to be either a specific value (such as 10 or yes), NULL (empty) or NOT NULL (not empty). This is why if you have a condition that is an "or" statement or not a fixed value then the workaround is to use a spreadsheet formula like in the example above.