Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello Everyone! I am experiencing a very odd issue that I'm hoping someone can give me direction on. This was working prior to today and nothing appears to have changed, so I'm a bit confused. My attachment includes screenshots that should help. In the table Laptop/Desktop Inventory, I have created a custom report called Computer is not assigned to an employee. The table only includes 3 records. The logic behind this report includes one filter. All of these conditions are true Computer is Assigned? is not equal to checked. Computer is Assigned? is a checkbox summary field associated with the Parent Table – Laptop/Desktop Inventory. The child table in the relationship is the Laptop Desktop Usage. When I create a new Laptop Desktop Usage Record, I'm presented with the Add Laptop Desktop Usage Record Form. When I select the Computer – Inventory dropdown on this form, I'm presented with the results of the Computer is not assigned to an employee Table. I've set this
I have a parent table [year] and its child table is [week_ending_dates]. [year] ------------> [week_ending_dates] A pipeline runs annually on 1 Jan of every year and creates the New Year's date of 1 JAN YYYY in the parent table record date field. The parent record creation triggers another pipeline to populate the related child table [week_ending_dates] with every Sunday's date for that year. One date, one record. Well, that's where it ends for me.... I am seeking some insight into creating the pipeline loop that creates each Sunday's date, as a record for the parent year. Seeking full automation and trying to avoid any table imports or manual work. ------------------------------v/r,Chuck------------------------------
I have a table in Quickbase that is intended to be maintained as the image of a similar table in a foreign system, and I am attempting to use Pipelines to keep the table updated in near real time, rather than to batch load it. When changes occur in the foreign system, it sends signals to a Quickbase webhooks URL. The signals can be of type "creation" or "fieldChange", among other types. Each change to a field results in a separate signal, and when a record is created in the foreign system, the system first send sends the "creation" signal, then sends separate "fieldChange" signals for each field that gets populated during creation. The signal looks something like this: { "eventType": "fieldChange", "recordId": 16793426360, "fieldName": "company_name", "fieldValue": "Acme"} Since any given signal can be a change for any field in the foreign table, I use the following Jinja code for every field in the Quickbase table that might need to be updated: {% if b.field_na
Hi,I'm using the following formula to operate a button. Pressing the button opens a specific form, form 11.URLRoot() & "db/" & [_DBID_TABLEINQUESTION] & "?a=er&dfid=1000011&rid=" & URLEncode ([Record ID#])& "&z=" & Rurl()Every morning I test the button. Although the URL displayed in my browser address bar shows "...dfid=1000011", I am looking at form 2, the default form. If I go to settings/forms and preview each form, the button works properly again until the next day. Please help------------------------------J.T. Ogle------------------------------
Hello. I'm trying to rebuild a form using the new form builder. The look and feel of the forms built with the form builder are larger and easier to see for some of our employees. Unfortunately, I have run into an issue with the display of our rich text (reference proxy) fields when these fields are added using the form builder. These forms will only display with their HTML showing. This was not the case with our old forms. I've attached screen captures of the fields from our new form built with the form builder and our old form to demonstrate our issue. The visual clutter of HTML tags appearing with our data will be a deal breaker for updating this form. Has anyone found any workaround for this issue? Any input is welcomed. Thanks ------------------------------Kaisa Janzen------------------------------
Hello community, DOes anybody knows the formula to create the map in quickbase. I have seen a lot of youtube videos that they have nice maps and those use formula text. But non of those show the formula that they use. Anybody that can help me with that?------------------------------Rocio Carrion Rabanal------------------------------
Hi, I am trying to do a button to mark as completed a task. When I try this, the Status is changed to "Completed" but as text and not as the multiple choice option "Completed" of the field. This is a problem because if I colour the records that are completed, these ones are not coloured. How can I solve this? This is my formula: If([Task Status]<>"Completed",URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_11= Completed" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid())) Thanks!------------------------------Francisco Ojeda------------------------------
Hi, I have created a form for our employees to complete when we take on a new customer. I have a multi-select question (Is vendor New or Existing? A: New, B: Existing). If the vendor is New, I would like them to either check or uncheck "New vendor form submitted for your account". If vendor is existing, I would like them to either check/uncheck "Broker change process completed". I believe a checkbox formula is needed but I am unsure how to create this. To simply put, the check box question will be dependent on the previous answer (new/existing customer). I do not want both checkboxes to be available. Thanks!------------------------------Megan Robb------------------------------
Hello, I have a button on the default dashboard that opens a form. After saving the form is it possible to redirect the user back to the dashboard rather than displaying the submitted form record? Also, even a bonus, would it be possible to display a small window that says thankyou for the form submission and takes you back to the dashboard? Thanks, Brian------------------------------Brian Dunk------------------------------
Not really a question (unless someone has a better approach), but just posting to help others who may be dealing with what I just spent hours trying to figure out. BACKGROUND: I created a pipeline to send data from created records in a table over to an external cloud database (xata, in my case) for other purposes. I created data tables and schema in Xata that would match my QB table. Xata can create new records there using an API call via JSON. In the pipeline, the trigger was the creation of a QB record, followed by JSON query (Make Request action). I chose to do a webhook via pipelines (via Make Request) rather than webhooks in the QB table because I couldn't get the webhook there to work either and webhooks there provided almost no error feedback. ISSUE: The Make Request action, i.e. the JSON POST query kept failing. Wouldn't even send the query. After much troubleshooting, here's what I found. After much troubleshooting, it seemed the issues were: Null values - JSON can't deal wi
Hello QB Community, I am creating a new application and I want to preserve the record id # from my original application that is still in use for the ease of keeping data updated. However when importing the data into the new table, trying to merge the key field, I get a error that the records are not found. This makes little sense to me because the table is empty and all the fields being imported are unique. Can someone shed some light on what I am doing wrong. Thanks, Josh------------------------------Joshua Kaye------------------------------
Here is the problem I am trying to solve. We have a number of assets (Types of Valves) that we need to service. Each asset as a gps lat/long coordinate. I can see these assets on a Quickbase Map, so that helps. So, when looking at the map, in a couple square blocks I may have 30-40 assets. I want to pick a few square blocks, and schedule all assets in that square. Scheduling can be a simple date field on the record. Right now, all I can think of is to individually click on every map entry, and edit the record. But that seems too long. Is there some way I can use the GPS coordinates to get a start and stop point, or somehow make a report of the ones I want? Then I can grid edit the report. What I cannot figure out, is when looking at the map, how to somehow create the report with all the assets in the couple block radius I desire. I suppose maybe I can go through my entire map and enter in some sort of coordinates for start points and stop points - 2 corners. Then I have a min/max
You can create a button that allows you to add and link multiple file attachments at once to QuickBase. By getting a copy of the "Magic Buttons" app from the QuickBase Exchange you can copy the button and the html code page and make it your own for your QuickBase application. We cover topics, questions and answers like this in our daily M-F "Office Hours" webinars held at 1pm Eastern time. All are welcome. http://quickbase.com/webinars/------------------------------Kirk Trachy , Senior Solutions Consultant QuickBase | 603-674-5454 M | ktrachy@quickbase.com------------------------------
Is it possible to remove the green "Add New" on a table home page? I don't want to take away the privilege all together, but more so force a user to create new records in that table using "Add New" buttons created within other tables and reports.------------------------------Chris Swirtz------------------------------
Hi, I want to add attachements to my "Task" record. I add tge attachment field type but it only lets me upload one attachment. How can I do to have more than one and, in addition to this, to be able to add attachments in different days or in different ocasions. Thanks!------------------------------Francisco Ojeda------------------------------
Hi, I am starting my new application for project management. My application is needed to follow the different stages of the project and to assign the job/project to each worker depending on the stage. I have different work areas with different stages of the job for each one. Actually, they use the KanBan view in other application to do this. How do you recomend me to do this? It is possible to make only one field of stage that contains all the stages of all of the areas or how you would recomend me to do this? I need help for best practices! Thanks!------------------------------Francisco Ojeda------------------------------
I have an address field (which really has Lat/Long coordinates), which is clickable to a google maps when viewing the record. However, in a table report it is not a hyperlink. How would I create a custom Rich Text hyperlink to open the google maps location, like it does when viewing the record?------------------------------Mike Tamoush------------------------------
We are creating an app that is intended to track various types of presentations given by our employees. Each presentation can have multiple presenters and multiple reviewers, but also the same person may present/review multiple other presentations. It's a classic many-to-many relationship scenario, but I am not sure the usual intermediate join table is the correct approach for our current challenge. We have an Employee List table and a Presentations table. For any given presentation, we would like to have a multi-select field fed from the Employee List to select all applicable presenters, and a similar multi-select field for reviewers. Each person should then have the presentation "assigned" to them and be visible on the Employee List record, preferably as a child table or similar report link. On the Presentations table, we'd then like to have each name link to the applicable Employee record as if it's the reference field, but with multiple names in the same field. I know I coul
Hello Australia/New Zealand Qrew! If you were not at the meeting, I wanted to let you know that this was our very last Quickbase-led customer network Qrew today. We are transitioning the Australian/New Zealand network to be community-led instead. Josh Hamilton has stepped up to be the Qrew Champion for the group! Please reach out and congratulate him on his new position! He will be posting updates and use cases within the Qrew Discussions moving forward. A couple of things I am doing some research on and will update here in the future: 1) The G2 Review $25 Amazon Gift Card Opportunity: I am checking to see if international customers will be able to receive the gift card in exchange for their feedback. Will let you know more about that soon. 2) I am checking if the $5 Use case Survey from Quickbase Marketing will allow international customers to participate as well. We'll have to check if the incentives can be converted and distributed internationally. If you have any questions o
Anyone else have broken conditional dropdowns on the new forms after this update today? Or am I the problem?------------------------------Dwight Munson------------------------------
I want to create a survey with a ranking question. My first thought is to use a multi-select checkbox that users enter a ranking number system 1,2,3,4,5 in the checkbox. Is this possible or is there another way to create a ranking question?------------------------------Jennifer L.------------------------------
Does anyone know if there is a setting to enforce the height of a rich-text element on the view mobile form? I have a use case to display a rich-text table displaying children data - but the element actual form element on mobile is small and auto-scrolls for a larger list, but only when in View. VIEW FORM: EDIT FORM: The goal is to have the element stretch without the y-scroll enabled in both settings.. ------------------------------Chayce Duncan------------------------------
You have a Magic Wand. It's an incredibly specific magic wand and it only has one special power: it can magically change Quickbase and add (or enhance) one feature. What feature are you adding/improving and why? How do you go about using Quickbase today without this functionality?------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
Hello, I have a field that imports in the following manner every single time with no variation to the format: [statement_dates] = 20230731-20230814 My question is, how do I split this up into: [Date one] = 20230731 [Date two] = 20230814 These would also be recognized as dates by QuickBase Thank you in advance ------------------------------QuickBase Administrator2------------------------------
I have a field labeled METs. Every record has a different number in there as it goes to the 100th decimal (i.e. 10.25) I want a report that groups them into <8.00 , 8.00-10.00, 10.00-12.00 , and >12.00. What fromula do I need to group the records into these four ranges?------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.