Jump to content
  • 0

Values cannot be submitted due to a data restriction



6 answers to this question

Recommended Posts

  • 0
On 8/19/2017 at 11:29 PM, KnowitallNZ said:



I am currently making a form in caspio. When testing my form I get the error values cannot be submitted due to a data restriction.

Thanks in advance. 

You may check your formula fields in table, I suppose that you submit a value in a field which causes error in formula

Link to comment
Share on other sites

  • 0

I got this error after updating a triggered action. The cause was a mismatched data type between the field I wanted to update and the field that contains the data. 

The thread referenced by RuisiHansamu is basically the same problem, in reverse. They changed the data type of their table field which caused a mismatch in a data type used in their triggered action commands. (The moral to the story here is don't change data type for a field that has any data or dependencies. To make a data type change, best to create a new field and configure relationships, forms and triggers to switch from the old to the new.)

If you see this error, it's likely caused by a calculation somewhere.

Link to comment
Share on other sites

  • 0

All, just wanted to throw in something that I should have realized from reading this thread... but it would have required me to read between the lines.  I was running into the above error when trying to run a trigger that inserted records into a subordinate table.  The problem was that the child table had referential integrity turned on, and since the insert of the parent record isn't complete until the trigger runs, it was failing the referential integrity check.

Also, something that helped me figure this out (because I wasn't smart enough to check the relationships first, and just thought I had written the trigger poorly):  I created a duplicate of the table I was trying to insert into.  It worked just fine.  That should have been my clue that it was the relationships / referential integrity!

Link to comment
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.

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.

  • Create New...