Pre-populate user form
Hello,
I have created a single service form to streamline the process of following up with the service team to obtain updates and status information. Instead of creating a new form for each project claim, my goal is to have this one form automatically populate the following fields based on the corresponding row/project details:
- Project ID
- Claim ID
- Site Name
- Claim Description
Although the current formula allows me to open the form, it does not automatically populate these fields with the relevant data from each cell. Could you please help me understand what I might be missing or what needs to be changed in order to achieve this functionality?
Current Formula:
Best Answer
-
Hello all! 🌟 Pre-populate user form (SOLVED)
Just yesterday, I posted a question here in the community, seeking help for an issue I was facing. Sadly, I didn't receive any responses, but that didn't dampen my determination! I kept searching for a solution, and I'm happy to report that I've figured it out! 🎉 I wanted to share my findings with you all, in case anyone else encounters the same problem.
So, here's the situation: I was using a query link to open a form, but the fields I expected to be pre-populated with data from the source sheet were empty. I decided to dig deeper and experiment until I found the answer! 🕵️♀️
The trick turned out to be adding a space between each string in the formula. Take a look at this example:
="Form URL?Project%20ID=" + SUBSTITUTE([Project ID]@row, " ", "%20")
Do you see the spaces before and after the + sign? That's the key! Make sure to add spaces like that for each cell you're trying to prepopulate. 🤓
To be honest, I still don't fully understand why this works, but it does! I hope this little discovery can help some of you avoid the same headaches I experienced. And remember, persistence pays off—sometimes you find the solution sooner than you think! 💪
Answers
-
Hello all! 🌟 Pre-populate user form (SOLVED)
Just yesterday, I posted a question here in the community, seeking help for an issue I was facing. Sadly, I didn't receive any responses, but that didn't dampen my determination! I kept searching for a solution, and I'm happy to report that I've figured it out! 🎉 I wanted to share my findings with you all, in case anyone else encounters the same problem.
So, here's the situation: I was using a query link to open a form, but the fields I expected to be pre-populated with data from the source sheet were empty. I decided to dig deeper and experiment until I found the answer! 🕵️♀️
The trick turned out to be adding a space between each string in the formula. Take a look at this example:
="Form URL?Project%20ID=" + SUBSTITUTE([Project ID]@row, " ", "%20")
Do you see the spaces before and after the + sign? That's the key! Make sure to add spaces like that for each cell you're trying to prepopulate. 🤓
To be honest, I still don't fully understand why this works, but it does! I hope this little discovery can help some of you avoid the same headaches I experienced. And remember, persistence pays off—sometimes you find the solution sooner than you think! 💪
-
Hi LeAndre
Thanks for the solution! I wish Smartsheet would leverage this ingenuity and enhance forms to allow updates (I have extensive text in my use case, which eliminates other out of the box solutions).
Leveraging your solution, I am finding a new row is getting created with every submission though. Is that the same result you are seeing? If that's the best it can do, then a workflow to move the redundant row elsewhere would be needed most likely.
="https://app.smartsheet.com/b/form/123456T9876R54?Entity%20Name=" + SUBSTITUTE([Entity Name]@row, " ", "%20")
-
@Glen Coates That is the expected behavior. Every form entry is it's own row. If you want it to update a row, you will need to use either Update Requests, or there is an option to have it populate on a different sheet and then use formulas and unique identifiers to pull that data back over into the main sheet on a consolidated row.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives