Query String - How to send text with spaces ?

Dear Community,

I am quiet new to Smartsheet and would really appreciate your help. I am trying to insert query string into formula and face an issue: Only text before first space symbol is actually sent to the form. Please, see a screenshot below:

So, when I open a form via this link in Title field I see only TestIdea2 value.

Any idea how do I get the whole expression like "TestIdea2 1 111" ?

Thank you!

Find more posts tagged with

Accepted answers

Sameer Karkhanis

You will need to substitute each space with %20 so when you are adding the Primary Column value use,

=SUBSTITUTE([Primary Column]@row, " ", "%20")

All comments

Sameer Karkhanis

You will need to substitute each space with %20 so when you are adding the Primary Column value use,

=SUBSTITUTE([Primary Column]@row, " ", "%20")

austinov

Sameer, thank you very much - it helped!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.