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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives