Recent Discussions
How to send field values to a Mailgun template in Pipelines
In my Pipeline, when a record is created, it tells Mailgun to send an email using a specific template within Mailgun. How can I pass Quickbase field values to the Mailgun template? There doesn't appear to be an obvious solution from looking at the interface (see screenshot). ------------------------------ Matt Makris ------------------------------
Percentage through the month
I want to determine the percentage of the month completed; for example if today is the 14th, and there are 30 days in April the percentage is 0.46. To keep the formula simple I can assume all months have 31 days--so Today()/31. I am struggling with the formual type, is it date is it number?Share your Empower Photos with the Qrew!
Who here is having fun at Empower in New Orleans? We would love to see your photos or videos. Reply and add your pictures for everyone to see on the Community. Here's a few from our Day 1 and 2 keynote sessions: & Analytics at Albertsons, sharing how Albertsons were able to leverage Quickbase for future -planning and execution of real estate life cycle management.
How to build a pipeline that creates child records based on a list-user field in the parent record?
I have 3 tables - Projects, Tasks, and Task Bids. In the parent table, Projects, I have an embedded Tasks table that is editable on the Projects record so managers can just fill in the tasks they need completed. On that embedded Tasks table I have a list-user field where they can assign up to 20 contractors. When I save the Project (which will also save the Tasks) how can I build a pipeline to create separate Task Bid records for each contractor on the list-user field?
Retrieving a record using a code page...
Building on the method described in the link below to post to Quickbase using an HTML form and EOTI access, is there a way to retrieve records to a similar form using an rid in a custom URL link (or any other way)? If so, how would you do it? https://community.quickbase.com/discussions/quickbase-discussions/posting-from-an-html-form-directly-to-quickbase/90206
File Attachment to Multiple Units Pipeline
Hello Everyone, I am looking to see if there is a solution for uploading files and having them auto populate records on a join table that links my sales order units with document files. I would like to know if it is possible to have the file attachment text contain the necessary info for a pipeline to read and perform the needed tasks. here is what i am currently trying. using file manager plugin i upload docs through sales order table(projects table) then it uploads to its documents table testing a pipeline that can read unit# on the attached file once it is uploaded however i seem to get an issue when pipeline goes to create the records in the docs join table, the error message is below so at the moment i cant even tell if it can read the unit# and create a link for each unit per attachment. Validation error: Incorrect template "{{b.id}}{{b.related_sales_order}}". ValueError: invalid literal for int() with base 10: 'id'
Help with Calculating Average Completion Time Over Several Records
Hello, I have a table where each employee progresses through a stage with three date fields: Start Date & Scope/Role, Verify Eligibility & Funds, and Create Visa Plan. I also have a formula field that tracks the status of this stage (Not Started, In Progress, Complete) and calculates the number of days taken if the stage is complete. I need help calculating the average number of days it takes for employees to complete the stage. For example, if Employee 1 took 14 days, Employee 2 hasn't started yet, Employee 3 took 21 days, and Employee 4 is In Progress, I want to calculate the average completion time, which would be 17.5 days (it should only count those completed). Can anyone suggest the best way to achieve this? Thanks so much! Meag
