Data from web form not populating worksheet
We have a form on our website and when funding requests come in they submit the form and it usually populates the worksheet. We have received any requests so I submitted a form and it did not populate the 2018 Community Grants spreadsheet. I checked the routing and it is the same routing number on the form.
Comments
-
Hi Donna,
Have you checked so that the row isn't added to the bottom of the sheet instead?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
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.
-
Thank you Andree! I found the data populated beginning row 34.
Thank you,
Donna
-
Happy to help!
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.
-
Hi there,
I am having a similar issue, the form is saying that there has been 13 submissions, one of which was a test that I did. When I look at the submitted data there is only 11 entries. I have tried looking at the bottom of the sheet and they aren't there.
Does anybody have any suggestions on how I can recover this data?
-
Hi Katherine,
Have you looked at the Activity Log on the sheet? Can you find it there?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Hi Andrée,
Similar issue reported to me on 3/4/21. A user entered 9 records, during entry they received the successful completion screen. They also request an email of their submission, in this case they only received 6 confirmations. I have checked the log files and was able to find 6 of the 9 entries for the timeframe they were entering the forms.
-
Hello, I am having the same issue where my form states that I have 15 submissions, however; I only see three on the sheet. I scrolled to the bottom and I do not see any submissions. Any advice on what is happening?
-
Hi @Joy Griffin
I hope you're well and safe!
Have you looked in the Activity Log for clues?
Any filters activated?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
Hi Andree,
I hope all is well! Yes I have tried everything and I still only see three submissions. Do you think its because I have two forms on one sheet?
-
Yes, I'm well! Thanks for asking!
No, the number of forms doesn't affect anything. I have client solution with many more forms.
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives