Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Does anyone know what the order of execution for Quickbase is?For example, first formula fields are calculated, then automations fire, then pipelines execute.------------------------------Jessica Feauto------------------------------
If you would like to receive Notifications when a New Topic is created in the Forum, you will need to do two things: 1) ensure you are following the forum. You will select the bell and it should show a check mark as seen below. If you do not see a check mark, you are not "Following" the forum 2) In your Profile > My Settings > Follow and Notifications, whatever you choose for options will now be respected. If you select "Immediately", you will get a notification for every new topic posted to this forum. Daily and Weekly Digest allow for options if you would prefer to only get a daily or weekly email showing all new topics. But this setting will only work if the bell in step 1 is selected. Shoutouts to Samtheman and MarkShnier__You for helping troubleshoot this!
I have tickets that can cost either $2 or $68 and I currently have over 4K tickets throughout the months of Jan 2024 - April 2024. I have $368K budget spread over a 21month duration. I need to show how much over or under for each month with respect to the budget.
Trying to prevent save if a URL field does not contain start of the needed URLs. Instead it is blocking everything
Hello all,Use case: I'm building an integration with AI models where I send JSON-formatted data for analysis. The JSON-formatting data comes from the Quickbase run report API which outputs table data in standard JSON. So essentially, I'm sending JSON from Quickbase inside a JSON value to an AI model.Issue: While passing the raw JSON to my AI model, Pipeline automatically converts the JSON to Unicode JSON with "u" characters. Example of how it looks in the Pipelines activity log:Is there any way to use Jinja2 or some other method to make sure the JSON is a standard JSON? This will help the AI model better understand the data.
Hello!We track a number of different status options in QuickBase. Some users have permission to change these statuses while others are restricted.In one place, we ask the PM to complete some tasks, check a box indicating they've done the work, and touch Save. When they do this, we want the status to automatically change from Awaiting Action to Submitted / Not Yet Reviewed.I know I've been able to make this work in the past. But now, I'm finding that because the user doesn't have full access to the field, the status isn't changing. I could just unlock the field, but then the user could potentially just move the project status to Approved which I do not want.Does anyone have a suggestion for achieving this?Thanks,Colin
Hi All,I'm setting up a support ticketing system in Quickbase for my company. All of our support requests are sent to a specific email. I want to set up a pipeline to grab the necessary information from an email arrives to create a ticket in Quickbase.One of the items I'm trying to grab is the attachment. Most of these emails are forwarded voicemail files from our phone system. I want to save a copy of the attachment to the ticket record in Quickbase. Is there a way to do this? I'm currently trying to utilize the Microsoft Outlook channel and I'm seeing a query step, but I'm not seeing how to retrieve the actual attachment, just the attachment name.
I recently took over an existing Quickbase that involves approvals based on various data points -one table is use. Recently, I have been asked to require approvals for specific users based on two different text-multi select text boxes. It should fill in "approval is required" in the approval status. I have been unable to combine the two fields. I am adding to the existing field formula for the approval like this but I need to make "Sales Leader Required" only when both options are true and keep getting an error. I have a large matrix that needs different approval based on the Renewal Discount and the Renewal ACV.IF(Contains(ToText([Renewal Discount]), "Within Threshold"),"<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>",Contains(ToText([Renewal ACV]), "<$100,000"), "<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>","Sales Leader Approval Not Required")
Searching for a way to allow a user to select multiple files for downloading. Currently I have a parent-child table relationship where the file attachments are stored/managed in the child table. Each parent could have multiple child records. Seeking way to allow user to select one or more of the related files and download in a single action.Was thinking I could possibly build a pipeline that when ran would look for any child records whose checkbox (or some other identified field) was checked and then create a single download action to export the identified items to the users local system. The pipeline would then "reset" the field to uncheck or remove the value that was used to start the pipeline.Is something like this possible?Thanks
Looking for a way to help users customize child related tasks when creating a new parent record. Nothing has been built quite yet but the basic structure would be to have a parent table Transactions which relates to a child table Tasks. Each Transaction could have a dozen or more Tasks. To aid the user in not having to create each Task for each new Transaction, I was thinking I could present to the user a "list" of available Tasks that they could select. Then when the parent record was saved, each of the selected Tasks would be created as new records in the related child table (linked, of course, to the new created parent record). I'm thinking, to start, I will need some kind of field on the parent record which would display the list of available Tasks. I would envision that this field would only be visible when the record is being created and hidden all other times. Once the Tasks have been selected I would need some way of translating each selection into its o
Greetings. I am trying to create a Due Date/Time field that would show 48 hours from the Date Created for a record, but need to take into account work hours.Right now my formula is [Date Created]+Hours(48), which shows the date/time 48 hours later, but if the record is created Saturday morning at 10am, for example, I would need the countdown to start as of Monday morning 8am. I thought about using ToWorkDate, then WorkDateAdd, but I believe I would lose the time component, so am not sure that will work for the date/time field type.Any suggestions?
Hi, I'm building an app where the project is projecting out 5 years, but the project owner might only ask for funding for 1 or 2 years (to keep costs manageable, but they need to project to 5 years).I made a multi-choice field to select which years is the "current ask".Year 1, Year 2, Year 3, Year 4, Year 5 (these are formula checkbox)Then that field is a lookup on the table "resources" where all of the details/math/etc are done.I have checkboxes on the resources table that saysYear 1 askyear 2 ask, and so on.I want to calculate the financials for the "current ask". So If Year 2, and Year 3 are the "current ask", then take Year 2 Financials, and Year 3 financials and add them together to give me a total for those years.Here's the formula I've come up with:var text checkbox = (ToText([Year 1 Ask] or [Year 2 Ask] or [Year 3 Ask] or [Year 4 ask]));If($checkbox = "true",Nz([YEAR 1]) + Nz([YEAR 2]) + Nz([YEAR 3]) + Nz([YEAR 4]) + Nz([YEAR 5]))I'm getting a syntax error every which way
Hello AEC Customer Network Qrew! Due to busy summer schedules in July among our customers, we are cancelling ALL Customer Network meetings for the Month of July. We will be holding discussions on the Qrew Discussions group page during this time. If you have any questions or feedback, please reach out to EstherLaVielle Thank you and have a wonderful summer!
Hello Mobile Workflow Customer Network Qrew! Due to busy summer schedules in July among our customers, we are cancelling ALL Customer Network meetings for the Month of July. We will be holding discussions on the Qrew Discussions group page during this time. If you have any questions or feedback, please reach out to Thank you and have a wonderful summer!
I have done this before, but it's been a while, and my brain doesn't seem to be working today. I've also searched and not come up with the solution. I have a form to add a record, it's open to "everyone on the internet". I can open it in a browser I am not logged into and it works as I want it to. Now I want to embed this on a public web page. I cannot figure out the iframe embed code to make it work. I have a specific form assigned to "everyone on the internet", and I'd like to strip all the Quickbase "stuff" from the page and just have a "Submit" button that saves and redirects to some kind of thank you page on the site.
I have a currency summary field in my invoice table that shows "our cost" which is summarized from another table in out APP. I would like to create a formula checkbox field that will be checked if the "our cost" field is blank in my INVOCIES table. Is this possible to do?I have tried several formulas option in a checkbox formula field, the NZ function, as well as the Null function using another field I created and converted our cost to a text field. I need to use this missing our cost field for several other things as well, but cannot get the formula right.....Thanks
I have a new app that I duplicated from a previous app. The previous app was made in the old nav and has a lot of buttons (formula-url) that point to specific forms for editing specific parts of the flow. On the new nav, I get a 404 error every time I hit save; the record saves the new information, but it doesn't go where it should. My formula is below. What changes do I need to make to get this to work in the new nav? Thanks!URLRoot() & "db/" & [_DBID_TRAINING] & "?a=er&dfid=16&rid=" & [Record ID#]
I put the following code into a Formula URL field. The purpose is to change the status to completed by clicking the button.URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed"Works great, but it then goes to the response page below. Which I don't want. How do I modify the code above to simply change the status and refresh the page.------------------------------Steven Nelson------------------------------
I am trying to set up custom email notifications that send from the user who is adding a new record. The problem I'm having is that no matter what I try, the from is not sending from our internal email, it's sending from notify@quickbase.com. Is there any way that we can set it to send from our internal email address? Our company has some pretty strict and sometimes unpredictable firewalls and flags and I'm nervous that these notifications are going to get lost. The notifications I have set up already are on Pipelines, but they only send from my email address. Our new app project would be better sent from the user who made the change which is why we're trying to figure out other solutions.
We keep getting No 'Access-Control-Allow-Origin' header is present on the requested resource. when we try to access QuickBase API's
Is there a way to lookup a field within the same table?
Should be a simple fix that I cannot figure out for some reason... I have a connected table across two apps that mirror each other for much of their fields. Everything transfers over BUT file attachments carry over as text but not as an openable file. both fields are file attachments and both are linked though the connected table. I want it to be so when someone attaches a file in the main table... You can then open that file in the other app's connected table. see below snip for what the connected table looks like... it should be blue/a click to download. Thank You in advance... please help! ------------------------------Eddy Elasmar------------------------------
I'm attempting to convert a numeric field to a text field based on the the content. So far I have the following formula but it's not working. IF([Time in Role] =< 1 ,"Less than 1 year",[Time in Role] => 1.01 & =< 3 ,"1 to 3 years",[Time in Role] => 3.01 & =< 5 ,"3 to 5 years",[Time in Role] => 5.01 & =< 10 ,"5 to 10 years",[Time in Role] => 10.01 & =< 15 ,"10 to 15 years",[Time in Role] => 15.01 & =< 20 ,"15 to 20 years",[Time in Role] => 20.01,"20+ years") thanks!
Hi there, just wanted to see if anyone has experienced font issues in the new Beta view? We have £ and € symbols and sometimes blank spaces that change to question marks and other symbols like below:Any tips on how to fix this?
I am attempting to create a flow where a response submitted in Microsoft Forms results in a new record being created in a Quickbase table. I initially tried to achieve this by setting up a pipeline but was unable to find a channel for Microsoft Forms. Could you please advise on the best approach to accomplish this integration?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.