Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a table that consists of different department tags, such as HR, Operations, Research, etc. I have a separate table that has projects that get tagged to multiple departments. I want to create a multi-select text field that uses the "Department" text field in the other table as a source field. When I try this the pop-up opens and I am able to select the correct field, but when I click "Ok" the field does not update. The "Select shared field" option is now grayed out and when I try to save I get the following message:Any and all suggestions welcome!------------------------------Peter Ohashi------------------------------
Hello, I want to include a QB report in an IFrame from an external site. Is it possible to grant anonymous users access to QuickBase reports by providing a user token, in a similar way to how attachments can be accessed using the usertoken URL parameter? Or are there any other ways to achieve this? Thanks, Daniel------------------------------Dan C------------------------------
I've noticed that in a fields usage, it will sometimes show that it is part of a Pipeline, and other times will not. In case others are wondering why, Customer Support Confirmed the following:'Fields used in a Pipeline only appear on a field's usage screen if it's part of the TRIGGER step. Action steps do not appear in the usage tab'.Not sure why they would intentionally program it like that. Seems like a good use of the feedback tab.....along with the fact that if it does tell you in the usage tab it is used in a Pipeline, it doesnt tell you which pipeline (the numbers it shows are not the pipeline number, they are irrelevant to the user).------------------------------Mike Tamoush------------------------------
[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.] Append fields can become quite large and contain too much text to display in a report easily. You can use a Formula - Text field to display only the most recent value from your append field and then display the formula text field in your reports instead of the append field. 1. Create a Formula - Text field. To learn how, please see our help topic. 2. In the field's formula box, enter in the following formula, making sure to replace "AppendTightField" with the name of your append field, exactly as it is spelled and punctuated in QuickBase. NotLeft(Right([AppendTightField],"]"),1) 3. In your reports, remove the append field as a column and replace it with the Formula - Text field. To learn more, please see our Columns to Display help topic. Your report is now much easier to read now with only the most recent comment visible
I'm using API_GenAddRecordForm to copy existing record to new record. The form is displayed with the 'copied' data but until the new record is saved, there's no Record ID assigned. I need a record id assigned for another step in the edit process. Any advice on how to copy the record, save the copied record, retrieve the copied record id and then edit the copied record? ------------------------------Cathy Wilbur------------------------------
I was watching Empower 2022 - Building The future presentation (HERE) and I was wondering if this app will be shared over exchange (couldn't find it). I like some solution and would love to integrate it with my application.Any chance to share with us?------------------------------Adam Krzyzanek------------------------------
Is there a sneaky way to accomplish the following?- Viewing a Record in Table A- On subject Record is a Report Link for UNRELATED Table B. One of the columns in the report link is a formula URL button-When Pressing that Formula URL button, one of the actions needs to use the Record ID of the record the user is currently viewing in Table AAny way to somehow get that record ID to use in that button push? It feels like this can't be possible, but some people here have come up with some creative ideas before...Among other things, I would simply like to return to the Record in Table A I left from...and I don't believe & "&z=" & Rurl(); works with API_EditRecord?------------------------------Mike Tamoush------------------------------
I am trying to search for a calendar event with subject that contains "PBG ({{a.pbg_number}}) Followup Reminder" and delete.When I enter the Subject field (one below Calendar) as "PBG ({{a.pbg_number}}) Followup Reminder User" (without quotes), then the pipeline couldn't find any match. But when I add a condition like below snapshot it finds 6 matches but keeps running in a loop and pipeline doesn't stop.Can you help me fix this?------------------------------Anitha Jeevarathinam------------------------------
I am not able to find a video the demonstrates the linking and fetching feature beyond this intro to the feature: https://university.quickbase.com/build-powerful-pipelines-using-included-features/645783The video I am looking for included instructions for including these additional features and I cannot find it -Bi-directional updates ( i.e. A would update B and B would update A)-Linking existing recordsThanks!------------------------------Christine White------------------------------
Hello,I am struggling to find a way to trigger an action without human input. The app we have has Compliance work Records and each of these has a number of tasks associated with it. So a record to complete a tax return may have a task where we have sent the return to the client for approval but we are waiting for the client to respond.In our previous software we had tasks that went overdue and on going overdue they could trigger certain actions as required. So in this scenario the tasks would go overdue, complete themselves, send an email to the client reminding them we are awaiting approval and pop in a new task along the lines of Awaiting Approval, Client Chased for example and remove the old task.Currently I have the following Action:Which works perfectly, aside from the fact, it only triggers when someone actually goes into the task and changes something. I need a way for this to trigger without someone going in and updating the record?At present each task has a number of days asso
I am looking to create a QuickBase native form but embedding a translator that would translate fields names as well as options within multiple choice fields. ------------------------------OIS-APPS1 DEV------------------------------
We have way too many statuses. I want to combine several status values together to create an "In Progress" count of records so that I can have a cleaner summary table that doesn't show all of the statuses.I am pretty new to all of this so hoping someone can help me out.Example of COMPLETED status might contain the following values: AcceptedSentCompletedThen I would like to display an NEW, CANCELLED, IN PROGRESS, COMPLETED summary report that is nicer to look at than the 30 statuses we currently have.Any help appreciated! ------------------------------Stephanie B------------------------------
Has anyone managed to use a record-specific Google Sheet ID (from the URL) to locate the Google Sheet and search the Sheet's rows? The Google Sheet ID would be different for each record. I can search the rows for a predefined Google Sheet ID. I would like the searched Sheet to be variable based on the URL that's saved to the Quickbase record.------------------------------Daniel Dabek------------------------------
I have a text-multiple choice field that presently has 65 options from which the user can choose. I need a formula that I can assign to a formula-numeric field that returns the count of all possible options from that dropdown. We expect it to change from time to time and would like for the count to adjust based on additions or deletions to the options. Thoughts?------------------------------Justin Owens------------------------------
Hi,Within my application, I'm looking importing data from a table into a form for calculation. Was trying to use the GetFieldValues(GetRecord ) command to get a specific value from a table. Will work if I pass a fixed Record Identifier and required Field, but we need to be able to dynamically pass through the Record Identifier.Is it possible to incorporate the value for Record Identifier as variable, which we can be dynamically as required.RgdsPat ------------------------------Patrick O'Neill------------------------------
How can I ask a field to simply lookup the information again?------------------------------Lori Pelzel------------------------------
Starting a new thread to try to solve an ongoing issue. Looking to capture latitude and longitude of a mobile user. There is functionality that uses a code page that works for desktop, but code pages I was told do not work on the mobile app.The new idea was to use the mobile address feature to capture a current address. Then use a pipeline to change that address into a latitude and longitude. However, I have no idea what that pipeline would look like. Some api call to an external mapping program?? Anyone know how this can be done?------------------------------Mike Tamoush------------------------------
Is there any way to have a button, that when pushed takes the GPS location of the mobile device, and records it into a field? Just got that request, and I dont even know where to start.------------------------------Mike Tamoush------------------------------
I'm trying to create a formula in a report to highlight certain colors based on proximity to a date. If([Escalation Date]<Today(),"red", [Escalation Date]>Today xxxxx,"Yellow") The xxxx is what I'm having issues with. I want the row in the report to highlight Yellow if Escalation Date is within 3 days of now. Example: If today is the 8th, and the Escalation Date is within 3 days, then highlight yellow. This is the current formula: If([Escalation Date]<Today(),"Red",[Escalation Date]>Today()+Days(3),"Yellow") The Red works as expected, but the Yellow highlights everything else. I just want it to highlight items within 3 days of Today. I hope that makes sense. ------------------------------Tony Miller------------------------------
I don't want to post the HTML just yet but I have an Pipeline that I'm working on and everything is good except the html body of the email is not fully rendering. It renders about half to three quarters of the email and the rest is just the html code.I have this exact same html in a email reminder that works fine. Is there anything about that Pipelines that would cause this?Thanks.------------------------------Carol Mcconnell------------------------------
I have a table of Sites. Each site has many contracts. Flash forward to a table of Projects. On my project I want to select a contract, and I want the sites to be shown conditionally, so that the site shown includes the contract selected (so typically, the conditional drop the 2 fields must equal each other). Example:Site A is associated with Contract 1 and Contract 2 (children).Site B is associated with Contract 1 (child).On the project, select Contract 2. In the Site dropdown, only Site A is shown.------------------------------Mike Tamoush------------------------------
Team,Where can I find more info about options available in Gantt Plugin under Advance settings?How to use it and how will it impact my schedule?------------------------------Adam Krzyzanek------------------------------
Question: If there a ways to calculate Project Management tasks with "duration" less than 1 day?Background:I am managing Initiatives delivery in my application and my users asked if we can calculate "Projected End Date" of task with task duration smaller than 1 day. Let say I have tasks which takes 0.1 day (2.4h ) or 0.2 (4.8h) I would like to calculate it as less than 1 day. Example: If 3 tasks below 1 day are after each other it should show as Starting and Ending at the same day.What I currently have:1) [Starting Date] - Work Date2) [Projected End Date] - Work Date (where: 3) [Duration] - Numeric4) [Pred] - PredecessorI tried to add [Real Duration] = Duration field but it cannot be used for "Time span field" ------------------------------Adam Krzyzanek------------------------------
Hello,i seem to be having an issue regarding creating a formula date/time field using the REST API.i get the field data from a different table and receive something like this { "appearsByDefault": false, "audited": false, "bold": false, "doesDataCopy": false, "fieldHelp": "", "fieldType": "timestamp", "findEnabled": false, "id": 415, "label": "Week Ending Date", "mode": "formula", "noWrap": true, "properties": { "allowNewChoices": false, "carryChoices": true, "defaultToday": false, "d
I've been using the predecessor fields for some time now with good results. But a recent request was to change their functionality slightly, to still make a task not start before it's predecessor, but always start x number of days after its predecessor is completed instead of on the same day. Is there a way to make this happen?------------------------------Nathan Allan------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.