Post Webhook External
I'm trying to post a Webhook into a CTMS and it's out of scope for QuickBase to help with. The documentation doesn't provide any info on posting Webhooks externally. This is the instructions that our CTMS vendor provided: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:clin="URL"><soapenv:Header/> <soapenv:Body> <clin:SubmitSurvey> <!--Optional:--> <clin:strSubmission> <![CDATA[ <submission> <firstname> </firstname> <lastname> </lastname> <gender></gender> <dob></dob> <address1></address1> <address2></address2> <city> </city> <state> </state> <zip></zip> <phone></phone> <email></email> <besttimetocall></besttimetocall> <howdidyouhearaboutus></howdidyouhearaboutus> <comments></comments> </submission> ]]> </clin:strSubmission> <clin:strSecret>PASSWORD</clin:strSecret> </clin:SubmitSurvey> </soapenv:Body> </soapenv:Envelope> The validator on our (CTMS Vendors) end does not like capitals, spaces or special characters. I plugged their info in like this and many other variations of this, but am failing: Can QuickBase send XML formatted submissions in a SOAP message externally?
API Do Query No data Recieved
Hi, I have recently started facing this issue with my API call that I do from Alteryx to pull data from Quickbase table. I was working fine until last week Aug 1st, 2025 , but started to give no data then. I have provided the warning message that i get with Http 400 bad request error. Surprisingly there are other tables in my app that use the same headers and configurations (filters in query) which continue to work fine. I am unable to understand what to troubleshoot here. Do you have any guidance or setting that I could check? As a work around I tweaked the query a little bit removing filters adding number limits and then it works but that query cannot sustain for long. Please help. [Warning: Download (390): No data received from "https://******.quickbase.com/db/btdwv2ucy?a=API_DoQuery&query={'26'.XCT.'Complete'}AND{'26'.XCT.'Completed-Manual'}AND{'26'.XCT.'Closed Denied'}&clist=6.7.8.9.10.11.13.14.15.16.26.27.31.34.36.37.38.39.40.41.45.46.47&apptoken=**********66dxqt544&usertoken=************6av4c4wecdtcnjh4qbdf6gk5p"; Check the headers for details.]Client Portal With Userids
Are there any tips out there of how to let a user sign in without the Quickbase branding screen. I have a situation where customers will be logging into a supplier Quickbase app, with proper userids. But we want to suppress all the Quickbase branding on that page. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com [email protected] ------------------------------
Script a button to print current record to DYMO
I'm finally moving a product pricing process from EXCEL into QB. The last step is giving a user(s) the ability to print product labels from QB to a local DYMO printer. What I had envisioned was a button on the record form that would take a half dozen or so values in the record and push them as values for the label. Has anyone here done this already? If so, are you willing to share any of your scripting? My JavaScript experience is extremely limited. This link is an example of printing to a DYMO via a JavaScript library, but I don't really understand how to set the values of QB fields as the values to send to the printer. http://developers.dymo.com/2010/06/02/dymo-label-framework-javascript-library-samples-print-a-label/ Any help would be greatly appreciated.
Formula Rich Text Button - File to Add Record
Hi, I'm using a formula rich text button to add record in a different table when click. The button includes the action of copying multiple field values into the newly added record. I have one field that is a file upload field and need to copy this file into the corresponding field on the newly added record as well. Can this be done in the rich text formula? If not, how might you do this? Example: Approval Record: Name Date Amount JPG (image of the agreed terms) When clicking 'Approve' button, a new Transaction Record is created with all of the approved info: Name Date Amount JPG (***Need to duplicate this file to the newly created record) Thank You! Chris ------------------------------ Chris ------------------------------Create a button that gets the UserID for the user in a user field and then write that information to a field in the same record
Hello Quick Base Community. I am wanting to get the UserID for a user with the click of a button. Using the API_GetUserInfo, I can pull the UserID, copy it and then paste it somewhere, but what I would like to do is click a button that will get the UserID and then write it to a field in the record that I am on. Really the question is, is it possible to call an api and then perform an action using data that is returned from the initial api call? I assume that this wouldn't be a problem using scripting but I would like to know if it is possible natively within Quick Base. Thanks!
URL button to add new record and then go to that record
Hi everyone, I feel really silly asking this, but I can't figure out how to use a URL button to add a new record and then simply go to the newly added record. This is what I have currently. And, the only reason I'm using API_AddRecord instead of API_GenAddRecordForm is because I can't get it to set field 18 to what I want, but for whatever reason it does work with AddRecord. URLRoot() & "db/" & [_DBID_CREW_TIME_RECORDS] & "?a=API_AddRecord" & "&_fid_18=" & Now() & "&apptoken=cynqae3bygzqysbuufhnqczijtxn" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()) Thank you! ------------------------------ Elena Larrabee ------------------------------
distance between two addresses
I am trying to calculate the distance between two addresses. I put the below formula in but came up with a distance of 5000 and it should be 3. var number OriginLat = [LatitudeVendor]; var number OriginLong = [LongitudeVendor]; var number DestLat = [LatitudePlant]; var number DestLong = [LongitudePlant]; var number Distance = Round(((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5); If($OriginLat =0 or $DestLat=0,0,$Distance) ------------------------------ Sarah Burres ------------------------------
