AaronAlpert1
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Pipeline triggering on Google Sheet Row Created - header row?
Hello! I have a Google Sheet. I want that when somebody adds a row to this Google Sheet, the Pipeline triggers a search of records in a QB table, matching values in the QB table to the value entered in the new GSheet row. Anyway, I'm having a bit of trouble getting the Pipeline to connect. I entered the spreadsheet and sheet IDs (which will be static) in the first two fields. Not sure what to put under Header row. My first row has A1: "Timestamp" and B1: "Email" and that's it so far. That's my header row, so what goes in the Pipeline step? When I put 1 (as shown in the image above), I get a message, "Internal error. Please contact support to investigate." Why can't Pipelines access the spreadsheet? I know my Google account has permissions (I created the spreadsheet). ------------------------------ Aaron Alpert ------------------------------Using RESTful API to add a user to a role in an app
I'm writing a Python script and would like to add a user to a particular role in one of my apps. She is already provisioned in my company's realm, and I have her user ID number. I see that API_AddUserToRole exists and is well-documented, but I want to use RESTful APIs rather than XML. I see that there is a RESTful API for adding a user to a group, so I have to imagine there is something similar to add a user to a role in an app, but I can't find it. Any suggestions? In particular, I'd need the correct URL to POST to. ------------------------------ Aaron Alpert Reliability Engineer, Mainspring Energy ------------------------------Pipeline doesn't trigger when event happens
I have a Pipeline that is supposed to trigger when a record is created in the Instances table of my Inspection Gadget app. See below for a photo in GUI and YAML export snippet. Anyway, the Pipeline last worked on Monday, and has not been changed or updated since then. Today, when I try to create a new Instance, the Pipeline doesn't trigger. In the live Activity Log, it just gives me an infinite spinning wheel while "Waiting for a Record Created event in Quickbase…" Any ideas why it's not picking up the trigger? - TRIGGER quickbase[qDOL53p] record on_create -> a: inputs-meta: export_fields: 32, 33, 35, 36, 34, 22, 49, 21, 19, 52, 50, 53, 51, 12, 55, 56, 54, 57, 58, 59, 60, 61, 62, 65, 66, 64, 63 table: brckh5whk - a<>ACTION quickbase record update -> b: inputs: [redacted] ------------------------------ Aaron Alpert ------------------------------Pipeline - which field caused the trigger?
Right now, I have a table, call it "Issues." There is a Pipeline that is triggered when any field is updated in an Issues record; this creates a new record in the "Edits" table, and Last Modified By and Date Modified are written to this new "Edit" record. What I want to do is find out which field (or fields) caused the Pipeline to trigger. For example, in the "Issue" record, did the user change the value in the Status field or the Next Step field? Or both? I know I can use $prev to access the value before the edit (and ultimately I want to store this in the Edit record). Is there a way to access the name or fid of the field(s) that changed and triggered the pipeline? ------------------------------ Aaron Alpert ------------------------------Include a report table in a notification email
Hi! I have created a notification that sends an email any time a record is added to a table called "instance." I want to include a report with this email. I've been able to include a link to this report, by adding the following HTML snippet in my custom email message: <a href="https://myCompany.quickbase.com/db/brckkkkkk?a=q&qid=5&nv=1&v0=[Related Subsystem]">Click here</a> Side note: The [Related Subsystem] marker makes sure this report filters records that share the same parent record in the Subsystem table. But what I really want to do is show this report, in the format of a table, in the notification email body itself. I tried using <iframe> to embed the webpage with the report into the email, but that didn't work. Just to be clear, I do not want to create a subscription -- the email needs to get sent when the trigger happens (new record created), not on a daily or weekly schedule. I would appreciate any advice, thank you! ------------------------------ Aaron Alpert ------------------------------
