Forum Discussion
Thanks, Mark!
Here's how I actually solved it...
I created a Formula URL as follows
"https://etagen.quickbase.com/nav/app/[APP ID]/table/[TABLE B ID]/action/q?qid=20&query=" &
"{85.EX." &
SearchAndReplace(ToText([Concatenated MatchID]),
" ; ",
"}OR{85.EX.") &
"})"
Basically, it took my list of ID, converted it to text (which automatically separates values with semi-colons), searched and replaced the semi-colons with the central part of a query. This produces a URL with query terms like {85.EX.189-261}, which means field ID 85 (that's where the MatchID field is in Table B) to one of the values in the Table A list (that's what all the ORs are about).
Unfortunately, the user has to click the link to see the table. While API_GenResultsTable can normally generate the table directly in a webpage, QB's rich text fields don't allow JavaScript, so that didn't work. No big deal.
- MarkShnier__You7 days ago
Qrew Legend
Well that's thinking way outside the box
Thx for posting.