Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
On the new forms, the report link has a new feature where you can create a new child, with a sort of - embedded button. Does anyone know how QB sets the code for this button? It seems like it only works some of the time for me. Perhaps it doesn't work correctly cross app? I am still trying to determine it, but wondering if anyone has insight or experience. Would be awesome if we could set the coding in that embedded button, in case we need to modify.------------------------------Mike Tamoush------------------------------
Okay, this might be a bit complex, so let me lay out the issue. I have a text field called SME that is in the format of some guy (sg1234), another guy (ag2345). First, I need to create a user list field from that SME text field. I figure it's grabbing that sg1234 and appending the email suffix of @somecompany.com. Next, i want to see if the record owner for the record is in that user list field. I know I'd have to make the record owner (user) field into a user list field. How would i accomplish the converting of the text field into a user list field?------------------------------MICHAEL SARGENT------------------------------
Hi everyone, I'm Josh, and I'm excited to introduce myself to the Australian and New Zealand QuickBase community. With 7 years of experience with QuickBase, I'm here to share insights, offer support, and answer questions you may have about the platform. To help our community grow, I will be working on creating content that will hopefully help new and existing QuickBase users with common issues, especially ones that are encountered due to localization differences. In the meantime, if you have any questions or problems that you are facing please comment below or message me and we can work on putting you on the right path for a solution! Catch you in the comments, or feel free to message me anytime. Cheers,------------------------------Josh Hamilton------------------------------
On an application we just started, there are some checkboxes next to items, such as "Development Team Thresholds" but there is no information fille out in that section. I can't UNcheck it. What is the point of checkboxes if you have no control and they automatically check as done when the information is still missing?------------------------------Theresa S.------------------------------
Hello! I am trying to create a pipeline which when a record is updated in QuickBase, then it updates the same record in my Google Sheets. If there is no matching record id in Google Sheets, then I want it to create a new record in both Google Sheets and Quickbase. I am wondering whether I put QB fields in the append and update steps, or if I put the GS fields in those spots. Attached are screenshots of my steps. Thanks in advance!------------------------------Colin Fox------------------------------
I have employees assigned to jobs. Start date - End date. As you can see I have a have a timeline report that breaks out each employee grouped by assignment and when they arrive and when they depart. I would like to turn this into an easy sheet to edit, upkeep and view. Weeks across the top / employees down the side grouped by task. Check box for each week that they are assigned. I am at a loss of where to start. Any help to get pointed in the right direction would be greatly appreciated. Thank you in advance for any assistance. ------------------------------Jeffrey Thompson------------------------------
I've been trying to create a rule in the new form rule editor that auto-fills the current user into a User (lookup) field when the form is loaded. Is there a way to do this? Thanks!------------------------------Matt Makris------------------------------
I apologize if this comes up as 2nd post. I received an error after I submitted my first. In my newly created App I have multiple tables. And in those multiple tables I have used the text field Text - Multiple Choice. The settings values for those fields are... Text - Multiple Choice field options Input Type: From list (FYI. I have a list of items listed not in alphabetical order) Allow users to create new choices is selected. Display choices in alphabetical order is selected. When I go to the table where that field is located and add a new record, that field dropdown does not give me the option <Add new Choice...>. It only lists the items in my list non-alphabetically. I'm seeing this happen in every table where I have a Text - Multiple Choice field and I can't seem to find a setting at the app level to control this. Am I missing a step? Thanks, stu------------------------------Stu Lamden------------------------------
Hello Everyone, Need help to setup the below concept. App 1: Loan table App 2: Employee table(contains employee and manager details) Question 1: An Employee with sales manager title need to have a sales admin to help with the loans Question 2: Currently a report in loan record shows the loans assigned to XYZ sales manager, the challenge I'm facing here is to show the loans to the associated Sales admin(of the XYZ sales manager) Thanks in Advance,------------------------------RH------------------------------
Welcome to the AEC Customer Network Qrew! Tell us a little about you! Where do you live? What do you do for a living? How long have you worked in your field? What's one building in the history of time you wish you would have been able to say you were a part of building? Same question, but one building in the history of time you're glad you weren't a part of building? ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
I have a text field and I can't quite figure out when this happens, but sometimes it changes a quote (") symbol to &#65533. And sometimes if I have a lookup field, it changes it to a little square.I can't get it to happen consistently, so I am not sure exactly the combination of things needed to make this happen. Also, these seem to be unrelated. Meaning, sometimes a quot enters just fine, other times it comes through as the &#...Sometimes it looks up fine, and sometimes it comes through as a little square. Anyone know what is happening? I'm unclear so far if it only happens with the quote, or if something else triggers it.------------------------------Mike Tamoush------------------------------
Hi, Is it still possible to create an exact form? Is the template supported.I kept an old template on my desktop, but after clicking on Add-On, I can't seem to sign on to Quickbase, just get a mismatch error?Jeff------------------------------Jeff Rogerson------------------------------
I have two tables in the same app - Client and Client Details. Let's say Client Details is a subset of Client. The reason I made a subset table is there are too many dependencies that may get impacted if I edit the main Client Table. The Client Details table is connected to Client Table and refreshes automatically. If I go and change the key field in the Client Details Table (Subset table), will it impact the main Client Table key field? Record ID#2 is set as the key field as well as the Refresh key field for the Client Details Table whereas the same field in Client Table is set as the key field for that table. My question is if I change the key field alone in Client Details table to RecordID#, will this impact the key field for the patent Client table?------------------------------Rahul Mathew------------------------------
Click here to go to registration page for our first meetup on September 26th! We look forward to connecting with you! ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
If you had a magic wand and could change one thing in Quickbase, what would you change? ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
What's your favorite Quickbase feature and why? What value does it bring to you as a builder or admin? ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discussions a better experience? Let's chat!https://calendly.com/bsimon-2------------------------------
I am trying to use string comparison operators in a Formula-Checkbox field but am striking out at the simplest use-case. Field Type = Formula-Text, Field name = Scan Bucket, Field ID = 45 Field Type - Formula-Checkbox, Field Name - IOSOtherHit, Field ID = 42 I want the box checked if 'Scan Bucket' contains the letters 'WAP'. Unchecked if it doesn't. The letters 'WAP' could appear anywhere in the string. I could not get the formula to work with just the .CT. comparison operator. I had to put it within an 'if' statement and start it off with another boolean expression for it to not error out. Here is what I am going with: Formula for IOSOtherHit: If(ToText(2)<>ToText(1) & "{45.CT.'WAP'}",true, false) However, as you can see from the mini report below, it is still hitting on strings that do not contain the letters 'WAP'. Any suggestions as to what I am doing incorrectly will be appreciated.------------------------------Aaron Bab16
I am trying to create a formula for a Checkbox field type. I need the Checkbox to the checked if the value in a numeric field is greater then or equal too a 1,000,000. I keep hitting a wall. ------------------------------Ashley Solomon------------------------------
This may be a very elementary question, but hoping the community can help.I have reports that need to have $ fields summarized but do not want to summarize % fields. How do I summarize some but not all numeric fields?------------------------------Annetta Coleman------------------------------
I'm running a code page from a button-triggered Rich Text formula field, which I pirated from Kirk Trachy's video. The code is mainly run from the user's mobile device and it captures their current GPS coordinates and current time, and then updates form fields with these data elements. The code works, but it seems unstable. It works better on a wifi connection than it does on the device's network (inconsistent results with Verison, doesn't work at all with T-Mobile, and works every time with Xfinity) Sometimes the button needs to be hit a few times, and sometimes it will redirect to the home page, or gets hung on the "Processing" page. I'm including the code page as an attachment and a screenshot of the Rich Text formula. I would appreciate any insight into how this can be made to be more robust. ------------------------------Barry Dolan------------------------------
Hello all. I seemed to have run into a bug where pictures that I upload to a file attachment field are not saving updates. The files seem to update, but then the next day they will have reverted back to the original picture that was uploaded. It is almost like the update is not saving. However, it is strange because the updates will show the same day, but the following day the picture will have reverted to the previous version. Has anyone seen this bug before? Or know of a setting that might be causing this behavior? Thanks------------------------------John------------------------------
I am looking to timestamp a checkbox that will be edited in Grid Edit (so a form rule is not an option). Is there a formula I can use in another field to timestamp the user/date? A lot of results I am finding suggest an automation but those aren't available anymore. I'm scared of the P word (pipeline) but I'll figure it out if a formula isn't available. Thanks!------------------------------Cheryl Huie------------------------------
Question:Is there an option to pull "Realm Status" to my application to notify user to not select this person as Approver? Background: I have app which supports process which is run only from time to time. It happen that user goes on Deny List, and when somebody select him as approver, they does not receive mail notification. I cannot make this app EOTI. ------------------------------Adam Krzyzanek------------------------------
Hola, My company inputs water samples, for our tasks. There is a relationship between the two. Like, the task name so it connects to the task overview. Within the water sample, is a field to input the date the sample was taken. We need that date, to display on the task labeled "Nitrate Sample Last Taken" and it displays the date from the water sample on the task IF it was a nitrate. Can you help? ------------------------------Newman, Savi------------------------------
OK so I have a record I edit, and I have a button called "print this page" that opens a different form and automatically asks to print. It's worked for a couple of years until recently, and now it's saying: "There's nothing here! The form you're looking for has been deleted, or the link that brought you here is incorrect." I haven't changed the form, so I'm assuming something else has broken it, but I can't get it to work again. Here is the formula that was working: URLRoot() & "db/" & Dbid() &"?a=printr&rid=" & [Record ID#] & "&dfid= 1000010" Any ideas as to what changed and how to fix it? ------------------------------Thanks,Chris Newsome------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.