Pipeline Help - Aggragating Date Fields by Month
I need assistance with setting up a pipeline in my Quickbase app to aggregate data by month. This will be the first time I've used pipelines. The tables involved are called: APP Credentialing Table: This table contains the raw data I need to aggregate. Namely, 3 date fields. APP Date Summary Table: This table is where I want to update the aggregated counts. It has 2 fields. Month/Year (text) and Count (Numeric). Specifically, I need to: Retrieve and filter records from the APP Credentialing Table. Group these records by Month/Year and count them. Update the APP Date Summary Table with the aggregated monthly counts. Could you please provide guidance on how to configure the pipeline to perform these tasks? If this even can work. Thank you!
Working with JSON Array in Pipelines
I have a pipeline where I send a webhook "Get" request to an endpoint and it responds with an array of JSON records. My question is how do I iterate through those records? For example, the array contains two values: ID and Name. As the next step in the pipeline I want to search my table to see if the ID already exists and if it does not create a new record.Issue using AI Smart Builder for Pipelines
I am trying to use the AI Smart Builder to build a pipeline. I tried a very simple request to start off but the builder just seems to hang there in the "Initializing" state forever. The text I entered to seed the AI builder was: "when a new record is added to the Change Mangement Attachments table in the <abcdefg> app, send an email to the person that created the record." Here is where it stalls. Any suggestions?
Pipeline to run a URL formula field button
Hi, I have a URL formula field button which runs some other automation functions. This works fine when manually pressed. I have no issues with the scheduling part. I'm sure its something simple, but what I can't figure out is what I need to do in the Pipeline to simulate "Pressing the button"? Thanks.
Change log pipeline
I want to write a pipeline which can tell what field is modified in a table.who modified it and when . Below is table structure I am using. Table name,field name,modified by,modified date,action done(replace,add,delete). I am using quickbase action but it can't tell which field is modified . All other videos and link requires that modified field name should be known beforehand if using pipeline. I also don't see any option in pipeline where we can get field name . Can anyone please help.
