JohnErdmann
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: "Median" field using the new Query Formula Fields
rvalenzTo ensure order I recommend breaking the solution into 2 formula queries. 1) A rank order query can be constructed with something like this in the target table: Size(GetRecords("{3.LTE." & [Record ID#] & "})) This example ranks each record, where the lowest record ID gets a return value of 1, but you could use a similar approach on any fields. 2) A formula to find the median based on rank order (doesn't need to live in target table, but can): // Number of records where the target field is not missing var number n = Size(GetRecords("{3.XEX.}")); // Middle index when n is an odd number var number i = Round($n / 2); // Lower and upper bounds for middle ranks of the target variable var number lb = SumValues(GetRecords("{6.EX." & $i & "}"), 3); var number ub = SumValues(GetRecords("{6.EX." & ($i + 1) & "}"), 3); If(Mod($n, 2) = 1, $lb, // n is odd ($lb + $ub) / 2) // n is even, so sum 2 middlest records and divide by 210Views0likes0CommentsRe: Branching a pipeline based on the number of records in a fetched JSON
Try this: {{ d | count == 2 }} The expected return value of the above would be TRUE. The expected return value of {{ d | count}}==2 would be string literal 2==2 because it is not encapsulated in the curly braces.106Views1like0CommentsSave and wait for pipeline
I would like an easier way to track department meeting attendance. I have a table for Departments, Staff, and a child table in common called Members which associates many staff with many departments and includes the start & end date of their involvement with the department. I also have a table called Meetings which is child to Departments and a table called Attendees which is child to both Meetings and Members. Each time I create a Meeting record, I select a Department and then add a large number of Attendees (selection restricted to only active Members of the selected Department). Adding attendees this way is time-consuming, so I created a Pipeline which runs when a Meeting record is saved. It queries all active Members of a Department and creates Attendees for each found as children of the Meeting. However, this Pipeline often takes 15-30 seconds to execute. While I have access to the Pipelines page, my fellow users don't and it's not obvious to them that a Pipeline is running when they save a meeting. So I created a formula rich-text button which uses the SaveBeforeNavigating class to bring users to a codepage after saving a Meeting. It shows a loading animation, informative message, and redirects the users to the Meeting form after a few seconds. However, sometimes the Pipeline isn't totally finished by then, or maybe it fails. In this case the user is confused. How can I get Pipelines to communicate the status of its activity to a codepage so that I can accurately update the user if/when it finishes execution? If this is not possible, any ideas for a workaround? ------------------------------ John Erdmann ------------------------------64Views0likes2CommentsUsing Jinja to access Pipeline attributes
I would like to access information about my pipeline inside the pipeline's steps. For example, I want a Pipeline to populate a field using the Pipeline ID so that I can trace a result back to source more easily. What is the syntax for accessing a Pipeline's attributes? I've tried the following to no avail: {{pipeline_id}} {{id}} {{this.pipeline_id}} {{this.id}} {{.pipeline_id}} {{.id}} ------------------------------ John Erdmann ------------------------------19Views1like2Comments