Sorting high to low within a Pipeline search
I am trying to create a dynamic report that will stay updated with our top 25 clients based on their ACV. I have a checkbox field on each account labeled 'Top 25'. My goal is to have this automatically updated based on each account’s ACV. Ideally this proccess would: Look at all eligible Accounts Rank them by ACV from highest to lowest Identify only the top 25 Check the Top 25 checkbox for those Accounts Uncheck Accounts that fall out of the Top 25 Recalculate this automatically on a schedule The main issue I'm having is the Search Records step lets me set a record limit of 25 without giving me an option to sort the results by ACV. Because of that, I’m concerned that limiting the search to 25 records would not necessarily return the 25 highest ACV accounts. Any help will be appreciated. Thanks!Solved24Views0likes1CommentHow to group a report by individual values in a Multi-select Text field?
I have a Multi-select Text field on my Projects table called Project Products. A project can have multiple products, for example: Product A; Product B; Product C I’m trying to build a report that groups/counts by each individual product, but when I group by the multi-select field, Quickbase groups by the entire combination of selected values instead. For example, I’m getting groups like: Product A; Product B Product A Product B; Product C Instead, I want the report to display: Product A — 2 projects Product B — 2 projects Product C — 1 project Is there a way to “explode” or separate the values from a Multi-select Text field so each individual product can be grouped and counted within one report?Solved38Views0likes3CommentsSync table and pipelines
Hello, I have a sync table to salesforce, and I have another table called projects. I've created a pipeline when the trigger is record added to SF table, then it must create a record into projects table. I tested this in sandbox and it works, but I manually created the record in SF tables (trying to mimic the behavior in live). So, I created another pipeline for "live", but this doesn't trigger. Now I know that sync table doesn't works the same as a normal table, so I need to change the logic of my trigger. SF table refresh the data once every day. I was thinking in add a "schedule", and search when "Creation Date" is the date of "today", like: If CreationDate = today AND flag = unchecked Create record in projects flag = Check End if But I don't know how accurate this logic is. I want to create a record in project with the new sync data and not with old values. Any suggestion will be appreciated :)Solved95Views0likes6CommentsReconnect existing Salesforce Sync Table after "Disconnect Table" was selected
Hello, We have a Salesforce Sync Table that was originally owned by another user. While attempting to transfer the connection to a different user, "Disconnect Table" was selected instead of changing the connection. The table still exists and contains important relationships and pipelines. Is there any way to restore or reconnect the Salesforce connection to the existing table without recreating it? Thank you.50Views0likes2CommentsProject Status Spotlights
Hi, I am using a Project Status multiple choice dropdown field with the following options: Green - On Track Yellow - At Risk Red - Off Track Blue - Complete Purple - On Hold Black - Canceled Silver - Closed I'd like to incorporate the Project Spotlight formula featured in Exchange so that the status displays in it corresponding color (while also keeping the text separate). I'm struggling with where to insert the formula and how to modify the formula to recognize my custom status values and colors noted above. I appreciate the help!81Views1like4CommentsButtons and Dynamic Form Rules Issues
First let me say that I am new to developing Quickbase apps. Here is what I am trying to do and where I’m running into issues: My app tracks the entire demand lifecycle from draft/idea to a project. I have statuses like Draft, In Development, Under Review, and Approved (project pending) or Rejected/Canceled. I have created sections for Intake, Proposal, and Charter. At intake, all new demands have a separate intake form with basic information collected and the status defaults to Draft. Dashboard - When the demand is in Draft status, a “Start Proposal” button should be visible. When that button is clicked, the status is updated to “In Development” and the Proposal Section should appear, other sections should be hidden. I am trying to accomplish this by using a helper field (checkbox) and Dynamic Form Rules: If Start Proposal? Is checked and Status is “Draft” change value Status to value “In Development”, Change value Start Proposal? to unchecked. The same process applies to the next step: When the status is “In Development” show button “Review & Submit Proposal”, the form opens with Proposal Section only showing and a “Submit” button to submit the form to the demand manager for review. The user can open/edit as needed. Nothing else should happen until the “Submit” button is clicked. When the button is clicked the status is updated to “Under Review”. The problem that I’m running into is if I have more than one rule, I get a conflict. How can I best resolve the conflict? Is there a better way to accomplish this task?263Views3likes12CommentsFormula to lookup value in another related table
I have a lookup table that has a relationship with 2 other tables (Table 1 & Table 2). There are 2 different IDs in my lookup table that I need to check in Table 1 & Table 2. I need to check Table 1 if one of the IDs exists, if yes then I need a checkbox ticked. For the other ID, I need to check if it exists in Table 2, if yes then some other checkbox is ticked. How do I go about doing this?Solved162Views1like1Comment