Jump to content
  • 0

Values cannot be submitted due to a data restriction.


Question

2 answers to this question

Recommended Posts

  • 0
18 hours ago, rasasayang said:

Hi, just start using this amazing caspio to create a form for internal user.

However when i try to submit the form, it says  Values cannot be submitted due to a data restriction.

Anyone can point out what i could possibly did wrong?

Thanks.

Hi, you may check if you included field which is used in relationships. If  your form is built on a child (related) table you may see this error if you don't fill out the field which is used in relationship. 

Hope it helps 

Link to post
Share on other sites
  • 0

There are some cases when the error "Values cannot be submitted due to a data restriction" occurs:

1.  When there is a Formula Field in the table.  Make sure that the formula in the Formula fields should not contain empty values and all the values should be cast to the one type. To make the formula correct you should wrap the fields to the isnull function to replace the Null value with 0.  Also, when you perform any operations with the different data types you should convert them to the same one.

2.   When the referential integrity is broken. Please follow this link for more details:  https://howto.caspio.com/tables-and-views/relationships/relationship-settings/

3. When tables or datapages are corrupted after making some changes, for example, modifying the table design, adding/removing relationships, datatype changes, etc.  These actions lead to some missing constraints in the table and seem to cause an issue at the server level. You can try export and import back the datapage with dependencies.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...