Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi, I am trying to migrate automation to pipelines but getting error as attached. Anyone help me in resolving this issue. Regards, Ravi ------------------------------Ravi Siddana------------------------------
Wondering if anyone has run into anything similar - I want to add an API AddRecord with a Formula URL that would eventually copy some information. I was getting no errors, nothing, and eventually started stripping the formula down to the minimum requirements. With only the three required fields, I started getting error code 50, specifically mentioning one of the three fields <qdbapi> <action>API_AddRecord</action> <errcode>50</errcode> <errtext>Missing required value</errtext> <errdetail>Sorry, you did not supply a value for the required field named "Payment Source" with field id 46. Please provide a non-blank value for this field.</errdetail> </qdbapi> This is despite the fact fid 46 does have a value URLRoot() & "db/" & [_DBID_runs] & "?act=API_AddRecord&apptoken=REPLACED-FOR-SECURITY" & "_fid_199=" & URLEncode("Accept") & "_fid_70=" & URLEncode("Coding") & "_fid_46=
How can I select the first result found in a query with multiple results? In the example below, the 'Correct Hauler Name' column is a query that searches for values containing: {#Column Number# .CT. [Hauler]} within the .I get Multiple values in the column 'Correct Hauler Name', I need only the first value the query founds.------------------------------Cristian Carrion------------------------------
Can I use a Report Formula to change the Display name of a field in that report?For instance, if the Field Name is Current Funding Round Forecasted Remaining Balance (LOL!) and I'd just like it to say "forecasted balance" on this one report can I use the Report Formulas section to do that?------------------------------Renee Hansen------------------------------
Well, Bob, if I COULD make it fold laundry... We've all had them. A user is so excited to tell you their idea and then BAM! Umm..I'm sorry, you want it to do what?? What's the most outrageous request you've ever gotten from a user? And what happened?!?------------------------------Blake HarrisonSystems Analyst / Quickbase DeveloperBCF Partners CapitalHouston TX------------------------------
Boy, if I had a nickel... Volunteered or Volun-"told", people start working in Quickbase in every kind of way. How did YOU get your start down the rabbit hole?! ------------------------------Blake HarrisonSystems Analyst / Quickbase DeveloperBCF Partners CapitalHouston TX------------------------------
Working from home can be great, but where do you go when you REALLY want to get away?!------------------------------Blake HarrisonSystems Analyst / Quickbase DeveloperBCF Partners CapitalHouston TX------------------------------
👋 Hey Houston Quickbase Enthusiasts! 👋 Welcome to our brand-new Houston Qrew, the go-to spot for all things Quickbase in the H-Town area! 🚀 We're stoked you're here and can't wait to dive into some awesome Quickbase convos with y'all. Whether you're a seasoned pro or a Quickbase newbie, there's something here for everyone. 🎉 Let's Break the Ice! 🎉 To kick things off, we've got some icebreaker questions lined up. Head over to the discussions to share your thoughts: What's your favorite spot to work outside the office? ☕🌳 How did you get your start as a Quickbase user? 💡🛠️ Most over-the-top request from a user? 😲🤯 📣 Call to Action 📣 Join the Group: If you haven't already, hit that 'Join' button and become an official member! 🤝 Save the Date: Mark your calendars for October 26th! We're hosting an in-person meetup, and trust us, you won't want to miss it! 📅🎉 Spread the Word: Know other Quickbase users in the greater Houston area? Invite them to join the fun! 🗣️📣 Let
I am trying to transition from legacy form to new form. My legacy form includes a report with Record Picker that looks like the ss below. But I don't get an option to add this to new form. Do I actually have to create a whole new report replicating the Record Picker to use it in new form? ------------------------------sanad dhital------------------------------
I've created a formula (thanks to the help from this community) that gives me a tally of the number of times a specific record has been modified. This works perfectly. However, I'd like to break this count down by user. For example, if a record was modified 4 times, I'd like to see that John Smith modified it twice and Jane Smith modified it twice. Any ideas? For reference, I've used the following formula to tally the modifications: Count(Part([Log Notes],2,"]"), Part([Log Notes],3,"]"),Part([Log Notes],4,"]"),Part([Log Notes],5,"]"), Etc. ------------------------------Jesse T------------------------------
Hello everyone! Does anyone know the secret to being able to drag and drop a file attachment out of Quickbase to another program, such as, DocuSign. Instead of doing a Pipeline, which I know there is a channel, we just wanted to have the ability to drag and drop the file attachment. Or being able to download all file attachments in a record. Thanks in advance for any insight into this. ------------------------------Laura Linssenllinssen@jjkeller.com------------------------------
Is there a way to export a table to CSV using "Export Records to CSV" step under Bulk Record Sets QuickBase channel? ------------------------------shivani jain------------------------------
Hello all. I wonder if anybody could offer any advice on a problem i'm having please? I have set up an 'Fetch a JSON resource' in pipelines, which is to a third party ID check. Prior to the candidate completing the ID check I can fetch the JSON data and import it into QB through Pipelines. However, once the candidate completes the ID check the JSON contains considerably more fields and when I try to 'Fetch a JSON resource' I get a validation error. Validation error: Maximum JSON size exceeded Is there any way in which I can overcome this please? Here is an example of what is in the JSON. [ { "id": "e4x69a61-07mp-46le-aj80-0c52f12a673e", "data": { "pseudonym": "ANON-e2x0a6mp-37l0-42ps-94ef-u69755438d3o", "product_name": "Test Product", "status": "completed", "purchase_start_date": "2022-03-16T09:33:52Z", "purchase_completed_date": "2022-03-16T09:33:52Z",&nb
How can i identify that the last iteration of the Search step? On the last iteration, i would like it to stamp a field but I havent found a way to do this through jinja (at least in the way i want it) this works in getting me the highest record id (which is my default sort for the table): {% set highest = a|max(attribute="id") %}{{highest.id}} and i can use this in the look up step and find the last iteration of the loop, however, i would like to not have to do this part. on the for each after the Search step, i am trying this: {% set highest = a|max(attribute="id") %}{% if a.id == highest.id %} {{TRUE}}{% endif %} but i just keep getting a TypeError: 'Record' object is not iterable. does anyone happen to know how to stamp a field in a for each loop only when it is the last iteration of the loop? Thank you! ------------------------------Tim D------------------------------
Hello, Can a simple incremental row number be added to the report? Regardless of how the report is sorted, I want to see a record number starting from the top of the current sort order. Any help is greatly appreciated.------------------------------Sincerely,Sam Rozenfeld------------------------------
Hello! I have a Google Sheet. I want that when somebody adds a row to this Google Sheet, the Pipeline triggers a search of records in a QB table, matching values in the QB table to the value entered in the new GSheet row. Anyway, I'm having a bit of trouble getting the Pipeline to connect. I entered the spreadsheet and sheet IDs (which will be static) in the first two fields. Not sure what to put under Header row. My first row has A1: "Timestamp" and B1: "Email" and that's it so far. That's my header row, so what goes in the Pipeline step? When I put 1 (as shown in the image above), I get a message, "Internal error. Please contact support to investigate." Why can't Pipelines access the spreadsheet? I know my Google account has permissions (I created the spreadsheet).------------------------------Aaron Alpert------------------------------
I have two forms I want visible to Everyone on the Internet however the forms are within the same table. I'd like each form to be in add record mode only when the link to the form is selected and not via the dashboard. Thanks------------------------------Phelan Sanders------------------------------
I have a form setup with buttons that capture the current time on a button click. It works great using both a code page or just running the code in the URL formula field. But I've found an issue that I can't seem to find a solution for. Maybe it's with the code, or maybe it's something else entirely. I found this code in the Magic Buttons app and tweaked it a little for our purposes. var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=APP_TOKEN" & "&rid=" & [Record ID#] & "&_fid_62="&ToTimeOfDay(Now()); URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=56" & "&url=" & URLEncode($urlToExecute) -------------------------- I've also used this successfully without calling the code page; URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=APP_TOKEN" & "&rid=" & [Record ID#] & "&_fid_62="&ToTimeOfDay(Now()) -------------------------- The issue I'm ha
I am currently building a pipeline that uses a Webhook to make an API call into openweathermap.org and return a daily JSON file with that day's weather conditions. I then sort through the JSON file using some REGEX code to splice out the data that I want, and am attempting to file that data and build new entries in a Weather Table in one of my apps. I've done this same process with a different API call and had no issues. However, I am currently running into a problem when I try inputting the sorted data into my tables fields in the third step. I keep getting the following error.invalid literal for int() with base 10: 'WindSpeed'I have tried a myriad of different things including changing the table field from numeric, to text, to numeric currency. I have also tried using Jinja to transform my incoming data using {{b.WindSpeed|int}}, {{b.WindSpeed|float}}, {{b.WindSpeed|string}}. Has anyone else had this issue? Or have any other ideas of how to address this?--------------------
I'm getting a "variable declaration must be followed by a type" error and I cannot figure out how to fix it. This code was set up by a QB tech during a custom integration but I no longer have access to their assistance. Can anyone help me figure this one out? FORMULA: //collect a list of records from the bridge table for the assignee //that conflict with the chosen assignment's date var RecordsList Conflicts = GetRecords( //get records where the chosen staff is the same as the bridge record's related staff //38 = Assignment-Related Staff, 39 = Request - Related Staff "({38.EX."&[Related Staff]&"}OR{39.EX."&[Related Staff]&"})" & //filter the records where the Beginning Date on or before this record's Load Out Date (users ToDate func to convert to date only to accommodate date/time type field) //41 = Beginning Date "AND{41.OBF."& [Event - Load Out])&"}" & //filter the records where the Beginning Date is on or after this records Load In Date //42 =
Can you please tell me if I can delete an invoice? I started one and got kicked out of it, started another one and submitted it and now there are 2. One says "not submitted" and that is the incomplete one that I am trying to delete. Thanks in advance!------------------------------Christine LivingstonLanco Construction, Inc.------------------------------
I manage all my users via several groups, each of which is assigned a particular user role. Today I went to the 'manage groups' screen and clicked on a group to view its members, and was met with the message 'Error - Group not Found'. The same thing is happening for several other groups, but not all of them. However, the groups all still appear to exist, as my users are all still able to access my app and perform the tasks etc. which are assigned to them via the group they belong to. Email notifications which are sent to these groups are still being sent. I've logged out and logged back in, tried different browsers, cleared my cache - but the error message is still stubbornly showing up. Any ideas what to do about this?------------------------------Michelle L------------------------------
I'm trying to add a second crosstab but I can't seem to figure out how to do it. This what I currently have: Status Closed Open Pending Totals Provider - County - Liaison Region PR Assigned To Number of Number of Number of Number of Records Records Records Records This is what I want: Status Closed Open Pending Totals Record Type 1 Record Type 2 Record Type 1 Record Type 2 Record Type 1 Record Type 2 Provider - County - Liaison Region PR Assigned To Record Type Number of records Number of records Number of records Number of records Number of records Number of records Number of ------------------------------Carol Mcconnell------------------------------
Greetings, When going through records in a table one by one, you have the option to click Next or Return (or Prev if you're not on the first record). When you get to the last record, you can only click Prev or Return. Is there anyway to navigate directly to the first record when you get to the last record? I haven't found a way to do this and I'm thinking I may have to make my own custom buttons or a code page or something. I don't want users, for a particular table, to have to return to the default report and then click the first record to get back to the beginning (if possible). If someone has any input or suggestions for this, that would be greatly appreciated. Thank you in advance. James------------------------------James Carr------------------------------
Quickbase has always advertised itself as a Low-Code/No Code system. But with Pipelines, it seems that you have to be able to code to get it to do anything you want it to do.I loved Automations. I could build a pretty complicated one in like 5 minutes to do what I need it to do. After months of trying, and even trying to duplicate Migrated Automations, I have yet to successfully build a working functional Pipeline.On top of that, The migration tool does not always work with the Automations. I have multiple ones I have tried to migrate, and the tool fails everytime. So I literally have multiple jobs that the automations did every morning that I am having to physically do manually because I can't make a pipeline do it.And come to find out searching through this community, the migration tool was not set to correctly migrate Table to Table imports, so that has become another manual process.If someone has any options of how to create a pipeline to run a Table to Table import on a daily basi
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.