Limit Responses for sign-up sheet with multiple options

[Julia Prattinger]

Hi there,

I have the following problem:

I would like to create a sign-up sheet with 3 dates and limit each of the options to 8 people. Now I tried doing this with Formranger, following the tutorial step by step. What happens each time is that it works for the first option (after 8 people, it shows that the session is full), but it doesn't work for the other two options (it displays that the session is full on the Excel Sheet, but on the form, you can keep signing up)

Not sure where I have gone wrong. Do you have any advice on how to fix this?

Cheers, Julia

[Joseph Schmidt]

Are both entries named "session is full"?  That is a duplicate and Google will not allow duplicate entries.  Change your formulas to either eliminate a choice when it is full or name it "session one is full" and "session two is full".

Either way, you will no longer have duplicates.

There is a link to an example file in the description of the group.  I know it is poorly documented.  I will clean it up when I have time.

If I have guessed wrong, please let me know.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/f09dacc6-eba1-496f-940f-1d3e674731f2n%40googlegroups.com.