I have a list in site collection level,which consist of firm name and city. now i created a content type, in which i created a lookup column which lookup's for the value of the firm name. i created a nintex form out of the content type, then i created a calculated a column inside the nintex form using the runtime lookup function, such that when one selects the firm name from the drop down the city pop's up automatically, here my syntax =lookup("mylistname","ID", controlname, "city").
My list name= it is created at the site collection level
we have created a sub site and have associated this content type to a list , such that when one creates a new item the nintex form created of the content type shows Up.
This formula works in preview mode, but when we publish it does not work.
Please any can help me.!!!
Thanks in advance.
if it works in preview mode it should work productive as well.
I do not have experience with your specific hierarchy, but what I would check:
- there are no errors reported on developer console
- if you check it view/display mode you have 'recalculate in view mode' turned on
- calculate value control is not disabled
- you have correctly set permission to read list on site collection level and/or its items
I also figured out that the list lookup does not quite work on the mobile side if filtering on single line of text field, while filtering from a choice works perfectly? I really appreciate your comments.
I do not have such experience.
but it might be sensitive if you do not exactly type in a value you make a filter by.
as well mobile on-screen keyboards use to append a space once they recognize likely to be end of a word. and that of course breaks filter.