Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Greetings all,I've got a case where a client is trying to search a batch of records and perform the resulting actions on them in a particular order, based on a date field in those searched records. For example, let's say they have 5 sales orders with 5 different due dates - they want the search to pick up all 5 SOs but perform the following actions on the one with the earliest due date first, then run up the list in ascending date order.Melissa Doran's post in this thread works wonders for one-off grabs, but doesn't quite get what I need in this case. How have you all handled this thing in your development?Thanks!------------------------------VARC Solutions------------------------------
I have a JavaScript application which uses npm, Restful API, fetch API, and complex JSON parsing. When I go to add my application as a CodePage, I get an error. I have added my application as an attachment. Please help.------------------------------John Hajian------------------------------
Is it possible to have a pipeline triggered when new Page is created (rich-text page in this instance) and create a record in a table populating fields with the page's title, description, and URL?------------------------------Paul Easton------------------------------
I need to figure out a checkbox formula to check if a record was created within the first 5 days of the current month using [Date Created]. Any suggestions?------------------------------Dawn Rene------------------------------
Hello, Does anybody know a way to search records in pipelines for unique values? I have three tables - Projects, Boreholes, and Sections that are all related via Record ID. One Project has many Boreholes and many Sections, one Borehole has many Sections. We receive data in a spreadsheet of Sections metadata and I am trying to create a pipeline to check if the Project and/or Borehole exists, then add the Record ID to the Section if it does or create a new Project and/or Borehole if it doesn't. I set up the pipeline to be triggered when a record is created in Sections - Record Created -> Search Record -> If List of records is empty -> then Create Record, else Update Record. However, it appears pipelines work asynchronously. Meaning, it hasn't went through the create record step before it searches Projects and Boreholes again for the next Section record that was created - leading to multiple Projects and Boreholes records being created with the same name. My next thou
New to the forum. I searched but did not find anything existing for this specific error so here is my first post. I am trying to run a pipeline that takes a .csv file from a document table and creates new records in a second table from each entry in the .csv file. I am using Quickbase Channel->Bulk Record Sets->Import with CSV When I run the pipeline, I get the following error: Obviously this is a URL error but I don't understand why since the file/URL resides within the same app as this pipeline. Any help will be sincerely appreciated. v/r...Aaron ------------------------------Aaron Bab1692@att.com------------------------------
Hey Y'all! So, I have a form, and I want a button that is "submit for approval", in a form. When it's clicked, I want it to 1: select the "submit for approval" field and 2: save the form and display the newly created record in view mode. I got part one down with this URL Field code (from magic buttons): If([Submit For Approval] = false, URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxx" & "&_fid_40=1" & //this is the checkbox field "&saverecord=true" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]), URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=
In the old form builder with rules, you could use text like this to update fields. The Status was changed to [Status], and delivered date set to [Delivered Date] This does not work in the new form rules unless I am missing something. Thanks------------------------------Steve Laurel------------------------------
Using a quickbase pipeline I want to schedule a task that will search for all order records that were updated in the last 24h, then create json object with an array of all the orders in question. This json object should then be sent via a API call to that accepts a list of orders in json form. How would I setup this pipeline in quickbase Steps how I see it Search for the orders I want (filtered) Iterate through the records found and insert them into a json object Step a webhook referencing the external API that takes the json object constructed into the body External API to receive the json array for processing Any idea how I should do this? Thanks for the help------------------------------James van der Walt------------------------------
We have a database in Quickbase that stores records relating to patents.. We want to know if the following is feasible to do in Quickbase: . Create a temp table based on Json returned form peds (patents REST API) sort table run query for docs that Match doc codes you want to download and download them. We would like to know if this is possible. Thank you in advance. ------------------------------John Hajian------------------------------
Is there any way to remove the "manage support cases" link in the drop-down when you click on the help icon, based on role? We do not want most users to be able to submit support tickets with QuickBase. We would prefer that they submit issues via our internal ticketing system. I would like to hide the "manage support cases" link for everyone except those in certain roles. If it can't be done by role, than I would rather remove it all together. Is this possible? ------------------------------Paul Easton------------------------------
I know I have to be making this too hard. I need to have a field pull the current numeric value in field 31 from record #1 of an unrelated table. There is no need for any other kind of relationship here, I just need the field in the table I'm working from to know what value is currently in that other specific, constant. table/record/field. I've tried every search term combination I can think of and I'm coming up empty.------------------------------Amy Christensen------------------------------
The table only occupies 1/10 of my screen and it would be convenient to see more rules at once on my vertical monitor. ------------------------------Bob Jones------------------------------
Okay so I am a little rusty with HTML, but how do I pass information in this HTML code page? Code Page: <!DOCTYPE HTML><html><body> <script> const dbid = 'btadwgxn9'; <!-- NEED TO UPDATE THIS WITH YOUR TABLE DBID --> const apptoken = 'c2x3rt7dkx56hnh9ckac49b2tz'; <!-- NEED TO UPDATE THIS WITH YOUR APP TOKEN --> const xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if (this.readyState == 4 && this.status == 200) { const response = this.responseXML; const redirectUrl = "https://" + window.location.hostname + "/db/" + dbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent+"&rl=bbv"; location.href = redirectUrl; } }; &n
I created the webhook below to delete a file attachment when a checkbox is checked, but it only works for one record at a time. How do I modify this webhook so that it updates multiple records at a time when the checkbox is checked using grid edit? Thanks! API_EditRecord <qdbapi><udata>mydata</udata><ticket>auth_ticket</ticket><apptoken>app_token</apptoken><rid>[record_id]</rid><field fid="[field_id]" filename="delete"></field></qdbapi>------------------------------Alison------------------------------
Back to quickbase after a long period of inactivity. New to pipelines . Have managed to use some functionalities (bulk records and upsert) to import some text files and Google sheets) I want to: after de pipeline finishes processing, the user goes to a certain report or form to manually do some things Suppose I have to use a quickbase api call at the end of the pipeline (last step). Tested without success. Can anyone share the steps os url (generic) needed to achieve this , if this is possible? ------------------------------eduardo valdes------------------------------
Hello, I have been trying to mess around with this but have not fully figured it out. Is there a way that if someone clicked a button, I could then have is check a box that a checklist is started and then use dynamic form rules to only show that portion of the form? Next part of it would also include that once they click "Save & Close" that it then unchecks the box so that users can see the full form again. Is is possible to write logic around this functionality? ------------------------------Sarah Driscoll------------------------------
I am using the following formula in a text formula field to trim out just the value (which is a date) of a log edits text field. The formula is including the ------------ after the user name in the log field and I'd like to exclude them. Is there a way to do this? Trim(Right([my update field],"]")) Log Edits Field Value -- [JUL-03-23 Rachel Miller] --------------06-30-2023 Formula Field Results --------------06-30-2023 ------------------------------Rachel Miller------------------------------
anyone know what might be wrong with this text formula? The formula works for 4 variable line items of characters but not this many. The error is pointing at the Pipe character variable. Is there a limit?: var text brackleft=SearchAndReplace([Project Name],"(",""); var text brackright=SearchAndReplace($brackleft,")",""); var text star=SearchAndReplace($brackright,"*",""); var text Tilde=SearchAndReplace($star,"~",""); var text Acute=SearchAndReplace($Tilde,"`",""); var text Exclamation=SearchAndReplace($Acute,"!",""); var text Asperand=SearchAndReplace($Exclamation,"@",""); var text hash=SearchAndReplace($Asperand,"#",""); var text Percent=SearchAndReplace($hash,"%",""); var text Degree=SearchAndReplace($Percent,"°",""); var text Caret=SearchAndReplace($Degree,"^",""); var text Ampersand=SearchAndReplace($Caret,"&",""); var text Plus=SearchAndReplace($Ampersand,"+",""); var text Equal=SearchAndReplace($Plus,"=",""); var text Openbrace=SearchAndReplace($Equal,"{",""); var text
I have 10 similar fields where the names are increasing the number at the end by 1. When sorting the field list "File 1" is followed by "File 10" rather than "File 2". How can I name the fields such that appear in proper order? ------------------------------Bob Jones------------------------------
Is it possible to create query that results in the maximum value for a set of records? I see SumValues and Size, but no Maximum.------------------------------George Bramhall------------------------------
I have a child table that I needed to hide the native UI save button on. This is an EOTI app and unfortunately, EOTI seems to have a hard time following the simple direction of using the drop-down option on the save button to hit save and next if they need to enter more than one record. So I have to make "save and new" and "save and close" two large obvious buttons... I am using this code "<a href='" & URLRoot() & "db/btcpg7sph?a=API_GenAddRecordForm&dfid=2&_fid_19=" & [Request - Name] & "&_fid_20=" & [Request - Order Number] & "'>\n <img src='https://expertclaimmanagement.quickbase.com/up/btegrvwjr/g/rb/eh/va/ADD%20NEXT%20ITEM.png' alt='Save & New'>\n</a>" I have double checked the field names and numbers and when I hit my button, the URL syntax is correct, it shows the Name and the correct Order Number. It just isn't generating in the form and because that is the field that actually links the record to the p
I'm not looking to create an actual family tree, it is just the closets example of what I am seeking. I have an application that collects information regarding the various parcels of land our company owns/manages. From time to time, these parcels are split and/or merged with other parcels to create new ones. Those new ones may again be split/merged to create yet another set of new ones. I'm looking for a way to somehow connect the dots between all these splits/merges so that if I look at a resulting parcel it will show me all the previous parcel records it used to be. My current set up is this. Parcels table - one record per parcel number which is unique. Transactions table - one record for each action (buy, sell, split/merge). T2P table - acts as the many-to-many intermediary table since a single transaction could apply to multiple parcels. Example scenario: Parcel A is split into B & C. All 3 are entered into the Parcels table as separate records. A
This is probably super elementary, but can someone help me make this work - please? Formula is in a Numeric field. ------------------------------Denis Rochat------------------------------
Good EveningI am trying to use Pipelines to connect QB to Azure for the purpose of dropping a CSV file on the server.I have sorted most of this however the OAuth 2 Credentials seems to be not working, I have never done this with Pipelines before so it is entirely possible that it's me that is doing something wrong. I am pretty sure that the 3 fields are filled out correctly (Client Credentials, Client Secret & Token URL). My question is this:When you fill in the data should you get the access token returned automatically or do you need to use a GET command?? If it is the later please can you cut/paste a screenshot or add an example as it seems that the data I am adding is not returning the token.Many ThanksPaul------------------------------Paul Paul------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.