How can I track inventory from orders that come through Formstack?
![RobinIGT](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
We are a tourism agency. We use Formstack to collect registration details from each traveler. We integrate the information into Smartsheet to track registration numbers (and other information) and to share the information with others easily. Sometimes we use a hotel with several different room types, but with limited numbers of each room type and we need to keep track of the inventory of each hotel room type quickly and easily.
So my questions are:
1. Is it possible to track inventory on the same Sheet that we use for integration from Formstack?
If not, 2. How do you suggest to keep track of the inventory once it's been integrated from Formstack?
Obviously, we'll have several of these integrated sheets active at the same time and each one is not connected to the other, so likewise the inventory tracking cannot be in one central location since each set of inventory is for a different travel group and a different client.
Appreciate any solutions you can provide.
Answers
-
Hello @RobinIGT ! This sounds like a super fun build! I have a few ideas, but I would need to see the information that is dumped into Smartsheet. Would you like to whiteboard together? I love doing this with people from the community. My calendar link is in my signature below. Feel free to throw an hour on my calendar and maybe we can come up with a few ways together, and then come back to report it to the community as a solution afterwards!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives