-
HELP - Enabling CAPTCHA on a Form
I have a business critical form that's getting spoofed (500+ entries in ~3hrs) and am trying to enable CAPTCHA but I can't seem to get it on the form. Here's what I've done using Edge and Firefox: Edit form > Form Options > Checked 'Enable challenge/response for additional security'
-
Web form not refreshing into sheet
I created a worksheet to track issues. I then created a Webform to gather this data from end users. I ran a test entry. I received email with URL to webform. I entered the data and submitted. I received a confirmation message and email. A notice appeared on the worksheet that an entry was made. I click refresh and the…
-
Enhancement Request: Improvements for Contact List columns in Forms
When adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down. However, the drop down acts as if the "Restrict values to list only" check box is checked, whether it…
-
using a form to input new data means my formula no longer works.
hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet. Please can someone…
-
How do I reset a webforms entry count?
I built a new webform and during testing I generated a few test rows into the underlying spreadsheet. I am able to delete these test rows but how do I reset the entry count that appears when the form is opened from the sheet. Setting it back to zero would be ok. Thanks for any guidance that you can provide.
-
VLOOKUP from Form Input
Hey guys, I've been unable to find a solution for this one. I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input. When I reference another sheet as a lookup_table, I select the whole sheet in which the FORM data input ends up, the new line is never included…
-
Automation from a form submission
Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…
-
Question on showing text (comments) from cells in dashboard
Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type in comments about the material. Is there a way (possibly through a report?) to have a widget that shows comments people…
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
