Form Entries are Negative

Weekly I have about 15 sites completing the form linked below. The issue, I have roughly two random users each week entering a negative one into the form. One user who is pretty savvy indicated the form is defaulting to a negative one. https://app.smartsheet.com/b/form/ebc99e53148a4a479060b3d695321030

I have NOT setup any logic in the form. I have applied a number validation to the student and staff questions but the default value was left blank. Yet, I'm not sure how a field can default to a negative one.

Within the form, I do not see how to prevent a user from entering a negative number.

My next thought was, I should setup automation to request an update from the person who submitted the entry if the number is less than zero.

Has anyone encountered this? Does anyone have another idea?

Thanks in advance 🙌

Find more posts tagged with

Forms

Sheets

Automations

Update Requests

Accepted answers

All comments

MVP OPS

Hi @Amy Arnold

You could make the column a dropdown. Put your numbers in excel or google sheet, and copy and paste into your column.

Amy Arnold

@MVP OPS thanks for the reply and good thought.

The data entered into the form are random numbers from 0 to 500 plus. I cannot predict the responses so a dropdown probably wouldn't work.

Andrée Starå

Hi @Amy Arnold

I hope you're well and safe!

To add to MVP's excellent advice/answer.

As a workaround, you could add a Workflow combined with an automated update request that would trigger if there's, for example, a negative answer so they can update it to the correct value(s).

Would that work/help?

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 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!

Chris K

We just ran into this issue as well. Occasionally, when 0 is entered on the form it puts a random negative number in the cell. We created a conditional format to highlight the row when a negative number is entered and added a workflow automation to alert us to the negative number.

Genevieve P.

Hi all!

Jumping in here to let you know that Forms have received a number of small updates this week; the issue you're describing where numbers are being entered as negative is linked to form input fields with number validation having tiny scroll arrows in the input field. When using a mouse wheel to scroll through the form, the number changes while the mouse is over the number field.

This has now been updated - scroll has been removed from number validation fields! Here's more information: NEW! Forms minor updates and enhancements

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.