When you have a form associated with a sheet, and then rename a drop down item at one of the columns for which logic is associated to, you will see the logic disappears at the form. This is an expected result since an error message appears (see screenshot below). I request this not happen. To leave the ability to rename a particular drop down item without the logic associated to it falling off.
This expected result is not ideal - the error message does not appear until after saving and leaving the form builder making it difficult to see the logic has been removed.
I also noticed I recently added a new option in my drop down list but did not change/add any logic. The additional drop down option contains a word in two other drop down options and my logic for those 2 drop down options was removed.
A rename or an additonal drop down with a identical word in other drop down options should not impact logic - but if it must impact logic a pop up message needs to be provided prior to saving the changes.
Yes!! This is beyond frustrating when the logic just gets removed without warning! I would love to see a pop-up window letting me know what will happen if I continue with what I am doing and exactly what it would erase.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
I agree this is extremely frustrating. I disagree that the result is expected. The change goes into affect without clicking Save. One can't undo, or back out to revert. Sheets always require saving to make changes go into effect. Why don't forms?