Skip to main content
Nintex Community Menu Bar

Calculate column issue

  • December 15, 2015
  • 3 replies
  • 9 views
Forum|alt.badge.img+6

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.

    3 replies

    Dan_Stoll
    Nintex Employee
    Forum|alt.badge.img+12
    • Dan_StollNintex Employee
    • Nintex Employee
    • December 15, 2015

    Hey Bharathi S​,

    what happens if you use

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

    https://www.linkedin.com/in/stolldan
    Dan_Stoll
    Nintex Employee
    Forum|alt.badge.img+12
    • Dan_StollNintex Employee
    • Nintex Employee
    • December 15, 2015

    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'

    https://www.linkedin.com/in/stolldan
    Forum|alt.badge.img+16

    Bharathi S‌ did you ever resolve this?

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement