Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have several team members who leverage one of our tables via a form to update or validate the information we have in the database is correct. The request I keep getting is to add a search box for one of the tables parameters directly to the form so they do not have to go back to the tables main page to search for the new record. Since I'm fairly new to this, is the best way to accomplish this is adding a field on the form in edit mode that will leverage a record picker to find the record information so it can be viewed/edited? I'm also assuming as long as the form user clicks save and close it will write any changes they made to the table? Thanks!! ------------------------------Becky H. ------------------------------
Hi,I'm referencing the Magic Buttons application and I noticed on the Upload Multiple Documents tab in the projects table main form, that there are two buttons condensed together over a single report field:Does anyone know how to do this?? I've looked at the form rules the code within the buttons and I do not understand how they were able to do this. Best I can tell, it is tied to the report because other fields within this form do follow the standard display/alignment expectations. But when I look at the report, nothing is different from the report on my form.Thank you!------------------------------Curtis Middleton------------------------------
Can someone give me an example of using API_DoQuery on the code page to display the xml data?------------------------------Charlene Dougall------------------------------
Does anyone know the css code in API_GenResultsTable to style the Group Row Header? td.m only works for the individual rows. ------------------------------Charlene Dougall------------------------------
Hi,Is there any way we can track before/after values of the file attachment field in the history table using pipeline? I don't know if file name remains same and user changes content and upload it again then pipeline would be able to identify it. Or will have to change filename every time so pipeline can track the change. I've built pipeline to capture text fields (using below link) but not sure how to handle file attachment field. Please advice. https://community.quickbase.com/blogs/evan-martinez1/2021/09/20/creatingdatachangelogsusingpipelinesThanks,Mrunali------------------------------Mrunali Kadam------------------------------
Is it possible in a pipeline to request user input for a specific field? I want to add a reason why someone moved from a position (promotion, job change, exited organization) which can't be automated.------------------------------Marco Heijkoop------------------------------
Greetings, To start, I am aware that I could use QB Actions to solve this. Also, I tested all inside the Rest API documentation and was able to post a record successfully. I want to use QB Rest API inside QB Webhooks. I have two headers, the Authorization: "QB-USER-TOKEN [user token]" and QB-Realm-Hostname "thing.quickbase.com" filled out properly. The Endpoint is the generic https://api.quickbase.com/v1/records. Method: POST and FORMAT is JSON. Body : {"to": "ImagineHere","data": [{"6": {"value": "[Issue Type]"},"7": {"value": "[Description]"},"8": {"value": "Test Record"}}],"fieldsToReturn": "3"}I keep getting 400 - bad requests with no description. If I could get some assistance I would be most appreciative. My intent is to manually create a record in table A and have the webhook insert into table B. If I can get this to work I can make it work cross apps, too. (Again, I know about the QB actions). Look at this as more practice than anything. Thank
Is there a limit to the number of records or file size for CSV upload? A file I have been uploading increasing in size daily uploaded fine until today and now I get this message (pretty sure it's not the network on my end):------------------------------Adam Keever------------------------------
I've a simple table which contains Name (text) , Salary (number)I can create filters in report settings but can I create filters by clicking filter button to Salary more than 40000 (my attempts at >40000 fails)I believe these are called column filters------------------------------Prashant Maheshwari------------------------------
I am working on a way to log changes to specific fields. I have created a history field that records all the information I want to track when it is changed into an entry in that field. My problem is there are 2 user fields that have Full Name in them and when I attempt to pull than information out and into the new History field it only prints some id number associated with that user, I want it to print the Full Name of the User. My history field is a multiline text field.Below is the action to my dynamic form rule. It states:When the record is savedAction change history to <br><b>Status:</b> [Status] <br><b>Changed by:</b> [Changed by] | <b>Changed Date:</b> [Date Changed]<br><b>Tested By:</b> [Tested by] | <b>Tested Date:</b> [Tested Date]<br><br>Again, everything in this prints beautifully with the exception of the [Changed by] and the [Tested by].Here is what an output would look like:-- [OC
Can you use a URL field to add a link to a shared file on a network?
I have two Code page in that pages I do some quickbase API call and I create a functions inside, the doubt is if its possible to call a function in Page1 from page2 to avoid write the same code in both pages?Any idea?Thanks
In the app I am working on I have a Text - Multiple Choice filed with years listed on it that a user is to select from when creating a request. My client is asking that I limit that field so that a user can only select the current year or a year in the future. Obviously I can remove the past years as options for now, but short of someone manually going in every year and removing the previous year, the only other way I can think to do this is to create a child table with years as the records and create a report to use in place of the standard record picker that restricts the years listed to the current year or after. Does anyone have another idea?------------------------------Chris Swirtz------------------------------
Im having a hard time getting the correct y axis vaules i want to have when im creating a report with a line chart. if anyone has a way i can pick a different option from the ones its giving me. ------------------------------Fernando Ramirez------------------------------
We have implemented a project intake and tracking system that currently spans ~400 projects. Each project has 5 phases. we have attractive dashboards for Portfolio Leaders, Project Managers and Stakeholders that include ability numerous filters to get to the right subset of project data for our users. To view the number and percent of projects in various phases we utilize a pie chart with an associate gauge KPI to show the total. This works very well except for colorization of the pie wedges. Problem: We have not discovered a way to pre-set the colors for the 5 phases. Our corporate leaders are accustomed to Planning phase in blue, Executing phase in green, Delivering phase in magenta, etc. If the data set the user chooses includes all 5 phases, the color them from the common pie chart report works as intended, but if the user chooses a filtered data set that includes only a subset of the data, then the pie
In my app I have a form that has a button that when clicked will display a message that prompts the user to take certain next steps. That works fine, however, the client wants a button on the home page that does the same thing. I was wondering if someone can help me create a button that will take the user to a code page that displays the message and the shows 2 buttons, one will change the change the status field on a form to "Cancelled", the other will just navigate back to the home page.------------------------------Chris Swirtz------------------------------
I am getting an Error with my Pipeline that reads, "Quickbase reported an error: 2 : Invalid input : You must provide a valid choice for the field named "Requesting Business Unit" with field id 7."From what I understand both fields options must match exactly for this pipeline to continue. With that being said, both fields are exactly the same. We think the error is created because QB is having an issue with the "&" symbol in several of the responses. Example, both fields show "Mass Markets & Distribution", but in the sample data option for fields one shows "Mass Markets &amp; Distribution" Any ideas how to work around this? We have attempted to URLEnode the field, but we are receiving the same error------------------------------JASON VOSS------------------------------
Hi,Have a number of Multi Choice displays on a for user interaction - the text associate with each button is quite long. Are there any properties for the Multi Choice that can be used to identify which radio button was selected by the user.RgdsPat------------------------------Patrick O'Neill------------------------------
The new style was working well mostly but with the latest update, something went very wrong. Is it possible to fix it by myself? I mean this empty white space in the first column and wrong column alignment. By the way, this issue is present only in chrome. And the old style works well. ------------------------------Ulyana Marchenko------------------------------
We recently had an issue where we lost the ability to switch between users in Pipelines. This made using Pipelines very difficult, as my boss and I both build and maintain pipelines (but couldn't see each other's work).Our Quickbase Technical Enablement Consultant was unsure why this option disappeared. He said that tech support has a feature that utilizes CSR Access, so they can access our systems without needing to be added as users to our pipelines.It ended up, that by having this option turned on, QB Customer Service Reps can access our pipelines, but also removed our ability to switch between users. This was a surprise to both of us, as this isn't documented anywhere. I am posting this, with hopes that they will add a note under the "Care Access" menu, so that clients are aware of the functionality that will disappear. I have since turned this option off and logged out. Upon logging back in, I can now switch between users in Pipelines once again! -----------------------------
I am trying to count how many records there are that are tied to the same customer and that come after the current record by date using the formula:Size(GetRecords("({6.EX."&[CustomerID]&"}AND{8.AF.'"&[Activity Date]&"'})",[_DBID_ACTIVITIES]))Where field 6 is CustomerID and field 8 is [Activity Date]. The formula should be looking for all records with the same CustomerID (that part works - I took out the second part to check) and with an Activity Date after the current one. If there are 3 activities for a customer on different dates, I would expect one to have a value of 2, another to have a value of 1, and the third to have a value of 0 (no records with a date later than the latest one).Instead, I am getting a seemingly random result of 1s and 2s (no customer has more than 2 activities yet).I don't know if it matters, but since this system is for use in Canada, it has the date format the "right" way, with "DD-MM-YYYY" rather than our American way of "MM-DD-YYYY"Wh
Hello,I have URL formula buttons to run Javascript code pages. Is this feature going to be discontinued? If so, what is the best way of implementing it which is acceptable to QuickBase? Here is a sample URL button formula to run a page."javascript:" &"QBU_ProjectID=" & [Project ID] & ";" &"var urlJs = 'https://xxxx.quickbase.com/db/" & Dbid() & "?a=dbpage&pagename=DataProcess.js';" &"$.getScript(urlJs, function(){});"------------------------------NK23 NK23------------------------------
For several weeks, data in lookup field drop-down boxes has been partially or completely disappearing randomly. I have not been able to establish a pattern and it is affecting all users. Most of the data supplied to the lookup fields comes from synced tables, however, this morning I had a local app table with less than 15 records completely disappear from the drop-down on the form. We have also had table report data completely disappear. You have to refresh and/or totally exit Quickbase. It disappears at random events as well. I had it happen when removing a global search text entry. I expected all records to appear after the text was deleted, however, all records disappeared. I am getting ready to roll out to 700+ restaurants and this and several other issues will kill the project. Any input appreciated.------------------------------Cathy Vanderkamp------------------------------
Hi everyone!I need to create a summary field in my parent table that summarizes a User field in the child table. Is this possible? Seems like I'll be able to do what I need when the new formulas come out later this year, but just wondering if I can do this now.Thanks!------------------------------Nathan Allan------------------------------
I'd like to be able to email all the task owners under a project if a project's status changes.I'e tried using summary fields, a formula query and a pipeline and can't find an easy way to have a list-user field at the project level that summarizes the task owners.------------------------------Raymond Sakar------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.