AnsweredAssumed Answered

Calculate column issue

Question asked by bharathi on Dec 14, 2015
Latest reply on Mar 16, 2017 by cazza162

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.

Outcomes