Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
There is a table relationship between Sections table and Table B, Sections is the parent or master. In a Table B form there is a dropdown that the user can select Browse all sections and choose the parent Sections record. I do not want users to be able to create new sections from the child table Table B. Therefore, how do I remove the "Add New sections" button:
Hi, Why do some dynamic filters have drop down list options in the bar and others only have filter to fill in for search? Is there a way to make them all drop down lists? Amy Migliore | Digital Communications Content Manager, Resources For Living https://www.resourcesforliving.com/ A company CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments. NOTICE TO RECIPIENT OF INFORMATION:This e-mail may contain confidential or p
so I need to make my cancel button change one field to "Cancelled" (which it is doing) but now I need to get another field (fid 65) to change to "Closed" and I have tried to simply add on the field ID 65 but that hasn't worked out so well as I get an error. here is my full code w/o my app ID tho var text RID = If([Record ID#] > 0, ToText([Record ID#]), "%%rid%%"); var text Edit = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=missed one &_fid_79=" & URLEncode("Cancelled") & URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & $RID & "&apptoken=missed one &_fid_65=" & URLEncode("Closed"); var text DisplayURLMissingRID = URLRoot() & "db/" & Dbid() & "?a=dr&rid="; var text URL = $Edit & "&rdr=" & URLEncode($DisplayURLMissingRID) & $RID; "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; backgroun
I am trying to import a file into a child table in QuickBase. After importing the data, I am unable to see the relationship between the child record and the corresponding parent record in the parent table. ------------------------------manohar vankireddy------------------------------
Hello, I am wondering if this is not possible: I set up a timeline report with custom colors for 10 different groups. Now I have a request to create stacked bar charts for these same groups using the same custom colors. When I try this, I get the message 'Legend: Colors will be assigned automatically. Either no records match the filter right now, or a report formula is chosen as the series.' The hex codes display as the legend on the chart, so if the charts are on the same dashboard, the colors are meaningless. Would a formula rich text field get around this, or is colorization on a stacked bar chart not customizable?------------------------------Lisa Sell------------------------------
Hello, Can an email domain be associated to more than one Quickbase realm? If not, why not? I understand that there is a good reason to not allow this, but need help with describing why this cannot be allowed.------------------------------Craig McElroy------------------------------
I created a webhook that changes a field in a record, based on if a different field is modified. I chose a webhook because it works instantaneously, and it is such a simple thing I hate using an entire pipeline for one simple thing like this. Webhook works fine except it does not work in grid edit mode (which is the reason I made the webhook in the first place instead of a dynamic form rule). In grid edit mode, if I change 5 records, the webhook fires correctly for the first record changed, but doesnt fire for the remaining records. I saw the limitations on webhooks were 50/second, so I imagine if I grid edit over 50 that could happen, but does anyone know why i cant even grid edit 2 records and have the webhook fire twice, once for each modification?------------------------------Mike Tamoush------------------------------
Hi , I am looking forward to create a button on a parent table form to download the related child record table which will get downloaded automatically. Tried multiple ways but its redirecting to the specific report only, not able to download upon clicking on a button. Request your help------------------------------Bhargavi Katepalli------------------------------
Hello,I got the requirement like we need to show the current user location and time zone on a form, it shouldn't be a auto filled, it should be like a dropdown value with only their specific location they can select, and they can change it to other if they want, without creating a Master table could it be done? If anything related have done earlier, request your help here.------------------------------Bhargavi Katepalli------------------------------
I would like help with a formula to calculate and show the number of days a case was open based on the date it was created until the field (case status) is changed to closed. The case status field is Multi-select Text. If that field won't work I'd like it to calculate based on the date it's closed, which is a date field. Thank you!! ------------------------------Nichole Stebane------------------------------
On my last step in a pipeline, i would like it to create a record on a different table about how many records were updated ( ex: {{ a | count }} ), but i also would like to have the list of record ids that were found from the search pipeline step. Does anyone know how to access this list? my expected output for each run of the pipeline is to create a record with these fields # of Records updated = 3 using {{ a | count }} list of records updated = 23; 25; 36 using ???? any help greatly appreciated :) ------------------------------Tim D------------------------------
Hi all! I have a cross app form on a child table (App B) with a parent table (App A) because users of the form in App B need to see the information inputted by users in App A, but do not need to have access to change it. I've modified the permissions on the fields in App A and App B so all users have a minimum of view access, but when I look at the form in App B, all of the fields appear blank even though they have data in them in the parent table in App A. I keep thinking I'm missing something simple. Thoughts/ideas? ------------------------------Becky Heineman------------------------------
currently i have buttons that will work if i save the record and go back into the form, but i want to be able to change field ID 79's status to pending review when one hits submit WITHOUT having to hit save & keep working (or exit or new) this is what i am working with for my submit button, i have removed my app token for security reasons. "<a class=\"Vibrant Primary SaveBeforeNavigating\" width:310px; text-align: center;\" href='" & URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=you wish you knew &_fid_79=Pending Review&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()) & "'>Submit</a>" this is the error that i am getting: thanks in advance for helping me!------------------------------mcraig0127------------------------------
I am creating a button to change a status field. I am getting the XML style information issue. The button works correctly and I know it has something to do with the code not redirecting back to the rid but I'm not sure how to fix it. Here is the XML error This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>8</rid> <num_fields_changed>0</num_fields_changed> <update_id>1679947786033</update_id> </qdbapi> Here is my code: (this may be overcomplicated. Probably an easier way to accomplish this) var text URL = URLRoot() & "db/bsy9zg874?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_330=Review%20for%20Inspection&z=" & Rurl();var text Image = "<img src='https://expertclaimmanagement.quickbase.com/up/bjvfbr5u
Hi! I built a junior rodeo app and I'm wondering if there's a way I can do a "random draw" for scorecards. We have to generate a random sequence of numbers depending on how many players are in that event. Right now we're using a random number generator, and just taking whatever number order they generate and assigning it manually for over 1,000 scorecards. We have a report, and it's okay to type the number down the list, but it would be great if QB could generate a random draw for us! Here's how it works: The "draw" determines when they come out of the gate - when it's their turn. Event A has 14 players, they need to be assigned random numbers. Event B has 12 players and need a random number assigned. etc and so on. Does anyone have any ideas?------------------------------Renee Hansen------------------------------
So I have gone through the process of creating a customer survey form. I have managed to remove the green save buttons etc using the following steps:1) Create a js code page:$("#formFooterButtonsContainer").hide();$(".IconOnly").hide();$("#saveButton").hide();2) Create a rich text formula field:"<img qbu=\"module\" src=\"/i/clear2x2.gif\" onload=\"javascript:$.getScript('" & URLRoot() & "db/" &Dbid() & "?a=dbpage&pagename=EOTIcodepage.js&rand='+Math.random())\">"This works fine when i am on a normal browser But doesn't work in mobile. In mobile I have:[Save], [Save & New] and [Cancel] buttons both on top of the form and at the bottom. How do I get rid of these fields?Edit: My save button i created also doesn't work:"<a class='Vibrant Primary' href='javascript:LinkAway(\"" & URLRoot() & "db/" & Dbid() & "?a=showpage&pageid=20" & "\");' >Submit review</a>
I have a Clients table (parent) and a Products table (child). I am trying to list how many Clients records are related to records in the Products table. The `Product Name` from the Products (child) table is the primary dimension in the report. The metric is `# of Clients` associated with each Product Name. Some Client records are associated with more than one product, which is showing up in the `# of Clients` value. Is it possible for the `# of Clients` value to reflect the number of unique client records, rather than counting a client 2+ times in the event that Client record has more than one Product record association? Thanks!------------------------------Matt Makris------------------------------
Can realm admins such as myself reset a users password though the admin real admin portal? Or does the person have to do themselves though a Forgot Password? reset link. Thanks------------------------------James Dalton------------------------------
I am the Product Owner for an QB App that serves a fast growing segment of a Fortune 100 company. We have a number of Product Teams. Each Product Team will have a Dashboard with multiple tabs. Some of the tabs will be standard across all Product Teams and some of the tabs will be specialized for the Product Team. For the standard tabs, we have a simple dynamic filter that is associated to numerous widgets on that tab. How to we pre-populate the filter with the Product Team associated to that dashboard? The current dashboard works great and will save the time of developing dozens of specialized reports and widgets, but I am confident the users will want to save themselves a couple of clicks of having to select the Product Team that is being served by the dashboard. ------------------------------Annetta Coleman------------------------------
Just wondering, Is the timestamp, Last updated by, a combination of the Date Modified and Last Modified By fields? Or is there a difference. Thanks, ------------------------------James Dalton------------------------------
I have a form in master Invoices table, which has an embedded Cost Of Materials details table. Cost of Materials is in Grid Edit format on the form, so one can add items quickly. Cost of Materials is only calculated when form is saved.I would like to have a button for saving changes and returning to editing current Invoice (NOT view/display). If that is possible, I would be very grateful for your help.Kind regards,ArkadyPS: Happy Christmas and best wishes for New Year
Can anyone recommend a stupid simple download manager, presumably a Browser Extension. The use case is that I'm sitting on a report and want to download all the file attachments which are in a column on the report. I have tried out about 6 of them and can't figure out how any of them work. ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Hello! I have a formula that says:var text MultiInTextFormat = ToText([Breeds]);List(";", If(Contains($MultiInTextFormat, "Yorkie"), "Dog"),If(Contains($MultiInTextFormat, "Doberman"), "Dog"),If(Contains($MultiInTextFormat, "Clydesdale"), "Horse"),If(Contains($MultiInTextFormat, "Amnesia"), "Cat"),If(Contains($MultiInTextFormat, "Hound"), "Dog"),If(Contains($MultiInTextFormat, "Persian"), "Cat"),If(Contains($MultiInTextFormat, "Morgan"), "Horse"),If(Contains($MultiInTextFormat, "American Warmblood), "Horse"))Often times, this formula generates a list like this:Dog;Dog;Dog or Cat;Cat;Dog;HorseHow can I remove the duplicates from that list? Can I add something to this formula? I'm ok with adding a new field that will remove the duplicates, I just don't know how to do that.Also, how can I get that de-duped list to put each value on a separate line within the field (instead of a string separated by ";") So if the values selected in [Breeds] areAmerican Wa
I am trying to search for when a date/time field will fall between essentially a 24 hour window starting from when the pipeline is triggered (likely hourly but potentially 3 different pipelines with 3 different times daily) Ultimately this is going to trigger a text message through our Twilio connection. It keeps posting as "No Records Found" and it is killing me! I tested the Jinja in some date/time fields and that part seems to be working. I don't know why it is saying "No Records Found" Query: [Date/Time Filed] is between {{ time.now|timezone('America/Los_Angeles') }} {{ time.now|timezone('America/Los_Angeles') -time.delta(hours=24) }} + Checkbox Field #1 is yes Checkbox Field#2 is yes When I look at the [Date/Time Field] it 100% is between the two times. I even tested the Jinja Expression in other fields to make sure it is printing the correct times and it is! Any and all guidance is appreciated. ------------------------------Joseph Mahon----------------
Hi , I am trying to show a multiselect values with customized bullet color list using rich text field. But unfortunately I caanot , by default it is taking the black bullets not able to do the customization , can someone help me here. I just used the below code, there are 10 values in my multiselct field I want that to be represented with different color of bullets.If(ToText([Workstream])="","", "<li>" & SearchAndReplace(ToText([Workstream]),";","</li><li>") & "</li>" )------------------------------Bhargavi Katepalli------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.