Crow Canyon Software Forum
Associated Column Query Builder.
Quote from skigeek on August 27, 2025, 5:24 pmI 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.
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: