ContributionsMost RecentMost LikesSolutionsRe: Toggle Checkbox for Whole TableHi @Mark Shnier (YQC), Thank you for the quick reply! I hadn't thought of saved imports. I was able to import the table to itself, and map a new formula checkbox field (=False) to the target Exists field I want to flip. Awesome advice. My only issue now is controlling how it executes. In Automations/Scheduled, I can only select "Daily." But when will it run? I need to know so I can schedule my import only after this runs. Can Pipelines help here? Thanks again for your thoughts. ------------------------------ Chris Dyroff ------------------------------ Toggle Checkbox for Whole TableHi All, What's the best way to set a value on every record in a table? Best solution would be something I could call with the API, OK solution would be something scheduled, unacceptable is anything manual. Workflow/Use Case Flip all records in the table to Exists=False (Exists is a checkbox field) Load (POST to /records endpoint) my data from an external system, each record has Exists=True Now any records which weren't in the last load are still marked Exists=False Profit. Or at least have an accurate representation of the current state of the other system. Thanks, CD ------------------------------ Chris Dyroff ------------------------------ New RESTful API in Code Pages?Hi, QB Folks! Anyone know if you can use the new API inside your Code Pages? I'm getting a CORS error when I try. I need to combine a few existing QB reports into a single table for reporting, and thought the new API's "reports" endpoint would work well. I'm hoping to use JS to fetch the data and generate a table. But when I try to pull the data into the page directly, using the JQuery code samples from the API Portal, I get a CORS error. <head> <script> var headers = { 'QB-Realm-Hostname': 'xxxxx', 'User-Agent': 'API-Explorer', 'Authorization': 'QB-USER-TOKEN xxxxxxxxxxxxxxxxxxxxxxxx', 'Content-Type': 'application/json' }; $.ajax({ url: 'https://api.quickbase.com/v1/reports/10/run?tableId=xxxxxxxxx&skip={skip}&top=10', method: 'POST', headers: headers, success: function(result) { console.log(JSON.stringify(result)); } }) </script> </head> <body> <h2>Table will go here.</h2> <table></table> </body> When the page loads, in the console: Access to XMLHttpRequest at 'https://api.quickbase.com/v1/reports/10/run?tableId=xxxxxxxxx&skip={skip}&top=10' from origin 'null' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. I'm hoping there is a workaround that I'm just missing. Any help is appreciated. Thanks, CD ------------------------------ Chris Dyroff ------------------------------