Values cannot be submitted due to a data restriction

[KnowitallNZ]

 

Hi,

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. 

[Mathilda]

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

 

Hi,

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

[JolliBeng]

Hi KnowitallNZ,

There are different factors that may cause that error. You may want to refer to this forum post:

-JolliBeng

[RuisiHansamu]

Hello, just want to update or share this forum post that is similar to this error. Specifically to 'Values cannot be submitted due to a data restriction' Feel free to read and this will surely help you be aware when configuring your Table, Relationships, Triggers, and DataPage. 
 

 

'

 

[dhudiburg]

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.

[Queso]

Hi! Just to add, if you already checked the obvious reasons (Triggered Action setup, Formula, and Table Relationships) but still getting the same error, the last option is to contact Caspio Support because the DataPage/Table may be corrupted.