URL Query string did not move with "Save as New" How to remedy?

Carroll Wall

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

Andrée Starå

Hi @Carroll Wall

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!

Ben Goldblatt

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