Have Us: Call You Back

Call Us: UK: +44 1937 541 553

Email Us: info@smarterbusinessprocesses.com

Other Options: Contact Us

Smarter training adjusted to suit your real needs

At Smarter Business Processes we offer a wide variety of Smartsheet training courses and packages.

Learn More

Our team of certified consultants provides training and remote support to clients around the globe, improving their Project Management, Workflow and Process Management.

Smarter Business Processes is Cyber Certified

Emma Stevens

Office Manager

Emma has 27 years of financial and customer experience and brings processes and order to our office.

Emma's customer service knowledge ensures all of our clients office enquiries are dealt with professionally, efficiently and quickly. She will leave no stone unturned to get to the bottom of a query!

When not at her desk Emma enjoys spending time with her husband and daughter as well running Brownies and Rainbows for Girlguiding UK in her local area.

Etienne Mermillod

Software Development Manager

Etienne is a seasoned ASP.NET Core Full Stack Developer. He takes great pride in building world-class applications while carefully considering the needs of its users and ease of use.

Originally from France, Etienne now calls Canada Home, where he is part of SBP Canada as a member of the API Solutions Development Team.

Etienne is a well-seasoned traveler and has visited many countries where he usually takes the path less traveled in order to backpack around and soak in the local cultures.

When not coding away, you may expect Etienne to be playing with his huge and fluffy dog Indianna or gaming away on League of Legends

David Bower

Smartsheet, Airtable and AppSheet Consultant

David is a hugely experienced Consultant, Customer Care Specialist and Client Account Manager.

In his spare time, David plays guitar, is learning to ride a motorcycle and, when it’s not too cold, can often be found tinkering in the garage. He also intends to learn to play the piano too - one day

Debbie Sawyer

Chief Smartsheet Solutions Officer (CSSO)

BSc (Hons) Computing, ITIL Foundation, Smartsheet Certified User, Aligned Sales Certified and Professional Services Certified.

Seasoned Smartsheet consultant and Training professional, Debbie’s creativity, attention to detail, willingness to deliver solutions to fully meet customer requirements and her personable manner earn her excellent client feedback.

When not working, Debbie likes to relax by spending quality time with her family. Living in the New Forest sees her taking many walks through the woods and down to the sea fronts at Lepe and Calshot. Debbie is also a keen hula hooper and has been hooping now for more than 7 years! She owns at least 10 hoops and enjoys a great workout helping her friend to run a hula hoop fitness class.

Dr James Harris

Chief Technology Officer

An experienced IT professional, James' prior work spans diverse environments from the white heat of launching information systems in one of the world's busiest airports, to industry leading tech startups. He also has extensive experience as a Finance Manager. James brings a keen insight and and flair for problem solving to every project.

Outside of work, James writes comedy, and has had many television credits over the past couple of decades on shows such as Horrible Histories and Russell Howard's Good News. He retains a burning ambition to be as funny as his wife and daughter.

Ph.D. Biochemical Physics, IT and Accounting professional.

Gwen Rymill

Communications Director

Co-founder of Smarter Business Processes, Gwen’s multi tasking roles include ensuring our clients receive the very best in customer care, while responsible for sales and marketing and partner liaison. Just don’t expect to get the cup of tea she promised you!

Away from work Gwen enjoys cycling, pilates, tap dancing and just loves baking.

Richard Rymill

CEO

Co-Founder and Lead Consultant, Richard set up SBP in response to worldwide demand from businesses wanting to implement their own Smarter Business Processes. His rapidly expanding team of experienced Smartsheet and AppSheet Consultants and Trainers share the company's values of achieving improved efficiencies and collaboration by putting people first and releasing them from unnecessary repetitive activities so they can enjoy their work again and focus on what matters to them.

When not at his desk, Richard can be found cycling, swimming and when the opportunity permits, sailing and flying.

URL Query String in Smartsheet

Looking to save time when filling forms in Smartsheet? Using a URL Query String in Smartsheet lets you prefill different default values for the same form.

It also lets you customize form links with query strings for instance in email shots to provide different default values for each recipient.

Case Example

Suppose you are managing a team logging support calls. You can provide everyone in your team with a link to the same form that prepopulates their individual name and department.

Simply create one base form, and then give each team member a different URL with parameters unique to them, providing them with a query string that prefills their name, department, and whatever other unique information you need them to provide. Each team member can easily log each support call with all the relevant information prefilled on the form.

How to Build a Query String to form a URL

To build the query string for a form URL:

  • In the menu bar, select Forms > Manage Forms.
  • Hover over the form you want to distribute with custom URLs.
  • Select Copy Form URL.
  • In a spreadsheet or any word processing application, paste the URL.
  • At the end of the URL, type a question mark (?) For example:

app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?

  • Type the value for the form field that you’d like to populate. For example:

app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?First-Name

  • Type an equal sign (=)
  • Type the value you want to set as the default. For example:

app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?First-Name=John

  • To include multiple fields in the URL, join them with an ampersand (&).  For example:

app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?First-Name=John&Last-Name=Smith

The image below shows what the form will look like with all requested values filled in.

URL Query String automatically loaded to a Smart Form in Smartsheet

Tips To Remember

A prefilled query string won’t work if users have to log in to access the form. Authentication clears any customization from the URL.

If your team needs to submit the same data again, they can use the browser’s back button to reload the form with the last submitted values, including prefilled values. Then, they can overwrite anything they need to change and resubmit the form.

In your form settings, remember to select ‘Allow submitter to email a copy of form submission option.’ Once this is set up, you can use query strings to automatically enter a default email address.

Want to know more?

To stay up to date with our tips and tricks, blogs, latest products and all the latest from Smartsheet.

Subscribe to our mailing list to stay up to date.

Read more about our Smarter Forms tool here, and watch our webinar on creating webforms in Smartsheet below.

Tags

Related Posts