Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I would like to build a pipeline using the Bulk Record feature. My scenario is similar to the example here https://help.quickbase.com/pipelines/about_bulk_record%20sets.html?Highlight=bulk. I am not clear on the "Make Request" Step. Wondering if I can get additional details or if there a video available on this feature? ------------------------------Christine White------------------------------
My client is looking for a user to be able to start a New Space Request and at any point be able to save where they are to be able to come back later to finish it and submit it. However, they also want several fields to be required in order to ultimately submit the request. Of course having all those fields required won't let the user save in the middle to come back later. Any suggestions on how to make this scenario work?------------------------------Chris Swirtz------------------------------
I am trying to write a url formula button that will allow the user to essentially Save the current record and create a new record while passing the data from fields 15, 7 and 9 to the new record. The user would end on the new record, ready to enter new data in other fields on the form, then be able to hit the button again repeat the same action, saving the current new record and passing fields 15, 7 and 9 to the next new record and so on. Is that possible or am I thinking about this incorrectly. I need users to log data, but want to save as many extra keystrokes as possible when the data does not change but every several records. thanks for your help.------------------------------Stacey Sexton------------------------------
Is there a list of what font families are supported within QB when using rich text formulas??------------------------------Kelly Lyons------------------------------
One of my favorite tips learned at EMPOWER2020 was from a session Chris Hutchens delivered titled Building for Mobile.He shared how to get a thumbnail image of a photo to display in a table report. While the session was geared towards mobile users, it's applicable to anyone that wants to show an image in a table report.I created a quick video to show demonstrate that little gem: https://youtu.be/M7p71Yo770cIf you'd like to try this in one of your apps, simply watch the video and copy this code snippet to paste into a formula - rich text field: If(Length([Photo])=0,"","<img width=\"150\" src=\""&URLRoot()&"up/"&Dbid()&"/a/r"&[Record ID#]&"/e31/v0\"/>")Enjoy!------------------------------Freddie Sabbs Senior Solutions ConsultantQuick Basefsabbs@quickbase.comCambridge MA------------------------------
Hi thereI?ve created a form accessible to ?everyone on the internet? for our clients to submit service requests. I added ?&ifv=20? to the url to hide the qb branding. However, doing this causes the save button to become hidden. I created a formula url button that will save it using this javascript I found on the forum:var text URL = "javascript:void(DoSaveAdd())";var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>";"<b href =" & $URL &">" & $Image & "</b>"My problem now is how do I get the page to redirect after the form is saved. Here?s a link to the form, you can try it and see what happens.https://sparkav.quickbase.com/db/bnzwm7ykp?a=nwr&ifv=20I'd like it to redirect to an external webpage. If that is not natively possible than I'd like it to redirect to a rich text page I've created in quickbase.Any help with this would be greatly appreciated!Thanks,Elisha
Is there a way to change requirements on a form after a user takes a specific action? For example, only 2 fields are required normally, but if the User selects "yes" from a drop-down or marks a checkbox yes, then other fields become required? We want people to be able to use the form and enter whatever info they have as they get it, but we don't want them "submitting" it until the form has all of the info.Thanks!------------------------------Amber Gartner------------------------------
I have several tables with a lot of columns on them .. on some reports, I want to see 35-40 columns. When I scroll to the rightmost column pre-loaded by quickbase, it loads some number more columns... then I try to navigate to them by scrolling further right, and the scrollbar jerks back to a mid point.I've tried this using keyboard cursors, and 3 different browsers... is this a known bug? Anyone else experience it, or have a better work around than creating a smaller table view?Thanks!------------------------------Malcolm McDonald------------------------------
Is there a way to hide the Save&Close button on the top of the form?I saw the checkbox to hide the save at the bottom, but see nothing for the top.------------------------------Steven Nelson------------------------------
Hi,I am trying to use webhooks to POST to an endpoint URL provided by a partner but am not having luck with the body, it keeps giving me an error saying the the Body is not a valid JSON object- any help would be appreciated! I am fairly new at using webhooks so completely lost with the body!------------------------------Magaly Reyes------------------------------
I have a form that generally requires one field entry per user, but on occasion will need 2-3. For instance, one user may be required to submit a single address, while the other will be required to add 2-3.Is there a way to add a box at the bottom of a form section asking "are there any more *addresses* you would like to add?" Selecting "yes" would then populate a duplicate series of fields. This could be repeated as many times as the user needs.I appreciate the help!------------------------------James Warren------------------------------
We make custom signs, and very often our customers want to see options of the same proposal. Right now each option is a different Proposal Number, but I want to be able to create options with the same base proposal number. For example, proposal 12345 is the original, then they ask for 2 options, and they would be labeled 12345-1 & 12345-2.Right now I have the proposal numbers auto-populating from the record ID field, and I'd like to keep that, but also want to be able to add the options.------------------------------Allison Watson------------------------------
I know that class OpenAsPopup does not work on mobile, but I had hoped that the button would still function, it would just not be a popup. It appears the button simply doesn't work, as it is 'trying' to Popup, but his 'hidden' on mobile.Is that other users experience? That we will need to create two forms any time we want to use a button that utilizes openaspopup?------------------------------Mike Tamoush------------------------------
Empower 2022 was a blast! So many exciting announcements, enablement sessions, and learnings from Quickbase builders and thought leaders. I, for one, am beyond excited for our updated form building and some great new enhancements to the report builder panel.Need new TV to binge this weekend? Over 40 sessions are available now On Demand!Want to meet other builders solving problems in your industry? Sign up for a Customer Network here!What excited you at Empower this year? We want to know! Leave a comment about something you learned or exciting news you heard.
I am working with 3 tables: Parent Table: Work Orders--> Intermediary (Child) Table: Subcontractor Quotes--> Child Table: Status History. I have an embedded report on my Work Order form which displays the Subcontractor Quotes. I have a Formula-URL button displayed on the report called [Subcontractor Dispatched]. When the button is clicked, I need two things to happen: I need to create a record in the Status History Table. I've successfully accomplished this with the following formula: var bool show = If(Contains([Quote Status], "Approved by PM"),true,false); If($show=true, URLRoot() & "db/" & [_DBID_STATUS_HISTORY] & "?a=API_AddRecord&_fid_16=" & URLEncode ([Record ID#])& "&_fid_10=Subcontractor Dispatched" & "&_fid_11=Subcontractor Quote Status" & "&_fid_9=" & URLEncode(User()) & "&apptoken=xxxxxxxxxxxxx" & "&rdr=" &URLEncode ( URLRoot() & "db/" & Dbid() &"?a=doredirect&z=" & Rurl()),"")
I have a table that includes a multi-select field called impacted paths. It has 6 options. Now, imagine for each option that I have a build lead field (List-User), a target completion date field, team phase field, and team status field (e.g. Compensation - Build Lead, Compensation - Target Completion Date, Compensation - Team Phase, Compensation - Team Status). Okay, in the form for the table I created 6 tabs, one preceding each of the subsets of fields. Now, in the dynamic rules I created logic that said if the Impacted Path contains Compensation, show the tab and the 4 associated fields. Easy, right? I wrote a similar rule for each of the 6 choices in the impacted path field. So here's the problem i'm running into. When I select either of first two options in the sequence of fields in the elements list everything works fine. But, if i select any of the other 4 options, only the tab name appears and not the fields. I've built
How would I write a formula to have the system subtract two weekdays from a date field, please? My formula below will calculate 2 calendar days from the due date. So, if the due date is Monday, 5/23/22, the system should identify Thursday, 5/19/22, not Saturday, 5/21/22. [Due Date]-Days(2)Thank you!------------------------------Tom------------------------------
I recently had trouble having a pipeline populate one address to another. My originating address field had a space in the name, and I thought I just needed to include an underscore to make it work. It turns out, that is not the case. Through testing and customer support's help, the correct syntax is:{{a['Address 1_city']}}as opposed to{{a.Address 1_city}} or {{a.Address_1_city}}Hope this helps others who run into this unfortunate bug!------------------------------Mike Tamoush------------------------------
I have a button with the following code that does check the box but instead of taking me to the app home page it takes me to a page with some code on it that is pasted below the formula. I have tried several variations of the end of the formula for the redirect but so far no luck on that part.URLRoot() & "db/" & Dbid() & "?a=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_1152=yes"& "&rdr"& URLEncode("https://georgiabuildingauthority.quickbase.com/db/bka89j884") <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>11541</rid> <num_fields_changed>1</num_fields_changed> <update_id>1652985137631</update_id> </qdbapi>------------------------------Chris Swirtz------------------------------
Is there simply no way to use a formula query on a table with 50k+ records? I've tried having a first query that would elimante all but a handful of options but I still get the 'will take too long error'. Are queries just limited to small tables or is there a trick I am missing? My use case is I need to see if a certain entry in one table, exists in another (by matching a couple fields).I can't use a combined text because those are limited to a string of 150, and my string will be about 1500 entries, and i need to search through those 1500 specific entries to see if there is a match. I could use like 15 combined text fields and break it up but that sounds like too much work.I could use a query but my query will need to parse 60k+ records and start eliminating.------------------------------Mike Tamoush------------------------------
I can't seem to figure out how to toggle between desktop view and mobile view in my App. I realize I can set the default view for the App as mobile or desktop for non-admins but as an admin, how do I view (and edit) my App form in mobile view?Thanks in advance!-Eric------------------------------Eric Rovner------------------------------
I have one table that I can create a unique 'key', which is just a concatenation of a Project ID and Dollar Amount.I have another table of 60k records, and I want to see if my 'key' exists in that table. (It may exist a couple times, but unlikely for that key to exist more than 2 or 3 times in the table).I cannot figure out how to do this. What I have tried so far:1. Formula Query. This failed as I am unable to query the table. It is too large, or something but I get the 'too long to process' error.2. Combined text field. I tried to get a combined text field of entries, and then look that up on my initial table and do a simple 'Contains' formula. However, the smallest batch of numbers I can get may be up to 1200 entries. The combined text field only can do up to 150. SO I miss about 1000+ entries.My only thought: Figure out a way to compartmentalize the combined text. ie - create 10 combined text fields, somehow broken down in chunks of 150. Then check through all 10 fields for a match
Hello,I am new to QBase and I recently ran a report designed by my admin (who just retired). In editing individual records to update some payments, I progressed through each record with the save and next option. Later, when viewing the entire report, I pressed Save Changes. This has now yielded a smaller parameter grouping which was the grouping I was working on when I hit save changes. Problem is that the previous report now will only pull this smaller group and no longer plays by the rules of the initial report.------------------------------Chris Rose------------------------------
If I have an image was was pasted into a Rich Text (data entry) field, does any one know syntax for a Formula Rich Text field to control the size?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------
Hi,I've Table1 which has default/hardcoded Owner name and need to populate owner id from the Table2 which contains the emp and id details.@Mark Shnier (YQC) Please advise. Thanks in advance! ------------------------------Mrunali Kadam------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.