Forum Discussion
Passing URL variable doesn't work when exporting to excel
Hello,
I have created a Forms Pro survey that contains two questions: SessionID, and Name. In addition, I have initialized a variable called SessionID.
I am passing a variable in the URL for the Session ID which is the following:
https://forms.office.com/formspro/Pages/ResponsePage.aspx?id=FORMID&ctx={"SessionID":"Social Media"}
The problem is the following:
- When I submit my response using the above URL and I export to excel the responses, unfortunately, the SessionID column remains blank knowing that it's already passed in the URL. But it seems that the SessionID doesn't get populated when the URL is loaded.
My requirement is just to capture the session ID along with other questions and download the excel report.
Please have a look at the below screenshots:
Any idea why this problem occurs?
Can please someone explain in detail and provides an example to achieve the above scenario?
Any help will be greatly appreciated.
Thank you!
- bullsbCopper Contributor
Julien_Anid - this feature is not available in Forms and is available in Forms Pro. You can get the variables passed in the URL and save it.
- Julien_AnidCopper Contributor
Hello bullsb ,
I am already using Forms pro and I have created my survey using Forms pro but unfortunately, the same problem occurs.
Please have a look at the below screenshot:
(PS: I am using SessionType as a variable. In the first post, it was SessionID)
Looking forward to your response.
Thank you!- bullsbCopper Contributor
Julien_Anid It should be a hidden field, I see its visible for the user to enter. Please check the youtube post by Megan.
https://www.youtube.com/watch?v=7RPMGjaP1EU&list=PLD9xXqUZnFj8eYWTN_aULBE47qslRM7et
Hope it meets your requirement.