Retrieve Specific Virtual ID From Report Based on Column Name

The Get Report module in Bridge does not allow us to specify a column the way the Get Sheet module does. How can I use the column name to pull the virtual ID for that column?
In the last screenshot containing the runtime data, I need to be able to reference the title to pull the virtual ID for a specific column.
Best Answer
-
I ended up solving this by first extracting the column names into one array, extracting the IDs into another array, and then using a JS module to find the index of the name array based on the column name and then output that same index from the second array.
ChatGPT gave me the JS, and it worked like a charm once I mapped my three variables.:
// INPUTS: referenceColumnName, arrayOfColumnNames, arrayOfColumnIDs // Find the index of the Reference Column Name in the Array of Column Names const index = arrayOfColumnNames. indexOf (referenceColumnName); // Initialize the output variable let output = null ; // Check if the index is valid if (index !== - 1 ) { // Get the corresponding Column ID from the Array of Column IDs output = arrayOfColumnIDs[index];} // OUTPUT: output (Column ID corresponding to the Reference Column Name) return output;
Answers
-
I ended up solving this by first extracting the column names into one array, extracting the IDs into another array, and then using a JS module to find the index of the name array based on the column name and then output that same index from the second array.
ChatGPT gave me the JS, and it worked like a charm once I mapped my three variables.:
// INPUTS: referenceColumnName, arrayOfColumnNames, arrayOfColumnIDs // Find the index of the Reference Column Name in the Array of Column Names const index = arrayOfColumnNames. indexOf (referenceColumnName); // Initialize the output variable let output = null ; // Check if the index is valid if (index !== - 1 ) { // Get the corresponding Column ID from the Array of Column IDs output = arrayOfColumnIDs[index];} // OUTPUT: output (Column ID corresponding to the Reference Column Name) return output;
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives