Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a Work Order table. The person who creates a Work Order receives a commission for the job on the work order. Formula: Work Order Price * Commission Rate. I'd like to have a different Commission Rate based on the User Role of the person who wrote the work order. For example: Sales = 10%, Rep = 7.5%. Is that possible?------------------------------Terri Bruce------------------------------
Hi All,I'm trying to get a pipelines email step to only show the text "Call Rating:" if the call rating field is not blank. I've tried: {% if c.call_rating != '' %} Call Rating: {{c.call_rating}} {% else %} '' {% endif %} and {% if c.call_rating is defined %} Call Rating: {{c.call_rating}} {% else %} '' {% endif %} But the resulting email from both of those when that field is blank still says:Call Rating:Any idea how to get it so that line doesn't show in the email if that field is blank?Thanks, ------------------------------Daniel Johnson------------------------------
I'm finding the iterative process of editing a code page in Notepad++, saving it to the QB Code page interface, navigating to a record or form, running the process, investigating Chrome tools for errors etc, and then going back and doing it over again to be time consuming. I feel like there has to be an easier way. Wondering what your process is for developing QB Code pages? Any advice is appreciated.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
I feel like this should be a simple task, but for some reason I am just not getting it.I have an audit form with 20 questions. Each question can be pass/fail. I want to set up a bar chart where each bar is the total number of fails for all audits. So if on four of the audits there is a 'fail' for question 1, then the bar would show 4. And when I drilldown, it will show me those 4 specific audits.My closest attempt is setting my x axis to the year of the audit, then adding all 20 questions (fail checkbox) to my y axis. This gives me almost my desired result. The chart looks right, but the drill down shows me all audits in that particular year (versus only the 4 audits with the fail). I can't seem to wrap my head around how I should set this up.------------------------------Mike Tamoush------------------------------
I am curious if there is any way to make dynamic dropdown lists for a field based on criteria. For example, our roster has a status for staff so we can see who is active or inactive. However, when pulling names from the roster, it shows all (to include inactive). Any advice? Thanks!------------------------------Jeffrey Weide------------------------------
I have a dynamic form rule that fills a DATE STARTED date field when a multiple-choice field is set to "In Progress" and a DATE COMPLETED date field is filled when the status is changed to "DONE".I have a Kanban report that shows cards organized into columns using the Status field. When I drag a card from, for example, IN PROGRESS to DONE, the DATE COMPLETED field is not updated. How can I have a change in the status field update a date field when changing it by moving it via a Kanban report?
Hi,My team have used Zapier to hook up WooCommerce from Wordpress to QuickBase, and also made a few automation in QuickBase, but today we received an email notification of 429 Error: Webhooks are exceeding the rate threshold.Wonder if that can be fixed or why did it happen?First time seeing it since we started using QB in 2018.Davy------------------------------Davy Ou------------------------------
Hi Everyone,I'm just wondering if there is any to create report based on date a record was created. Does QuickBase capture that? ------------------------------Mike Nouri------------------------------
When using the Import from a CSV file, periodically the field name is different - no space, added space, etc. When that happens, Quickbase automatically selects a seemingly arbitrary field to chose to load the column. This seems like a defect, not a feature. if a column name does not exactly match up, the import function should either deselect that column or default it to an 'Undefined' column. Either way it should NOT select a column. Late at night, it is easy to not notice something like that, the data looks fine since everything lines up. There should be a color warning and an indicator that the column does not match, or the ability to create a new column (I saw something abut this in other posts...)
I am using an iframe on a Sharepoint site to show a QB report with the new style. When dynamic filters are added to the report, the report in the iframe displays the filters on the left (old style). How can I convert the filters to the new style in the iframe?------------------------------Colleen Burch------------------------------
I have a Pipeline that creates CSVs using the bucket channel. A Pipeline query adds a row to the bucket table for each matching record. When I download the completed CSV, the rows are not in order by the CSV's first column (date field). Is there a way to set slist and sortorder parameters in the Pipeline's advanced query to order the resulting list? Are there any other options for sorting the bucket table's rows before downloading a CSV?------------------------------Daniel Dabek------------------------------
I know Juiced offers a great add-on where you can have an email send with an actual attachment. This all happens as an automated process (push button/link, email fires).Does anyone has a service (maybe this isn't even possible....) where you push a button/link and it opens up your email client as a new email, with an attachment? Then the user can complete the email and send?Perhaps this doesn't exist, but thought I would check.------------------------------Mike Tamoush------------------------------
I have the responsibility to work on QB apps for hospital employees. I am thinking I would like to learn more about using Apps that I normally work on the computer, be user friendly on the cell-phone. I have done some web design and the last three web sites I updated, I used HTML 5 that really looks slick on a computer monitor, but more importantly it's awesome on a smart phone or a Kindle Fire which I also use to test. Are there some good webinars or university courses on building for small screen devices? This would make be very happy!------------------------------Bob T.------------------------------
Is there a way to have a pipeline condition: If [Date] is null? I only can see to test if it is before or after a specific date. For now, I have been making formula checkboxes and using the check box, which is quite annoying.------------------------------Mike Tamoush------------------------------
I was able to get a list of values in a list using: GetFieldValues(GetRecords("{23.EX.'"&[Related Event]&"'}", ""), 3)However, is there a way to get the MIN and MAX from the list if the result is 3;4;7;8;9;10;11;12 ?------------------------------ROBERT STEVENS------------------------------
Currently I have a relationship between my Purchasing table and Shipping Log table where one Purchase has many Shipping Logs and I have the Report Link set to show a link to the record versus the list. That defaults to showing the related records Record ID, how do I get it to show a different Field in the related record? Or is there a URL formula perhaps to return the field I am looking for in the related record to show on the Parent Record? I want the [Shipment #] field to show on the Parent Record.------------------------------Chris Swirtz------------------------------
Hello,I'm curious if anyone has a sense at what point a table is just too large for attempting to use a formula query on it. I'm currently trying a Size(GetRecords()) on a table with 3-4 fields in the query, and it seems like it just simply stopped working at over 40,000 records (and yes, this is after trying different iterations of which query comes first, in order to maximize performance). Does that match up with anyone else's experience?------------------------------Field Department------------------------------
I am trying to build a table report in an email and I need to use both AND & OR to filter so finding the related records and if the status is "Received" or "Stored" or "Client Hold". What is the syntax to nest the OR statements. Here's what I have, but it's not working. {"from": "brce2frp8","select": [33,89,117,11,70,63,27,28,29,72],"where": "{127.EX.'{{a.id|int}}'}AND({71.EX.'Received'}OR{71.EX.'Stored'}OR{71.EX.'Client Hold'})","sortBy": [{"fieldId": 33,"order": "ASC"},{"fieldId": 117,"order": "ASC"}]}------------------------------Julie Meeker------------------------------
Is it possible to attach a file from Table A to Table B through Pipelines? If so, could you provide the steps?------------------------------Yudisleydis Perez------------------------------
Hi, May someone help me create a formula for a Rich Text (Formula) field to be able to create a log number based on a Date / Time field. Example: Date / Time = 12-17-2021 1:33 PM I want may Rich Text (Formula) field to to show 2112001 Where 21 = year, 12 = month, 001 is login number Please advise. Thank you in advance.------------------------------Raymond Marlon Tiangco------------------------------
How to write QB formula that will pull up the record from another table field?Table 1: Field1, Field2, Field3Table 2: Field4, Field5, Field6.[Field6]=.[Field2]------------------------------Siva------------------------------
I am creating 2 simple pipelines that when a record is created in one table it creates the same information in another table and I send the record ID# with the new creation.Then the seconds takes that record ID# and looks up the original and deletes it. But when I try to use the record ID for the lookup step I keep getting a "Validation error: Output fields should be of type integer"I am confused all fields are same type numeric. And I have it working in another set of tables but for some reason I cant get it to take.------------------------------Robert Rufli------------------------------
I have a many-to-many relationship of employees to campaigns. Each employee can serve one of three roles within a campaign. In my scenario I will only ever have one employee serving each role. Table design shown below: Within the Campaigns table, I would like to be able to see the Employee name in each of the three distinct fields. So Campaigns should have three fields called Assistant, Strategist, and Setter. The query seems fairly easily - basically something like "Select Employee Name from Assignments where Campaign = [Record ID#] and Role = 'Strategist'". Unfortunately I cannot figure out how to make this happen... Any suggestions on how to accomplish this? Should I just abandon the many-to-many relationship and create three independent relationships?TIA------------------------------Jeremy LahnersLeadBaller------------------------------
I have a related table. I want to modify the "add record" to only view the child record. Basically I want to recreate the "View Record" eyeball icon that is found in the report table. (I don't want my users to have to find this tiny little eyeball. I need a big glowing button for them to click on.)I was able to write the formula that references the correct table, but I can't pull the correct Record ID because it is pulling the Record ID of the parent table. I need the Record ID of the child table. Is there a way to reference the Record ID from the related child table or just reference a Record ID from a different table?URLRoot() & "db/" & [_DBID_TEST] & "?a=dr&rid=" & [Record ID#]------------------------------David Semitekol------------------------------
What kind of button or link in a Notification email should I use? I want the QB user to be able to click on a button within the email and the QB user is directed to a form in Quick Base where they can then take action. What does the formula look like?------------------------------George Bramhall------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.