AnsweredAssumed Answered

Nintex Forms How can I trim/replace/extract characters from string

Question asked by brettando on Jan 30, 2018
Latest reply on Jan 31, 2018 by brettando

Using Nintex Forms, from a sub-site, when a person opens a link to a new form located in the top-level site, the source= url string is copied into a field using the formula: fn-GetQueryString(Source)

This pastes the url string when the form is loaded as: http://SpServer.com/sites/Programs/1/Pages/default.aspx   (So depending on which sub-site, 1, 2, 3 etc is the sub-site).

So what I now need is to display the corresponding Sub-Site Name in a field. I have tried common:Site Name but this displays the top-level Site Name, which is no good.

I have another list that was used to create the sub-site using the Create Site Workflow and that has the corresponding Site Name, so I can use a lookup if I can get the 1, 2, 3 etc from the source string url.

The URL path after the 1, will be dynamic, so it could be /1/Pages/Lessons.aspx, /3/Pages/Risks.aspx etc.

Is there a way perhaps using Trim or Replace, that I can extract the sub-site 1, 2, 3 etc at runtime?

 

Ask if anything is unclear.

Thanks.

Outcomes