Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Adding auto-numbered field to web form??
Comments
-
Here is a possible fix. It's not the greatest but it could work.
Add a column titled Request Number (or however you want to name it) with the value of 1 in the first row. Then in the second row enter the formula =[request number]2=1 and copy it down the rows.
Then in the webform bring that column over to the webform and insert help text asking the person submitting the form to leave this field blank.
When they receive their confirmation email the request number will prepopulate in that field giving them their request number.
-
Another option is to use Zapier which can email users a confirmation email containing the data from the web form, including the auto number from the sheet.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives