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.
Using Web Form to Update different sheets
I am using Smart Sheets as a work order tracking tool for multiple properties. I would like to use one standard web form with either a drop down list or check box of properties. When a user selects the property they need service, the sheet attached to the property would be updated. One web form with direction to update multiple sheets based on property location. Can this be done natively using smart sheets or via VB code or Macro.
Comments
-
Hi,
It's possible if your ok with using a 3rd party tool like for example Zapier. Is that ok?
Best,
Andrée
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.
-
I have checked out Zapier. So far seems like a solid tool. I have decided to use Wufoo as the base form then build the form with Locations (Property 1, Property 2, etc...) i have built the test forms, connected smartsheets and Wufoo via Zapier. I am still trying to get the form to update a sheet via location. There should be a way to put in a statement such as "IF" Wufoo form location is Property 1 and Smart Sheet Name "EQUALS" Property 1, "THEN" populate data to top row of SmartSheets Property 1.
Any help would be greatly appreciated.
-
Hi,
Follow up!
How did it go? Did you solve it?
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.
-
very interested in the final outcome of this... Just starting to transfer our data to smartsheet, we do community association management and this info is very helpful.
-
Hi,
Do you have any specific questions or can I help you in any way?
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives