FormRanger not able to empty the last remaining item

[Kim Nilsson]

This is probably not FormRangers fault, but a limitation of Forms.

I have a simple form with only a single question and only two alternative items (in the  Sheets column Available Sessions  I have two rows) to choose from. There are 12 available seats, and when it reached 12 seats for one of the items, it was properly removed from the list of available items in the Form.

But when the second item also reached 12, the Sheet column for Available Sessions was emptied, as expected, but in the Form the question still has the previous value for the item, despite me running FormRanger manually several times.

This of course, left the Form open, and there was a 13th person able to book a session, as it was still listed in the Form.

So FormRanger is most likely not able to remove the last item in a multiple choice list.

Instead I had to add a "Session 1 is fully booked" and "Session 2 is fully booked" to the formulas in the Sheet, so FormRanger has a real value it can push to the Form.

It would have been cool, of course, if FormRanger had a variable I could set, which would only show when there are no items pulled from the Sheet! It'd have to be an open text box, so FormRanger admins could enter any type of information there.

Something like "There are no bookable sessions".

This would then show as the only available option.

[Joseph Schmidt]

I'm happy that you solved your problem.  FormRanger needs at least one item to update.  You discovered this.

You could have a 3rd item that is controlled by a formula to only show when both sessions are full.  

You can accomplish what you want.

Let me know if you have any questions.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 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/86104625-6d08-4e7e-b77d-029458d3e2f6n%40googlegroups.com.

[Kim Nilsson]

Hi, Joe.

Would using the same text for both items (in fact create duplicate items) accomplish my ultimate goal = only show one item in the form, saying "All sessions are booked"?

I didn't read the issue with duplicate items closely, as it wasn't my problem.

[Joseph Schmidt]

You have to create a third item in the list that only shows when both items are full.

When you start, A and B will show.

When A is full, it is removed from the list.

When B is full, the 3rd item will replace B.

The above assumes that A fills up first.

See example.

=if(COUNTIF(B3:B,"?*")+COUNT(B3:B)=0,"All choices taken","") in B2 of New Values sheet.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 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/d83202f8-9df4-4cce-a98b-64217e27f49fn%40googlegroups.com.