Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi, Please help with a code for the add button, I want every time I press it it should reflect in the Stock Item , Quality and Stock code formula fields, as may Items as possible.Currently its a relationship. ------------------------------Boitumelo Segaole------------------------------
I have the autosave function turned on for a table and a button in the table that navigates back to the home page with the intent to save the record progress where it is when clicking on the button. Furthermore, upon creating a record, there are a couple of other fields that are auto-filled in, one from the parent/child relationship and the other from the code in the Add Record button. However, if a record is started, and no other changes are made beyond those 2 auto-filled fields it doesn't save the record, it just navigates back to the home page. If I make just one other change, it works fine. I am wondering why those other fields changing when the record is created initially doesn't constitute a change?------------------------------Chris Swirtz------------------------------
In my app I have an "Entities" table which is a parent table to a "Sub-Entities" table and lastly a "Spaces" table which is a child table to both the "Entities" and "Sub-Entities" tables. They are connected separately to the "Spaces" table so that either can create a new Space. I have both relationships pulling the same info, Entity or Sub-Entity name, contact names, addresses, etc. And when I create a new Space from the Entities table it pulls those fields into the Spaces table as it should, however when I create a new Space from the Sub-Entities table, none of the info pulls over and I cannot for the life of me figure out why it's not working for the Sub-Entities. The only thing I can figure is because the Sub-Entities table is a child table to the Entities table. Any insight as to why this might not be working?------------------------------Chris Swirtz------------------------------
Hi all,Is there a limit to the number of records that will generate an email or is this a limitation of my email server? I have a report with 125 records, that includes the email address. When I click on the button at the bottom of the report to "Email Everyone in this Column", nothing happens. If I group the report so there are fewer records, that seems to work.Your thoughts are appreciated!Kim------------------------------Kim------------------------------
Looking to know if anyone has successfully inserted a RESTful API call that initiates when a record is opened for editing that calls an external data source (with existing key field) and fetches data to then present on the Edit form.Any guidance you can provide would be appreciated.------------------------------Satyen Vora------------------------------
I use two separate applications one for the Product Request and another for Project, Once the product request form is submitted a new project is added to the project application under the project table via QuickBase actions- copy values.I have created a notification for each new product request, related project Id #, in the URL part rid is missing, When I click the URL, it shows the Project Not found error due to the missing rid.This was working fine earlier in may then our application ownership transferred to another person, What could be the reason for not being able to fetch the related project Id# and rid.Attaching images for more clarity ------------------------------Musafar mc------------------------------
Hello All,I have a use case that I have been working on for a few days and cant get it to work exactly how I would like, hopefully someone here has figured this out.I have a mentee table with a child to parent relationship to a mentor table. An employee will select a skill or career from the mentee table which will show a list of names of mentors that can mentor them on that skill or career through a report link. That all works well but what I am trying to do is once the mentee selects a mentor I want to have another field where the mentee has access to the same list of names in the report link in a drop down so they can indicate on the form who they selected. A regular user field is causing problems as employees are selecting names of people that are not on the list. A conditional drop down did not work because there are too many variables to account for on what to show in the list. (mentor availability, authorization....) I was able to get a formula query set up to reliably give me t
Hello All,This question may sound very simple but I am trying to find the most efficient way to tackle this issue and was wondering if anyone has run across this problem before.I created a table to make a process more efficient for one of our departments. Long story short they still tracked items in Excel and had multiple versions of this tracker on random machines. There are multiple states that have different needs so I created a few conditional drop down fields to clean up what each user sees when creating a record. All of that works fine when entering a new record. In order to keep users from simultaneously working in QB and Excel I wanted to "normalize" the legacy data and import it into QB. I have already made sure the data fits the new form but when I go to import the legacy data none of the conditional fields will update with the values coming in from Excel. I guess that makes sense since a child record gets added to the tables holding the conditional values when a new record i
Greetings All,I'm trying to use a formula text field to show a different text string based on the reference value in a multiple choice field that has 11 choices, i.e. when the answer in the multiple choice field is "A", show "AA" text in the formula text field. So in my formula, I am using CASE to test as follows:CASE ([Field], "A", "AA","B","BB","C","CC" for the 11 values.What I'm finding is that it only allows me to test against 8 values. For the 9th value I get a Boolean error message. This limit has been the same whether I'm using CASE or IF statements.Does anyone have a suggestion on how I can go beyond the 8 value limit? Thanks for any light you can shed. I'm not a formula expert so I'm scratching my head on this.------------------------------Doug Crandall------------------------------
I have a child table that a user is only meant to be able to make 1 record for each parent. Is there a way to limit the user's ability to create more than 1 child record?------------------------------Chris Swirtz------------------------------
Hi all:I have a child table that has many related records to its parent. I transformed that date created field to a text field and then made a SUMMARY field in the parent table so that I could "see all the dates" of all the related records. The challenge with this is that I would like to then manipulate this summary field back into a date/numeric field that lists the dates from earliest to latest. I then want to "extract" different dates to do some formula work in the parent table. So, I have the summary field (its a text field)I want to convert it back to some kind of "numeric" or date field that then lists the dates from earliest to most recent.I know this is a simple thing and I probably have done something in the past, but just have a quickbase mental block on solving this one.Thanks for any help------------------------------Melissa Freel------------------------------
Currently I've built a LMS app in our realm, and with no SCORM compliance for Quickbase I will be using SCORM Cloud to host the content. Is there anyone out there who may have experience with SCORM Cloud and Quickbase? I'm going to have a link to the content that will automatically register the user and go to the launch page for the content. The tricky part is getting the info back to the Quickbase record with date complete, status, and test scores.------------------------------Dwight Munson------------------------------
Hi, I have an imbedded grid table from a relationship in my exact form. I need to use one of those fields further down in my from. Is there any way I can extract a field from the grid table?The form is linked to the parent table so I don't have access to the child fields for the form extract. Or, any suggestions on how to get at the child field to expose to the form? Thank you!------------------------------Barbara Alvarez------------------------------
Hello! I am fairly new to QuickBase but I have been able to create a pretty awesome form for people to open tickets for my team. One thing that has been requested is that I add a "General CC" field in which people can add their names to become included in the notifications. Is this possible in QuickBase? Is there a field type that I should use?------------------------------Alyssa St. Onge------------------------------
I am still learning formulas in quickbase and I wanted to write one that I thought was easy, but my brain is making it difficult.Set Up: Advisor multi select field (field 12)There are currently 10 AdvisorsI want to hard code a formula (not use filters) to pull a report that displays only the projects the 3 out of 10 people are working on.Am I making this to difficult because nothing works. I don't want to use the filter function because it's limited------------------------------Jamie Strauss------------------------------
I am trying to set up SAML authentication with Quickbase and am working with an IdP that requires Authn requests to be signed. I can see in this article:https://community.quickbase.com/blogs/quick-base-team1/2021/12/08/saml-public-authentication-certificate-for-signedthat there should be some option to enable signing SAML Authn requests, but I am unable to locate it. Could someone point me in the right direction?
I'm curious if a command can be added to a button to have the rdr go back to the same place on the page when you clicked the button.Example... I have a button that adds a child record, but the button is basically in the middle of the form. When you click the button, it successfully adds the record and comes right back to the parent, but you always land at the top of the page and not back where the button is (for more clarity, it's a "+" and a "-" button to add count to inventory, so I want to click the plus button and just return right back to where the button is on the page so I can click it again).I'm not sure if this is Javascript, or part of a QB formula... or just not possible.Thanks for the help!
I want to have a report that filters the records if todays date falls between the "Scheduled Start Date" & "Scheduled End Date".Im confident this can be done with a formula checkbox that compares todays date with the scheduled dates and if it meets the criteria, check the checkbox, then filter the report based on the checkbox.If anyone has any suggestions on the code that you would use, or even a better way to do it, please post below. Much appreciated!------------------------------Jordan Thompson------------------------------
Hello all!From url-formula button, I'm trying to check a checkbox which is present in the same table but whenever I click the button I get the error saying... <qdbapi> <action>API_EditRecord</action> <errcode>24</errcode> <errtext>Invalid Application Token</errtext> <errdetail>The Application Token *apptoken* has not been assigned to this Application. To read about assigning an Application Token to your application go to https://help.quickbase.com/user-assistance/app_tokens.html</errdetail> </qdbapi>If([Arrivy test checkbox field] = false, URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&apptoken=xxxx" &"&_fid_130=1" & //this is the checkbox field"&rdr=" &URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#]),URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&a
We like the idea of using Pipelines, but am concerned about ownership if the person who created the Pipeline is no longer with our company or not available to make a change. I did see an answer similar to this situation regarding Automations. The response suggested created an "automation user' account and giving access to that account. Would this same solution need to used for Pipelines as well? How can someone other than the Pipeline creator gain access to a particular Pipeline?------------------------------Amy Gosz------------------------------
I've created a form using exact forms and when click I on the generated print URL I can see the form, for a split second, open in a new tab then the page goes white/blank. I've sent to my internal support and it opened fine for them in Chrome. I tried Chrome and Edge. Cleared my cache, and rebooted. Nothing seems to fix it. Has this happened to anyone else? Seems like a browser issue since it opened fine for Support, but I can't resolve. Thank you for any suggestions.------------------------------Barbara Alvarez------------------------------
Hi everyone, I am new to QB so these questions could have simple solutions so I figured I would post them. I am currently uploading 100K+ in entries from excel and want to select a random 1000 from the data set. Is there a way to do that? I looked into the report formulas and pipelines and nothing stood out, but doesn't mean it's not there. 2nd - If not, I know how to randomize it based off sorting the data a particular way, but didn't know if I am able to limit the output of the table to only 1000 rows? Either would work, but a random function would be more idea.Thank youAnthony------------------------------Anthony McIntyre------------------------------
Hi,I've a list-user type field which has around 16 items. In the report it shows only names of 2 names and only count of the remaining users. when I click on that count it shows a list of users in a popup form. Is there a way I can show the entire list of users in the report (instead of +14). ? ------------------------------Mrunali Kadam------------------------------
I have a table that holds session tokens for a third party app. This third party app will now be used with another app I administer. Would it be a good idea to move the current table to the app I use for data transfers and create a sync table in the two apps that will need access to the session token rather than creating cross app relationships? I look forward to hearing your thoughts------------------------------Paul Peterson------------------------------
Hello, Below is a YouTube of something I want to do so badly for one of my tables, and I cannot figure out how to configure it to my tables. The examples he provided are tailored to his table.Please help! I have reached out to QuickBase support as well, and they've been trying to do something for over a month, it is something I need sooner than later, and this is exactly the way I want it, I just can't read the code well enough. SOS?https://www.youtube.com/watch?v=OtE_j7kPJK0------------------------------Newman, Savi------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.