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.

Find more posts tagged with

Hospitality

Project Management

Comments

Andrée Starå

Hi,

It's possible if your ok with using a 3rd party tool like for example Zapier. Is that ok?

Best,

Andrée

KHGMaintenance

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.

Andrée Starå

Hi,

Follow up!

How did it go? Did you solve it?

Best,

Andrée Starå - Workflow Consultant / Get Done

Kelsey Guinn

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.

Andrée Starå

Hi,

Do you have any specific questions or can I help you in any way?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting