Crow Canyon Software Forum

Crow Canyon User Community ForumNITRO Studio: Forms DesignerAssociated Column Query Builder.

Please or Register to create posts and topics.

Associated Column Query Builder.

#1 · August 27, 2025, 5:24 pm

I have 3 lists.

Table 1: (Issues)

Issue: (Single line of Text)
_____________________

Table 2. (Issue Links) - A list that has numerous links for a single issue

Issue: Lookup (to Table 1 - Issues) - Issue)

__________________________

Table 3 (Staff Issues) - Staff assiigned to certain issues (I want to display all the issue links for that specific issue. using an assuciated column)

staff (Person)

Issue ((to Table 1 - Issues) - Issue)

________________________

I have a nitro form on table #3. with an associated Column and trying to use the query builder to query all the issues form table 2 where the issues are equal.

I have tried numerous itteraitions but cannot figure out the correct syntax.

$parsefieldvalue(%%([Issue|Issue]%%,Value,;)
%%$parsefieldvalue([Issue|Issue],Value,;)%%
%%$parsefieldvalue([Issue|Issue])%%

Thanks for any help with this.

Uploaded files:

#2 · September 1, 2025, 3:03 pm

Hi Archie,

Please set the condition value in the query for 'Issue' as %%[Issue|Issue]%% and check the results. Also please note that functions are not supported in query builder inside Associated item columns.

Uploaded files:

#3 · September 2, 2025, 9:49 am

I tried your syntax and it too does not bring anything back. I have attached 2 other attachements shoing you what the value is when use the three dots. When I do this i get the correct results. But it is not dynamic. Thank you for you help on this issue.

Uploaded files:

#4 · September 2, 2025, 12:45 pm

Hi Archie,

Could you please share screenshots of the column settings for all three issue columns in the three lists (Issues, Issue Links, and Staff Issues) so we can review them further?

#5 · September 2, 2025, 1:18 pm

I hope this is clear enough. Thanks

Uploaded files:

#6 · September 2, 2025, 5:24 pm

I ended up deleting all the lookup columns and then reestablished the associated column and now everthing is woking like it should. Not sure what had happened, but sorry for the waste of your time. Your solution that you recommeded worked correctly.

Thanks Again.