Struggling with what seems to be a simple error but weird situation "This entry is invalid"

[iamhitesh89]

I have a very simple dataset with "Term," "Chapter," and "Description." The key and label is selected to be the "Term" column. I'm experiencing the following two issues.

1. I'm not able to edit the existing entries beyond a few limitations, which is shown in the below Photos. The description has to match the previous entry, and if all matches the same, it doesn't allow me to add more characters to it. (Look at the Test 5 entry.)
2. I'm not able to add new entries too. I ensured the table settings are checked ON for updates, adds, deletes. The database is also ensured to be free from formatting. 
3. Existing entryEdit acceptedInvalid entrySettingsSettings

I'm still a noob here. Trying to build a simple data collection (like a dictionary/glossary) for the technical terms that I'm learning in my classes. Any assistance here would be greatly helpful.

Thank you!

[WillowMobileSys]

Please show us what you have implemented in the "Valid If" property for the [Definition] column.  The expression you have inserted there is not allowing the "Test 5 566" value to be saved.

[iamhitesh89]

There is no "Valid If" property assigned to any column. Do I need to have an expression for it?

[Steve]

Please post a screenshot of the entire configuration of the Definition column.

[WillowMobileSys]

Hmm...Can you show the configuration for the "Definition" column?

Since it is defined as LongText it should accept anything, or nearly anything, that is typed in or inserted.  The only way I can see if it was invalid is if there was some kind of validation implemented.  Seeing more details about that columns might shed some light on the issue.

[iamhitesh89]

@WillowMobileSys @Steve I have resolved the issue. I have figured that my sheets was running a script on Apps scripts that I earlier deployed and forgot about it. Since it was also allows users to edit and make new entries, the AppSheats was trying to protect the dataset and not allowing me to make new entries. 

I have now created a whole new sheets and copy pasted the values without any scripts running. This worked flawlessly.

Thanks a lot for your time and support! Appreciate that a lot.