Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Links Banner
Main Content
Recent Content
problem populating relationship field from import
In a new QB app we created, we have a table "Phishing Attempts" where we want to create records by importing a spreadsheet. We also have a table "Targeted Users" which has employee info such as Employee ID, email, position, etc. Phishing Attempts table has a relationship with Targeted Users table, where we have the Employee ID field from Targeted Users included in the Phishing Attempts record form along with lookup fields that are automatically pulled from Targeted Users table. The spreadsheet we want to import to create new records in Phishing Attempts table includes an employee ID number. When we import the spreadsheet, we select the target field Employee ID in the Phishing Attempts form. The problem is that the Employee ID field in the Phishing Attempts form is not populating when we do the import. The ID number in the spreadsheet matches exactly what is in Employee ID in Targeted Users table. Is this not working because the Employee ID field in Phishing Attempts is pulling from Targeted Users table? Is there a way to get this to work?Save & Continue on New Record form
Hello all, I'm trying to create a Save & Continue button for an add form that will return to the record to continue editing. I found this thread ( Add Save and Keep Working Button on form for a new record | Qrew Discussions ) from a few years ago which is exactly what I want to do, but it doesn't seem to be working as stated anymore. var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%RID%%"; var text link = "<a href='" & $URL & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>"; $link When I click the created button I do see the "saving record" alert appear and then the green "Record saved!" but then directly after a window pops up "Leave site? Changes you made may not be saved." with options of Leave and Cancel. It doesn't matter what option I select, the next screen is the quickbase error page "Record Not Found" and to either go to the application's dashboard or go back to the previous page. Although the record is there when I go back in manually. I'm not sure what to add to the formula to get it back to the created record in edit form. Thanks, KellyRecords, Pipelines, and Callable Pipelines clarification
Hello! I am a new user, and I'm looking for some clarifications on some of the specifics about how records, pipelines, and the callable pipelines action relate. I have a complex pipeline trigger by a user record creation. The pipeline runs through a substantial decision tree and updates records and sends notifications depending on the path through the decision tree the record takes. However, I have run out of actions and need to set up a callable pipeline to do some record validation (instead of adding those steps into the main pipeline). So, I am working on setting up the callable pipeline, but I want to make sure that the pipelines are only updating a given record, and not ALL records. - Update: before you read the next part of the post, consider that I may be overthinking this whole thing and I just need to pass through the record ID(s) for the records I want my called pipeline to validate. - I assume that when a pipeline runs with the "record created" trigger that the pipeline will run only with relation to a given record; i.e. is the context of the pipeline run a single record? Is that correct, or does it evaluate the whole table of records? Or do I need to set a record limit on the trigger? When I use a callable pipeline, does the calling pipeline maintain the context of the call; i.e. for a single or batch of records? Depending on that answer, does the pipeline evaluate each of those records individually, or does it evaluate the entire table with respect to the called field(s)? For example, here are my two actions. I thought I had them set up correctly, but I can't call the fields from the calling pipeline in the called pipeline (third screenshot). Update: this may be because neither of the pipelines are turned on, and I may be using Jinja expressions where I should instead be using aliases which I can set to the calling pipeline's fields (see this video). Do I need to bother with passing the record IDs ("a.id"), or are those "implicit"? Call action: Called trigger: Not finding called fields: BUT let's assume that I get these calls to work. Will the changes to the records made in the calling pipeline have been written to the table when the called pipeline is called? Because that pipeline will need to do evaluations based on the records' data, which is dependent on the actions in the calling pipeline! Thanks for all of your help!
Date / Field stamp through pipeline
I have a step in my pipeline that creates line items and inserts required data in that line item. The completion status of this line item is dependent on the field completed date. How do i include the completed date in the step so that when the data is added so that the line item is complete
Pipeline formula for user names
I need a pipeline to populate a field in a new record with the names from another field. Many users did not update their profile with a ‘Screen Name’ so I can’t use that field in the pipeline. I am having trouble getting it to populate using the First and Last Names. What formula can I use in Pipelines to create a list of multiple names? I used this field to create a text field and this is what is returned: Using this text field is not ideal as Barb does not have a screen name so it defaults to her email address. If there are several users, this field will be harder to read with emails being used. I want the pipeline to take the Fundraisers Assigned values and populate like this – preferably comma separated but semi-colon is fine too. Example: Amy Gosz, Barbara Burns I can get the First Name and Last Name to combine but then it only returns one of the names. How do I write the formula to not only combine the First Name and Last Name, but also list the multiple users names? I need all names (can be several) that appear in the Fundraisers Assigned field to populate to the new field.
Part-Time Quickbase Developer (Freelance/Contract)
Remote - Flexible Hours - Hourly or Project-Based Glass Design is a small, family-owned business based in Florida. We specialize in designer glass and custom entry doors. We use Quickbase as our CRM and production management system and are looking for a skilled Quickbase developer to support our team on an as-needed basis. Estimated workload is 20 to 30 hours per week depending on project flow. What You Will Do Improve forms, fields, workflows, and automations Build reports and dashboards Develop functionality using Quickbase formulas, Pipelines, and scripting Set up and manage integrations with tools such as Zapier, FastFields, CallRail, and RingCentral Troubleshoot issues and improve existing processes Create simple documentation or training materials as needed What We Are Looking For Experience building and managing Quickbase apps Strong understanding of Pipelines, formulas, roles, and permissions Familiarity with integrations using Zapier and other APIs Bonus if you know JavaScript or have experience with webhooks and REST APIs Self-starter with strong communication skills Able to work independently on flexible, project-based tasks Engagement Details Part-time or project-based (15 to 30 hours per week) 100 percent remote with flexible hours Hourly or fixed rate negotiable (we are a small business with a lean budget) Start date as soon as possible with a few initial projects to test fit To ApplyEmail the following to mailto:hr@glassdesigns.com Examples of Quickbase work you have done Your hourly rate and availability Any certifications or technical experienceA short note about why you are a good fit to support a small service-based business
Do Bulk Records Pipelines Make Simultaneous Updates?
When bulk records are handled in a pipeline, are all of the applicable records updated simultaneously? Will they have the same modified date and time? I have notifications setup to be triggered when a date field is updated. I have a formula checkbox field used to identify the most recent record associated with an email address field value. The most recent record may not be the one that gets updated along with other records with the same email address field value. I don't want the email notification being sent before other associated records are updated. I am looking at using Bulk Record steps to reduce the number of pipeline steps I am currently using as well as handle everythingmore efficiently. I just need to know if I would be safe having the date field updated on the most recent record with the other potential changes without worrying about the email being triggered before all applicable updates are made. Thank you, in advance for any input. Let me know if I need to provide a visual and/or more clarification on what I am looking to accomplish.August 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, August 27th, 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned. We will also check in on moving Pipelines and setting up a separate Notification. Additional performance improvements will be shared. Finally a look at Grid Reports for those who don't have beta. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation.
