This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I want to make sure I'm not missing something. I have an automation that copies some data columns from one table to another, when a button is clicked on an interface. It does this for batches of data, and I have a checkbox to mark when the automation...
Is it possible to identify if there are any duplicates in a lookup array? I have 3 tables, all linked together: Entities (companies)MeetingsMonthsEvery Meeting is linked to a month (for various uses) and to an Entity. From the Entities table, I have ...
I have a list of schools and I'm trying to track demographics I have about the schools:raceincome levelsgendersI have reports with the aggregate data, not the individual student records. Therefore I'm not able to do rollups but tracking each demograp...
I'm fairly new to JS and I'd love feedback if this script is the most effective. I'm trying to link records between tables, and I know it's not a simple copy-paste.I have two tables: enrollments (students) and courses.Enrollments has the fields:Cours...
I have a script to import a CSV from a URL. The URL is provided by an API JSON file. let csvFile = await remoteFetchAsync(reportData.attachment.url) At this line, I get the error:j: Error: Response status was 302 'Found' but redirect mode was set to ...
This is perfect - I simplified this even more. I created 2 automations. Instead of using a checkbox, I made it a single select with 3 options:Automation not runRun automationAutomation completeThe first automation is linked to the button, and changes...
FYI, you have to modify the ARRAYUNIQUE rollup to match your separatorARRAYJOIN(ARRAYUNIQUE(values), ", ")Even though visually this looks the same without the ARRAYJOIN, there seems to be some distinction where you can't compare it using an = formula...
This is interesting. So if I'm understanding, this will compare the Length of both the ARRAYJOIN and ARRAYUNIQUE array and tell me if there's a difference.Would I be able to tell which linked records are the duplicates? Not just a True/False if there...
Wow thanks for circling back on this. I haven't explored the New dashboard page, so this is very interesting.One downside I see with New dashboards is it only allows you to link to 1 table. I have dashboards that pull aggregates from several tables. ...
I figured this out. You have to use a headers.get and specify the Key from the response, like this: let request = await remoteFetchAsync("https://XXXX?per_page=100", requestOptions);
let responseLink = request.headers.get('Link');
console.log(respon...
