Home > Forum > Rules, JS, SQL > Error "Incorrect sequence of form fields"

Error "Incorrect sequence of form fields"
0

MVP

Hi Marcin.

I think I had a similar error message and I had to manually modify the data in the database.

The order of the form fields in the placeholders ist stored in the table WFStepFormFields. In my case two fields shared the same value for FLD_Order. I changed the value and for "safety" measures I reset the cache and recycle the application pool, closed the designer studio everything worked fine again.

Below you find a starting point for listing all form fields. You will need to use the id of the field for FLD_WFCON to identify the FLD_FRMIDs and than look at the result.

Best regards,
Daniel

SELECT TOP (1000) [FLD_ID]
,[FLD_FRMID]
,[FLD_WFCON]
,[FLD_PlaceHolder]
,[FLD_Order]
,[FLD_IsVisible]
,[FLD_IsDeleted]
FROM .[WFStepFormFields]

order by [FLD_FRMID],FLD_PlaceHolder, FLD_Order