Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
With "new style" table reports, if I apply dynamic filters or use the search bar to filter the report, and then add a column (by hovering over a column header, using the "..." then choosing "show more columns" and hitting "apply"), the column gets added but all those filters get removed. The search term remains in the search box and dynamic filters that were applied still appear to be selected in the UI (shows selected still at the top) but they are not. The filters are removed, and you have to clear and re-apply your filters. It trips me at least once a day and it's driving me nuts...I put in a support case in April, eventually QB closed it and said they tied it to a bug, but I can't be the only person that this is bothering...I understand that QB is probably/hopefully working on this and I just need to be patient. I guess I'm just looking to commiserate in the meantime with any else that is getting really annoyed about this. Can I get an AMEN??
How do I change phone format (999) 777-4444 to 9997774444 so i can use it in my pipeline for an outgoing request
I'm trying to create a pipeline that will create a new record in my decisions table if a new record in requests is created. Was able to set up the On New Event section, but when I then try to set up the Create Record section, the fields I need to specify values (Approver Name, Approver Role) are not options. What do I do so I can make those fields options/selectable? Kim
In a previous update there was an option to have a homepage / dashboard with multiple tabs, but I don't see this as an option in the newest version. Did this feature go away?
Am I to understand that top navigation is going to be permanently moved to side navigation beginning in 2025?If so, that is one really dumb move. We have ALOT of reports that are designed to fit on the screen exactly as they are. Now they will all have a horizontal scroll bar which makes it an unnecessary waste of time having to scroll left to right to see the entire report.Why do you guys arbitrarily change stuff nobody really asked for? And why don't you just give us the option to stay with what we are comfortable with. Removing choices in preference is really stupid.
I can't seem to find a way to change the order of my fields/columns in my tables. I added a new field, but would like to move it to a different location other than the end of the table. I've looked for answers here but can't find any. I had found a couple posts that were several years old regarding this, but since QuickBase has changed/updated since then those solutions were no longer an option. I'm sure there is a way, I just can't figure it out.
We have many many projects and within those projects we have templates that hold our labor and material for the specific projects. Each of the different labor and material has a vendor attached to it. I need, when I click ready to release to vendor, an email is sent to them allowing them to approve that PO via the email. Please help, the specifications on this are all over the place throughout the years.
I have been working to move to the new forms, using our own buttons and Iforms to control user workflows. The problem I'm having is one of formatting Rich Text buttons. Formular URL buttons (when used in new forms) automatically fit the width of the column, and have rounded edges. They can be made to look better by placing them in a column of their own to constrain the width, but the problem comes when using Formula Rich Text Buttons. I can make it the same general width to fill the space, but the corners are square. - see screenshot Does anyone have a recommendation on how to round the ends to look like the Save & Close in the screenshot here? The current code of the Save & Keep Working button is below"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #1b8b0a; border-radius: 5px; color: #ffffff; display: inline-block; padding: 5px 0px 5px 0px; width:180px; text-align: center; text-shadow: none; border: 2px solid #1b8b0a
I have a button that opens a Pre Use Check and the Formula is a case statement that looks at the asset type and open the correct checklist based on the asset type. It was working but now is invisible on the form. So I tried to build a "test form" and still shows up blank and I also tried to create a new Formula URL button but now I get a Refused to connect error. Any help would be appreciated. Support has not been able to help. They sent me the link to the Check my Formula documentation.Here's the formula: Case([Type],//Wake boat pre-use check"Wake boat",URLRoot() & "db/" & [_DBID_WAKEBOAT_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_25=" & URLEncode ([Record ID#])& "&z=" & Rurl(),//Large boat pre-use check"Large boat",URLRoot() & "db/" & [_DBID_LARGE_BOAT_PRE_USE_CHECK] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID#])& "&z=" & Rurl(),//Small boat pre-use check"Smal
I have 3 (Parent) reference tables: Dx Codes Reference, Pcs Codes Reference, and MS-DRG codes. Then there is a Charts table, and two connected tables: Dx Codes and PCS Codes. The relationships between them are as follows:Dx Codes Reference < Dx CodesCharts < Dx CodesPcs Codes Reference < Pcs CodesCharts < Pcs CodesMS-DRG Codes < ChartsEach year the Reference tables get an updated codes list. My plan had been to just add 3 new reference tables each year for the new codes list. but my quandary is how to have a field that picks from the appropriate reference table dependent on the chart discharge date. Is there a way of doing this?Thanks for any insight you can provide.-Audra
When I email a report from QB, I have a rich text lookup field that is not displaying correctly, it is showing the actual code: <span style='font-family: Gibson-Regular; font-size: 13px;'>Aviation and Occupational Medicine</span><br><span style='font-family: Gibson-Regular; font-size: 10px;'>6900 East 47th Avenue Drive<br>STE 100<br>Denver, CO 80216</span> (8 AP Invoice)Any ideas why or how to correct this issue?
Hi everyone, so I am trying to create a dropdown for user to pick in a form and the dropdown need to be filtered from user previous selection. But if previous selection is not selected, user still be able to pick the dropdown and select from it.To make it easier to understand, let say I have a form (in table called Main Table) with three dropdowns (State, County, and City from three tables) and State < County < City. If user pick Texas in State, then County dropdown will filter to only show Counties in Texas. But if user decide not to pick anything in State, the County dropdown will show all County in every states. Then if they pick Dallas County then City will filter to only cities in Dallas County and State will still be empty.I am aware of Conditional Value (in Field Settings) but it requires user to first pick State in order to pick County. I am open to any suggestion and solution. Feel free to ask if you need me to explain more.
Hi,Can somebody help that one user in my App has her email address as her name...the rest of users have names as normal.Thanks,
I'd like to get the actual file URL of a file uploaded to a File Upload field. How can I do this and display the URL in a form? My use case: Users can upload an image file. I want to display that image in an <img> tag in a rich text field in the form.
We are trying to use the new mention feature in Rich Text fields. I have it working on a 'new' form but not on legacy. Has anyone got this working on legacy forms?
I have a List All report that I'd like to change from the default filters. When I select the desired fields - Custodian Number, Custodian Name and Quarter - and Save, the filters appear as I want them. But when I leave the app and come back later, the filters are back to the defaults even though Custodian Number, Custodian Name and Quarter are still specified in the Dynamic Filter section.Do I need to make a copy of the List All report to get this to work? Or is there something I'm missing?Thanks!
I created a pipeline to create a record in a table (Statuses) after a record in another table (Masters) is created. For each Master record created I need 4 Status records created - each with a due date at 3,6,9, and 12 months after the expected start date noted in the Master. I have tried several formulas but am unable to get the right formula. The Expected Start Date in the Masters table is FID 13. If that date is 11-1-2024, how do I write the Status Due Date pipeline formula(s) to create a record with the due date of 2-1-2025 (and subsequently 5-1-2025, 8-1-2025 and 11-1-2025)? Dates will be different for each Master so I can't plug in hard dates.Can i create all 4 records in the same pipeline by adding additional 'create' steps? Or do I need 4 separate pipelines?
Is anyone else having issues with the grid edit on the new forms? I click the edit and it takes me to a new page in which I add the new records. This is a different behavior from the old forms.
Hi, pipeline guru'sWe suddenly started getting the following pipeline error to an email template that we have in the application, but there have been no changes made to the template or form, but its preventing the email being sent to the user. Any suggestions on what we should be focusing on to resolve this? Remote service reported an error: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, Microsoft.OData.ODataMediaType, M
I am trying to create a pipeline that will send an invite to the user's google calendar when a meeting is scheduled. The pipeline is working and I am getting the calendar invite for the correct date however, it is not utilizing the time entered in the Date/Time field as the start time. This is pulling off of a Date/Time Field from the record created that triggered the pipeline. I have fields that split the date (Meeting Date) and time (Meeting Start Time) into two separate fields and have tried to use those in the pipeline but that shows as an incorrect format for date. Help!
Need help with an if/then formula or what I assume is the best way to get the data I need.I have a vacation request submitted into one table that is linked to decision table that needs 5 signatures before it is approved.Currently, I have the status field in the vacation table that is:If([# of decision records] = 5, "APPROVED", "PENDING APPROVAL")Will this work per request? Or do I also have to include record# or something in the if statement.Thanks for any advice/help.
Hi all,I'm trying to set up a checkbox that gets checked when a number of conditions are specified. Here's my current formula:If(Contains([Type],"Leader")or Contains([Type],"Managing")or Contains([Type],"Associate")and [Forecast Due Date]=Today()and [Revenue]=0and [Work Status]="Active"and [Frequency of Pay] = "Monthly",true,false)Everything works fine except for the Contains, which I feel like I've tried just about every permutation of. Basically I need each of the conditions after the Contains to be true, AND I need one of the 3 Contains conditions to be true, after which I want my checkbox to be checked. From my results it feels like it's stopping at the OR statements and checking the box if any of them is true.Any help would be appreciated!
I have a two table setup that I would like to display multiple dropdown fields on my parent table form. I would like these dropdown fields to be populated with the records in my second table. This table will only contain the source for the dropdown fields. The table contains two fields "Name"and "Percent". Is it possible to display only the records in the dropdown that have the value "3" in the percent field in some fields and only the records in another field that have "5" in the percent field? Do I need to create a relationship for this?ThanksBrian
I am retrieving data from an external data source using Make Request. I am then using another Make Request to send data to a QB table using the format shown below. It works great when I have 2 or more records in the response. However, when I only have one, then every field ends up being blank, even though I can see data in the response. Any thoughts? {# create records in XXXX table #} "to": "XXXXX", "data": [ {% for rec in f.json.response.xxxxxs.xxxx %} {% if loop.index0<5800 %} { "12":{ "value": "{{rec['@creationdate']}}"}, "6":{ "value": "{{rec['@id']}}"}, "38":{ "value": "{{rec['@status']}}"} } {{ ", " if not loop.last else "" }} {% endif %} {% endfor %} ] }
We're tracking our productivity through actions taken during the week. Each week has a total of actions taken, a sum of both the blue and red portions of the below chart. The Blue actions were scheduled - ie: we knew and planned ahead. The red actions were last minute urgent requests that came in. These are unfortunately unavoidable - but we'd like to keep this number in the 5-7% range. Is there anyway in a stacked bar to show the percentages of the series as they relate to their summary? I'd also like to see a total of the stacked bar. I'm not sure if this is possible with some sort of summary formula, but would be very helpful!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.