Recurring form submission error
We continue to see this error in forms connected to a specific sheet, even when all inputs are given, required or not:
The information you entered is incomplete or invalid.
We have 4 identical forms, except one value in a hidden field. The error has occurred in several of the forms since we created them six months ago. They are each a duplicate of the same "template" form.
Once the error occurs on a form, it persists until "fixed". No one can submit new entries via the form, external users or users in our account. It just appears "broken".
The only "fix" we have found is to delete and recreate the faulty form from the template. Sometimes the error occurs from the first submission attempt, and we recreate again.
The sheet has another 2 forms, on which the error has never occurred. These are not created with the same template form.
Are we missing something obvious, or has anyone seen anything similar? I am happy to expand on any details left out 🙂
Form characteristics
- The form has two hidden fields with default values. One is a Text/Number column, the other a Dropdown (Single Select) column.
- There is no form logic.
Sheet characteristics
- 55 columns
- 6,500 rows
- 8 automations: 7 notifications, 1 "Copy a row"
- 6 active forms, two in addition to the four problematic ones
Best Answer
-
I hope you're well and safe!
I am answering here as well. (duplicate post)
Happy to help!
I've figured it out.
You had a Validation set on the hidden field for the Supplier. Once I removed it, it worked.
Did that work in the original one as well?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Nevermind. It looks like you posted this problem in duplicate and already received an answer on another thread.
-
I hope you're well and safe!
I am answering here as well. (duplicate post)
Happy to help!
I've figured it out.
You had a Validation set on the hidden field for the Supplier. Once I removed it, it worked.
Did that work in the original one as well?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Ah. There was an error when I posted the first time. The post was nowhere to be found, so I rewrote everything. Looks like it reappeared overnight.
-
I got the same problems many times, most of the time it is caused by form validations (Email, phone etc). I select "No validation" and the error is gone. Hidden fields may also have validations that may lead to this error.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives