Skip to main content

Hi,

     I have a calculated column with the below formula

If(Is New Mode,lookup("List","Id",fn-GetQueryString("Id"),"Title"), Child Title)

In the new mode, it fetches value from the Parent list and for other modes it fetches value from the child list "Child Title" column value.

in all scenarios works fine, but in one scenario it is failing. When the "Child Title" contains values with the single quote it is failing.

eg: Child Title column value is Bharathi's Demo. Works fine if value is Bharathis Demo

Please provide your help on this.

Hey Bharathi S​,

what happens if you use

If(Is New Mode,lookup("List","Id",fn-GetQueryString("Id"),"Title"), "Child Title")

The issue most probably is the ' in the text.. Another option if the above doesn't work, would be to create a form variable and use the replace() runtime function to replace the ' with /' so something like

replace("Child Title","'","/'")

then use the variable in your query inside the form instead of 'Child Title'

Bharathi S‌ did you ever resolve this?

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings