Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Good Morning, I hope everyone had a great Thanksgiving! Wondering if anyone off the top of their head can answer my question regarding filters in the report settings. In this case, I am filtering out multiple values for one field; is it possible to easily combine all of these values into one single filter or do I have to continue to list them repeatedly one by one? I could have swore there was some way to string this together in the box using <> or something similar. Screenshot for reference. ------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 248-202-9587------------------------------
I'm working with two tables, a Parts Task table (parent), and a Task Activities table (child). Each activity represents a part number shipped from a specific location, e.g. MISC-1-A10, MISC-1-A20, etc. Here are the steps, via a Pipeline, I'm trying to achieve but I'm stuck on step D: When the shipping task is completed the Pipeline is triggered. Create a new receiving task from the completed shipping task in step A. Search for all related activities for the task in step A. For each activity I would normally create a copy from step C and append that to the task created in step B, but in this case, I want to create one combined activity for all activities with the same part number and combine their 'Quantity Shipped'. In the attached image, you'll see we have three line items for '2525…., Fake Part'. With a combined 'Quantity Shipped' of 10. I'd like to merge all three line items into one receiving activity of 10 shipped. Is there a way to do this wit
I have an app that is open to "Everyone on The Internet" where anyone can submit a parent record with child records associated to that parent. How do I create a pipeline or automation to push that parent record along with the child records into another app? I can create an automation to push each individually but I cant get the child records to relate to the parent record once they are in the new app because the record ID of the parent in the new app is different than the original record ID from the app it was created in. Any help would be appreciated.------------------------------Elazar Hamel------------------------------
Hello, Is there a way to configure the message that is seen/accessed by people who are requesting the app? The issue I'm having is the generic message of "could you please grant me access to the application" displays and not everyone types into this box to provide relevant info - for example what their job title is so I know what access to give them. I would like to change this message to have them fill in their job title or other pertinent info with their request. ------------------------------LB------------------------------
I am creating a check out/in process for assets coming and going from an inventory yard. Personnel will use the check out/in form to track the movement of the assets. Part of the process is logging the time of the check out/in. I was hoping to have the time automatically filled when the check box for check out was marked as true. However I am noticing if I use the formula if([Check Out]=True,now()), it constantly updates the time if i visit the form again and it updates the field everywhere it is used. Is it possible to lock down the time the first time the check out box is marked as true on the specific record I am editing? Thanks so much!------------------------------Bailey Desormeaux------------------------------
How to remove first column (edit / view) for embedded report in exact form. I am using this ~=qdb.GetURL("bhjz7apud", "API_GenResultsTable^query={'13'.EX.'"+field["Record ID#"]+"'}^clist=6.10.14.26^opts=nos.ned.nvw.");~ for embedding the report. But my problem is one empty column is appearing on left side.Please help
Is there an option to show each child record as its own form within a parent form? I know I can embed/link the records to via a report, but my child data set contains a ton of fields that cause the user to have to scroll to see them all. Was thinking that if each child record was on its own form, users could just use directional icons to move through each child record. Displaying on a form would also allow me to take advantage of form formatting to break the fields up to make them easier to read.------------------------------Ember------------------------------
Hello, Right now we have a text field for lat/long and would like to force users to only being able to put lat/long in decimal degrees instead of degrees, min and seconds. We are also open to just some sort of message displaying if they put it in the wrong format. We would like the field to remain a text field and not a numeric one.
Hello everyone! Hoping this awesome community can help me out, I'm trying to develope an integration between my Quickbase app and a external application called Fluig. For this propuse, a dataset was developed to receive the data that we now include in quickbase so that it is also automatically included in the other platform. To achieve this purpose, a request model based on an XML Soap envelope was developed by this third party company towards an endpoint based from an external WSDL. My question is: is it possible to make requests and transmissions of XML-type data in a Soap envelope through the channels available in the Quickbase pipelines module or through the conventionals APIs? How should i start? And, additionaly, it will be possible to referenciate one specfic tag of the expected response of the xml? Bellow and excerpt exemple of my soap envelope model: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.workflow.ecm.technolog
Hey all: I have been trying to use the app "Application Analyzer" which Ryan Pflederer demonstrated i n 2020 and continues to maintain. The challenge that I am having is I can't get the YAML to import. I keep getting an authorization error. I followed all of of Ryan's "additonal setup" steps but just can figure it out. I opened a case but its been slow getting a response. I am thinking it is an app token vs user token thing, but just not sure... Anyone else struggle with getting the YAML imported for the pipeline in the application? This app already has been a timesaver but it will be a lifesaver if I can get the pipeline portion to work. ------------------------------Melissa Freel------------------------------
Can QB provide a critical path for a project?------------------------------Kingsly Samuel------------------------------
Hello, I have tables in 2 different apps that I need to connect somehow. Basically, I would like one field from Table B to show up in a report for Table A. Both tables are in separate apps, but do have one field that is the same. Table A: I would like the "Sq Ft by PI" field from Table B to show up here in this report. Table B: Both tables have a "Contact PI/Project Manager" field that I am hoping could be the link. Does this make sense? Help would be greatly appreciated!Thanks,Meag------------------------------Meagan McOlin------------------------------
Is it possible to re-order the list in a multi-choice text field? I have a list of about 25 items. Some are no longer used but deleting them would cause an issue in other places. What I would like to do is re-order the list putting only the used ones at the top. Is this possible without messing things up? It seemed to be ok in a sample app but it is not nearly as massive as the app that is in use. ------------------------------Tara Houser------------------------------
Hello, I'm having an issue adding a lookup field to my pipeline. I want to update my current records when a criteria is met and then create a copy of the records. So I set up my pipeline like this: Search records when a specific query is met Then update the records Then create new records The first 2 steps work fine. However, on the third step, I'm able to set values from step one into the new fields created in step 3 but the site ID field does not show up. The Site ID field is a lookup field from a relating table. This field is very necessary because it is used to populate data in some of the other calculated fields in the form. So when I copy the records, this field has to be there. Just wondering if anyone has found a work around.------------------------------Shalom------------------------------
Hello friends, question about a field that used to work for me but no longer does. In one form, one field will either be blank or have a number in it, we'll call it "tag number". If "tag number" is blank, I set up a checkbox to check. If "tag number" is filled out, then the checkbox will not check. the formula I used that used to work was Checkbox-formula if([tag number]=null, true, false Am I doing something wrong? The box is not showing checked when I leave the Name field blank. When I use If(IsNull([tag number]), false, true) It checks whether it is blank or not Help ------------------------------Nicole Cordeiro------------------------------
I was wondering if there is anyway when I add a user, that the user could also be automatically added to a table?The reason I would want this, is that I'm bad about remember to add the new user to my user table. Because QuickBase won't allow you to use a users role in reports, I had to create a duplicate user table.Thanks,Carol------------------------------Carol Mcconnell------------------------------
Hi All, I hope this is an easy fix. I have downloaded the file manager plugin, it works fine on web version, but i have no ability to use the plugin when i login on my iphone. There is simply a large rectangle that says Qb Plugin-Launch File Manager but there is no "Upload Files" button. Does anyone know why this might happen? Thanks so much! ------------------------------Bailey Desormeaux------------------------------
Hello, I'm wondering if it's possible to copy a field value into a new field when a form is saved. So basically, a person makes a change to a form, saves it and their score changes from 5 to 6, I want to copy the old value ( which is 5 ) into a new field which I created and added to the form so the user can easily see that their score has changed and compare values. I can't think of any way or any formula to do this Just for context, I'm using the new form builder. I've done some research online and all I could find was the possibility of using a pipeline. But i would prefer not to use a pipeline. Ideally, the data would change on the form once its saved. If it's not possible to do it without a pipeline then I'd really appreciate if someone walks me through the steps. ------------------------------Shalom------------------------------
Hey folks - Sharing a win for future generations - I use Jotforms on the website to gather simple form data...but their webhook payload is in multipart/form-type rather than JSON. Had to take a couple steps to make it usable. Getting the Submission ID Their API lets you call form data and get a JSON response if you know the submission ID. After resetting up the incoming webhook, fetch JSON using the following: {% set data = a.body %} {% set start = data.find('name="submissionID"') + 20 %} {% set end = data.find('-', start) %} {% set submission_id = data[start:end]|trim %} This parses through the lengthy multipart/formdata content, searching for SubmissionID, pulling the data, and trimming any extra spaces for safety. A bit of a fragile solution because it really depends on JotForm not changing their wording, but works well enough. The api URL I can call then looks like: https://api.jotform.com/submission/{{submission_id}}?apiKey= Getting the file I have a fil
I have a table where i concatnated a date for the release date YY.MM. They want that date to show in the header. How do i go about just showing that date in the header. When i go to put the date in, it doesnt give that field option. Is this not doable due to it being added by add button and that field is housed somewhere else?------------------------------Kari Lang------------------------------
Hello, I'm needing help to solution a rule/way to make sure that 2 records related to the parent record can't be saved with the same date in a date field. Thanks, LB------------------------------LB------------------------------
I have several tables and pipelines that work together to Create Outlook meetings, and pipelines that can Update the linked Outlook meeting, or Delete the linked Outlook meeting. I'm struggling to get the Delete pipeline to work after the Update pipeline has previously been run on the meeting. The input/output does not populate, so no insights there: The Delete pipeline does work on Outlook meetings that were not Updated, so I suspect that the issue is with the link between the records. I have tried all of the options for the Link that occurs after the Update pipeline, but those changes haven't seemed to fix the issue: Can anyone point me in the right direction? Thank you!------------------------------Carlie Maheurin------------------------------
Hello, Can you assist me in figuring out how to automatically copy records with a specific value (e.g., "new") on a particular day (e.g., every Friday) to another table? Thank you.------------------------------Costin Angelescu------------------------------
Does anyone know the correct syntax to have a webhook run a T2T import? I know i can do it with a pipeline, but webhooks fire so much faster I would like to do that if possible. ------------------------------Mike Tamoush------------------------------
I've recently been experiencing what are called "app load timeouts", where I will open one of my apps and rather than loading (even if it takes a few seconds), I instead get an error message or something like, "App waiting to load." In order to actually get the app to load, I need to either refresh my page or click on the app title link in the top-left. Although the page never loads if I simply wait, it will load immediately when I prompt a refresh. I inquired with Customer Support and they explained that this is something new, implemented on the back end to improve overall performance with the site. While I'm all for performance improvements, this idea that I now have to load my apps twice every single time I want to access them seems like a pretty big step backwards from a user interaction standpoint. It was also pointed out to me, and I have heard various discussions about this over the past year or two, that I need to "optimize" my apps. However it doesn't seem like Qui
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.