Connect

Meet others in the Qrew, see how they use Quickbase.

Qrew Groups

Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!

Quickbase Discussions

A forum for Qrew members of all levels, where questions about Quickbase can be asked and answered.

Job Board

A space to post and find jobs related to Quickbase expertise.

Recent Discussions

Nesting API Button Help (Add record and update another)
I have 4 tables I'm working with: License Master (parent table) Pending Locations (parent table Suggested Licenses (a child (many to many table) to both above) Licenses (child (many to many table) to both License Master and Pending Locations / unrelated to Suggested Licenses) I have a pipeline that searches criteria in the License Master to see if it matches criteria in the Pending Location. If any License Master records match they are copied to the Suggested Licenses table. On the Licenses main form the Suggested License embedded report has the API button I'm trying to create. I want to be able to click the button to Add the Suggested License record to the Licenses table if it is applicable for that location. Then edit the Suggested License record by checking the box "Added to Location" to then filter it off of the Suggested License report for that location. This is the formula I currently have and I'm so close. It adds the record and refreshes back to the Licenses page, but it does not perform the 2nd API to check off the box in the Suggested License record. var text ADD=URLRoot() & "db/" & " [_DBID_PERMITS_LICENSES]" & "?act=API_AddRecord" & "&_fid_95=" & URLEncode([Related Pending Location]) & "&_fid_44=" & URLEncode([Related License Master]) & "&_fid_8=" & URLEncode([License Master - Related Issuing Authority]) & "&_fid_21=" & URLEncode([License Master - Related Remittance Agent]) & "&apptoken=XXXXXX"; var text UpdateSuggestedLicense=URLRoot() & "db/" & [_DBID_SUGGESTED_LICENSES] & "?act=API_EditRecord" & "rid=" & URLEncode([Record ID#]) & "&_fid_17=true" & "&apptoken=XXXXXXX"; $ADD & "&rdr=" & URLEncode($UpdateSuggestedLicense) & URLEncode("&rdr=" & URLEncode($RefreshPage)) var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); Any help to what I'm missing would be awesome! Thank you.
Solved
Kelly-AnnTainto
23 hours ago Place Quickbase Discussions
api
10Views
0likes
2Comments
Formula-Numeric Field Returning Null Instead of 0
Hello: My current formula-numeric field returns null, instead of 0. How could I tweak the formula below to return 0? Please note: A. The numeric fields below have the "treat blank values as ''0' in calculations" enabled: GPA - Associate Degree GPA - Bachelor's Degree B. The Primary Program Name and Secondary Program Name are text fields. ********************************************************* var number AssociatesDegreeScore = If([GPA - Associate Degree]>=3.3, 2); var number BachelorsDegreeScore = If([GPA - Bachelor's Degree]>=3.3, 3); var number FinalScore = If( not IsNull([GPA - Bachelor's Degree]), $BachelorsDegreeScore, not IsNull([GPA - Associate Degree]), $AssociatesDegreeScore, 0 ); If([Primary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)" or [Secondary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)", $FinalScore)*1.5 ********************************************************* Thank you, Roula
Solved
RoulaHabbal
3 days ago Place Quickbase Discussions
formulas
14Views
0likes
2Comments
API Button Help
Hello Everyone, I have created an API button, but I keep getting an update_id error. Can someone please help me understand what this error means so I can fix it? Thank you -Bart <qdbapi> <action>API_AddRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>26238</rid> <update_id>1731629328550</update_id> </qdbapi>
Solved
AlexBartholomew
7 days ago Place Quickbase Discussions
api
40Views
0likes
9Comments
Calculating 1.5 pay
Is there a way to have a field calculate and display time and half pay from an hourly base pay field?
Solved
LB
7 days ago Place Quickbase Discussions
formulas
60Views
0likes
16Comments
Default column widths on embedded reports obscuring data
We're building a new app with the "new" form builder for the first time, and seeing an issue with embedded reports. The default column width on the embedded table reports is partially obscuring the data, and although you can manually expand each column, there doesn't seem to be a way to make those column widths stick. Am I missing something, or is this a deficiency of the new form UI? We have half a dozen apps using the legacy UI with dozens and dozens of embedded tables, and this has never been a problem. Fwiw, I found the following post describing the same problem on dashboard pages, but this is not a dashboard page. It's happening on the 'main form' within our tables... https://community.quickbase.com/discussions/quickbase-discussions/can-you-set-column-widths-for-reports-in-the-new-dashboard-pages/19595 Thanks in advance for any insight.
Solved
JoshWeeman
7 days ago Place Quickbase Discussions
Forms
40Views
0likes
4Comments
Table is missing
Hi team, I moved a table from one application to another, then move this table back to original location, the dbid didn't change, but the data was missing, showing blank table. Do you have any idea what connection was broken? and how to bring data back? Thank you.
Solved
CarolG
8 days ago Place Quickbase Discussions
Relationships
13Views
0likes
2Comments
Formula Date Field
I have a formula date field and this is my formula: If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],"") I get an error on the last "" expecting date but found text. How do I tell it to do nothing if the the formula is not true?
Solved
CarolMcconnell
9 days ago Place Quickbase Discussions
formulas
19Views
0likes
2Comments
Date Field Formula
I have a date field that is tracking a transition date, and need to create another field that will calculate 60 days prior to the transition date. How do I set up the formula in the field to show the date 60 days prior to the transition date?
Solved
LB
9 days ago Place Quickbase Discussions
Forms
20Views
0likes
2Comments
Changing/setting record owner
I'm running tests on my app and am working on user/approver access. So far I have been the only tester but soon the approvers will be testing but I would like them to be able to test on test records already created. DB summary: Leaves request db for faculty where single request (Leave Requests table) is approved by multiple (7) approver (Approver List table). When leave request is submitted pipeline creates 7 decision records for each approver with status of "pending" in Request Decision table as well as also creating same 7 records in Decision Status Changes table (log of decisions). Currently all records have me as record owner. When app goes live it will have faculty as leave request owners, and would like all decisions records, in either Request Decision table or Decision Status Changes table) be owned by the specific approver user. I can see it is possible to create a pipeline to change ownership for future records, but currently I'm trying to change ownership of current test records and am not able to access the option in my more menu in the old version. I even filtered the report by a specific approver's username. See screenshot that shows no menu option. Any ideas on what I'm doing wrong or missing?
Solved
kheatley
10 days ago Place Quickbase Discussions
Record Owner
12Views
0likes
2Comments
Merging 2 Fields into a Formula-Text Field for Reporting Purposes
Hello: I have two fields that I want to merge for reporting purposes. Application Status - Primary Application Status - Secondary I created a formula-text field named,Merge Primary/Secondary Application Status. I tried the formulas below, but none are working. Could someone assist me with tweaking any of my formulas, please? First Try If([Nursing]="",[Application Status - Primary Program],[Application Status - Secondary Program]) Second Try If( [Nursing]="Application Status - Primary Program", [Nursing]="Application Status - Secondary Program" , true, false, ) Thank you, Roula
Solved
RoulaHabbal
14 days ago Place Quickbase Discussions
formulas
38Views
0likes
5Comments

Tags

Formulas and functions2215

APIs and custom code1554

reports and charts1308

Tables and fields1240

Relationships1226

Ask about Quickbase functionality1133

App builders1121

Quickbase Automations476