Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi I have an XML file that contains stock levels that I want to import into a QB table via a webhook The XML looks something like this: <DSV_WHSInventory> <HEAD> <Message_Id>20230824010117</Message_Id> <Date_Time>20230824010117</Date_Time> <Message_Type>INVRPT</Message_Type> <Message_Version>0200</Message_Version> <Sender_Id>DSV_WMS_RP02</Sender_Id> <Sender_Company>DSV Solutions</Sender_Company> <Recipient_Id>ZAGOSOLR</Recipient_Id> <Recipient_Company>ZAGOSOLR</Recipient_Company> </HEAD> <Inventory> <Dstamp>20230824010117</Dstamp> <InventoryCount> <Client_Id>ZAGOSOLR</Client_Id> <Sku_Id>006</Sku_Id> <Site_Id>ZAGOSOLR
I have an address field and when i add it to a form, the zip is before the state. Is there a way to change that?------------------------------Carol Mcconnell------------------------------
How do I easily change this formula from [Task Phase] = "xxx", "000" to [Task Phase] contains If([Task Phase]="Office-Start","000",[Task Phase]="Pre-Start","001",[Task Phase]="Pre-Hang","002",[Task Phase]="Drywall","01")------------------------------BuildPro------------------------------
I have data with some 4,000 records, which I imported on QuickBase and created two tables sharing the parent-child relationship from one spreadsheet. The spreadsheet has several entries with the same ID, so there is no unique identifier for each record in the spreadsheet. On QuickBase, I have established a parent-child relationship. Hence, the parent table has a unique identifier, and the child has multiple records of a single ID in the parent record. The data gets updated every month, and there is a new spreadsheet every month that will have some updates in the existing data records and some new forms. Can I find new records and updates in the existing records in the spreadsheet and import the updated data into two different tables that I have on QuickBase?------------------------------Chaitali Damani------------------------------
Some pipelines all of the sudden stopped working for certain tables last month. Support said it's due to a mixed encoding issue and that I'd have to run the Mixed Encoding Scanner. It uncovered over 5,700 rows with issues across dozens of fields - trademark symbols, curly single quote characters, and other basic characters tripping the errors. I don't have the ability to manually fix these or even do find/replace on each table/field. Is there any way around this? This seems crazy that the platform cannot support a trademark symbol.------------------------------Matt Makris------------------------------
Hi, I'm trying to get "List All" data of a table and then later of all tables available through Quickbase HTTP API. I cannot use the JSON RESTful API as that doesn't have a way to authenticate using username and password but directly with user token, which I do not want to use.Can someone help me get this data through Quickbase HTTP documentation?------------------------------Praharsha K------------------------------
Hello all, I have a summary report that tracks weekly pageviews for page categories.Here's a screenshot of the report settings I've customized: Every daily pageview metric is a separate record in the table.How do I sort the summary table by the total column from highest to lowest?------------------------------Frontman------------------------------
HiI have created a pipeline where the data is pulled from a CSV file but I'm not able to pull the data from xlsx by using the pipeline do you have any solution for this issue? ------------------------------Venkata krishnakanth Pittala------------------------------
I have the need to create a count of child records that are not a direct child of a parent table. in this situation I have a Parent table has Child 1, but has two tables under Child 1 that are not directly associated to the first Parent. I can do a summary total of those records and look them all the way back up to the Parent. The issue is the count is correct but when you click on the number to see the records, it pulls the count and records of the first Parent/Child relationship.------------------------------Zint Joseph------------------------------
I am experiencing difficulty connecting to QuickBase from Power BI service. I was able to establish a connection using Power BI Desktop, and the refresh was successful. However, when I attempted to refresh from the service side, it prompted me to edit my credentials.Upon entering the token I used in Power BI Desktop, it consistently fails. What should I do?------------------------------Kerubel Gebreyes------------------------------
SQL to get Employee Name Fields (F,M,L Names) using Email Field in Extensions Table. The Extensions form is being redone in the New Forms. I see that the first field is called Related Employee, which is just blank in all records. I would like to add the employee name which is in First Name, Middle Name & Last Name (3 fields) in the HR-Employees table. There is no relationship between the HR-Employees table & Extensions table. I would like to replace the 'Related Employee' field which doesn't appear to be pulling any information as all the data in all the records for this field are blank. I could create a relationship. I would like to do this with SQL, which is a new feature I believe. There just a lot of table relationships in the app that I think it would be cleaner to just relate the data SQL, but I am can't find the formula? ------------------------------Bob T.------------------------------
Has someone figured out how to print a New Form ? there is no print button and the a=printr in the URL doesn't works here------------------------------Felipe Garza------------------------------
See attached, Reading results and signaure read INvalid when no selection is made in the field associated. Can I have it so it is just blank if no selection is made and fills in when one is? Example: Patient receives this form and it should be blank so someone can fill it out and fax it back to us. However sometimes our employees fill it out electrronically so in that case I want it to be filled in with our employees info. SO I want it blank when not fille dout but pull the field selection when it is. Code for that section is as follows <div class="col-3 bold underline">PPD TEST</div> <div class="col-3 ">LOT # {{$ctrl.ppdLot}}</div> <div class="col-6">EXP # {{$ctrl.ppdExp}}</div> <div class="col-3">TB(PPD) Administered by: </div><div class="col-2">Left Arm <span ng-show="$ctrl.ppdArm === 'Left Arm'">&#x2713</span> </div> <div c
I'm currently working to develop on the Gantt Plugin Template. I'm experiencing an issue that I cannot figure out at all. When I go to the viewing of the Gantt chart, it's completely blank. I have a number of tasks that are in the plugin and I can see them. They were there in the Gantt chart when I was building the tasks, but are no longer visible. This happened as soon as I saved the project from inside the chart. I'm totally lost. Any assistance is greatly appreciated. Gantt Chart page Task List ------------------------------Sam Nolette------------------------------
Hello - Wondering if there are other users of Microsoft SQL Server who might be interested in a simple set of SSIS components (connection manager, data source, and data destination)?I realize there's a commercial ODBC driver out there (which looks great), but I found myself in an odd situation where, for specific reasons, buying software is off the table, but investing time is OK.I've already got some basic stuff working and my intent is to polish it up enough to be useful without needing to know the API:Connection manager for attachingData source for queryingData destination for writing back(No generalized ODBC like integration where you can do mass deletes)For the data source I'm also going to add something I've found useful on other projects, which is emitting "maybe kinda close enough DDL" for generating your target tables (it just abuses SMO). I've already got this working and it applies some basic rules (sanitizing column names, prefacing the individual address fields with t
Hello - On a dashboard I have several reports added. The right most report is a table report with two columns. On my monitor I am able to see all the info when at 100% zoom. On my laptop screen, it gets cut off with a scroll bar. I understand it is the size difference, but the issue is if I scroll to the right in the report it does not actually scroll the report so it does not display the second column at all. Playing around with zoom on the screen I've figured out it is functioning as if (in excel) i froze the first column, so the first column does not scroll but the second does. so (on my laptop) in order to see the full report I have to zoom out to 50%. Any idea why this is happening or how to fix since I assume a majority of users will be only on a laptop screen at one point or another and viewing way zoomed out is not ideal.------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi, I am trying to build a solution, which would have 2 related tables- Assembly & Parts User can be calculating cost for either Part ( individually) or for an Assembly( rolled up cost of all parts linked to the assembly). I am unable to expand the Assembly selected into further Parts. Is there any way I can have the data expanded into multiple levels and then get a summarised/rolled up cost value ? Is there any sample/example available for this use case ?Thanks in advance !------------------------------Namratha N------------------------------
Hi, I have two tables called Keyperson and Startup. Keyperson is the parent table here and Startup is the child table with one to many relationships. I want to add a key person detail from the Startup table (i.e. In Form) without displaying other key person details in the lookup field. Is there a way to do that? Thanks. ------------------------------Prakash Murali------------------------------
Hi, I am not familiar with Jinjia. I am trying to generate several child records by using Pipeline. The 1st child will get a date "9/21/2023", 2nd one will get "9/22/2023", and so on. However, it always give the value "9/21/2023" for all the children. This is my Jinjia code: { "to": "btib9aemmh", "data": [ {% set adate=time.today%} {% for num in range(5) %} {% set adate=adate+time.delta(days=1)%} { "7": { "value": "{{a.id}}" }, "18": { "value": "{{adate|date_ymd}}" } } {% if loop.last == false %}, &nb
I am working on a mobile version of an app and have run into an issue with tables and not having the option to add new. I have a table (Refrigerants) and three other tables setup as Refrigerants have many racks, many cases and many coils. When I am adding a new record in any of these tables and select the refrigerant dropdown, I see no option to add new. Is this a limitation of mobile or do I need to setup these fields a different way. ------------------------------Zint Joseph------------------------------
Hello, I am trying to build a "reminder" notification in Quickbase. Basically, if it has been 15 days since the form was created and the submitted date hasn't been filled, I want a notification to go out. My question is will leaving the date field blank work for the condition and once it is filled, that means that the condition will not be met? Picture below for reference: ------------------------------Cassandra Friend------------------------------
I've been using QB for ten years for our company's quoting system. We're at a point where we need to decide about upgrading to a CPQ (configure/price/quote) app, for accuracy and integration with our ERP. I searched this form and exactly one reference to CPQ. My experience with QB imagines all things are possible, but CPQ can be complex and I'm not sure if buiding something from scratch is the right answer. Specifically on my mind, as a builder, I am not experienced in making rules that a configurator would require, where the conflict of daughter items is resolved (can't buy tinting if a window isn't included). I have a few times I've done something like that, but feels like a work-around, and would be core to CPQ. Especially when the user changes their mind about which items they want. Anyway, just looking for some feedback, from the community about this, thanks.------------------------------David Jung------------------------------
Hey all, has anyone else encountered this? I'm using a rich text button to (among other things) add and display a new record in one fell swoop. However, I cannot get it to respect my &ifv=10 settings, it's still pulling up the new record in a form with full QB branding and navigation. var text NewTimeSheet = URLRoot() & "db/" & [_DBID_CREW_TIME_RECORDS] & "?act=API_AddRecord"& "&apptoken=XXXXXX"& "&_fid_37=" & [Record ID#]& "&ifv=10"& "&disprec=1"; #APIsandcustomcode #api_addrecord ------------------------------Elena Larrabee------------------------------
I'm getting this error on a few specific tables within my application when I try to reference them in a pipeline. I get an error message - "Quickbase Reported an Error - No Error" and then when I try to select fields from the "fields" drop down I get the yellow dot that states not all the options could be displayed. I have tried reconnecting and a new user token with no luck. This is not happening to all tables in the app, only a few. We did just transfer the app from one realm to another. But I have severed all cross-realm relationships in these tables. So, I'm not sure what else it could be.... anyone experience this before?------------------------------Skye Ellis------------------------------
I would like to do a JSON API integration in Csharp. I have downloaded the OAS file and imported it into the swagger editor, then generated the csharp client code. However when I try to build my dotnet project I get lots of errors, mainly: Generated5.cs(31, 58): [CS1031] Type expected And indeed it has generated code such as: public async Task<List<Dictionary<string, >>> GetTables() Is there a recommended generator to use or is there a csharp client code already generated that I can use?------------------------------Oliver Polden------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.