Why Values cannot be submitted due to a data restriction

[vidierre]

I have a for_students table and when I add a record from the CASPIO web pages (from the Tables section of my app) I can insert new recors, if i make a Submission Form Data Page I got the terrible message Values cannot be submitted due to a data restriction. 

You have to consider that the for_students table:

1. Has no input Trigger
2. Has only one unique field named ID that is a GUID
3. Has two Function fields:
   a. the first put in lowercase the email fiele: Lower([@field:st_email])
   b. the second build the initial psw for the student using firstname and lastname: Upper(Left([@field:st_nome],2))+Upper(Left([@field:st_cognome],2))+'-school'
4. Has three relationships as parent with three differents tables: Attacchments, Valuations and Subscriptions
5. The datapage has non formula or parameters or anything complicated. It ghe the input for: Name, surname, email, phone, State, department, kind of student

I tried:

• to build a different datapage - same error
• to check for all three dependecies if there were broken childs
• to follow hints fromeitherand

What make me crazy is that adding manually from CASPIO web interfaces all works fine! What can be the different behaviour adin from datapage?

[NiceDuck]

How about formula fields or calculated values?

You may want to check if you have a formula fields there which the formula used has conflicts with the value on the actual field.  There can be multiple reasons for it but the common one is division by Zeroes.

[cheonsa]

If you only have an issue when submitting a record via DataPage, you may be using a Calculated Value/ Calculated field and the result is incompatible with the DataType of the field in your Table.