URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form.
I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL is passed into the form fields. The completed form adds a row to the newly created info sheet.
When it was working as desired, I saved the workspace as new to be my production space.
In principal, everything (forms, formulas, links, etc) in the newly created Production space is supposed to point to (and receive from...) the items in the Production space, which is true EXCEPT for the form URL query string. I can see the URL and the query string in the production data base. However, when I click it, it still pulls the form from the test sheet, pulls data from the test sheet and loads the new rows to the test sheet.
When I open at the query string it looks like the correct fields in the production sheet are highlighted but when I click the URL, the data in the form is not correct and the info I put in the form is submitted to the wrong sheet.
Can any one help troubleshoot, please?
Here is relevant help page from the Solution Center : https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values
Thanks
Answers
-
You'll have to update the Query String part with the sheet's address to the new one for it to work.
Make sense?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Hi @Carroll Wall,
As @Andrée Starå noted, in order to update the query string to collect data for the correct sheet you'll need to manually update the string on the new form URL rather than use the same URL and string from the initial sheet. I highly recommend Submitting a Product Enhancement Request to see about having query strings copy and update automatically when using the "Save as New" feature, as I can definitely see the benefit to having this capability.
Thanks,
Ben
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!