Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I just finished creating the Upload Multiple Documents logic from the Magic Buttons app. Does anyone have a process they'd like to share (button or Pipeline) that "moves" the File Attachments from the Parent table over to the newly created Documents/Images child table without requiring a download?------------------------------Nichole Braswell------------------------------
I have a quickbase we will call it Network that has a connected table to another quickbase that we will call Escalations. On the connected table in the Network QB, i have two added fields that reps update in the Network QB. I then want to send the data in those two fields back to the Escalations QB. The fields in the Escalations QB have the same name.I created a pipeline who's trigger is when one of those fields in the Network QB is updated. My next step is search record query on the Escalations QB and it pulls back the record where the Escalation QB record id matches the Network Escalation record id. Next step is the loop and the final step is an update record. The record to be updated is the search record. I pull in the fields to be updated and do the matching. The pipeline ran with no errors but the record from the Escalation QB did not update. On the activity I see on the update record step, it gives me this, "Skipped because se
I have a child table that is built in Form Engine. A pipeline takes info from the child table and creates a parent table with a custom key. That key is from a text formula field in the child table.It works but now I need a summary field (sum of some amounts) on the parent table, which will not work because the key is from a formula.I'm wondering if there is some way I can create a text field in the child table that gets its value from the formula field, so that static text field can be used as the key rather than the formula. Is this possible? Or is there another, better strategy?
Hey Everyone,I'm working on an app for tracking attendance by class. Would it be possible to create a dynamic list of checkboxes that teachers can toggle for students who are present each day?For example, Class 1 Day 1 has 15 out of 20 students, and Class 2 Day 1 has 18 out of 25 students. I've already set up a parent-child relationship per class, but I'm now sure how to implement the dynamic checkboxes.Any Idea would help.Thanks
Hello Mobile Qrew! Thank you to all who were able to attend the Meet Up. Here’s a quick recap of what was discussed: Polina Georgieva, Mobile Product Manager, did a quick overview of the differences between Quickbase Mobile and FastField, and walked through the Quickbase Mobile New Forms and invited the group to join the beta and test here. The issue with data tables that prevented a lot of folks from using mobile has been addressed – great news! Adam Lanthrop, Product Manager, showcased the integration of FastField to allow Quickbase customers to trial directly FastField from their Quickbase Realm, access FastField directly from Quickbase, how to log into the FastField using Quickbase and how to access to the FastField mobile application by logging in with Quickbase SSO. He also showed the new forms AI where you can literally draw a form on a piece of paper and abracadabra! A FieldField Form was ready to go into the field! Want to see how it works? Here’s a 1-minute video! And
I have an email that I am sending out to customers that is from the Verifications table. I am pulling the info to verify from the Quotes table and all of that is fine. I also need to pull several fields from the Guests table, which is a child of the Quotes table (I have a summary table in Quotes of the Guests that are included on that particular quote). I cannot get the Guests pulled over into the verification email (which originates from Quotes). #1 When I try to actually pull the summary table from Quotes, it shows up as No Permissions when the email comes through (due to being EOTI). #2 I, for the life of me, cannot recall how to pull the individual fields over instead of using the table? Maybe that will allow me to include them in the email? I have attached pics. I am using 2 pipelines and a notification. Also, how do I clear out the responses on the verification after each entry (i.e. if I had to send it twice
It was my understanding that when a value is selected in a filter on a report, other filters would adjust to only include values from the resulting set of records - i.e. you could only select from values that occur in the record set you are viewing. For example, in a table where request types are grouped into categories, picking a single request category in a filter would mean you would only see request types relating to that category in the filter for that column.That's not how filtering is working, so ... has it always been this way, or has something changed?
Hi, I'm currently working on a project management application. The idea is that each project goes through different stages, and each stage has various tasks associated with it. With this in mind, I need to assign different people to each task, depending on the specific task. I initially tried using task templates and pipelines, but now that the assignments vary, I'm unsure how to handle it. For each project, there are different people responsible for different areas, such as the project manager and the permit coordinator. They are the ones who will be assigned to the tasks based on the specific nature of each task. I need help with this; perhaps it's easier than I think. Thanks!------------------------------Francisco Ojeda------------------------------
I have created the following Number Formula query in Table A:My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated.Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))
Hi - I'm looking to create a Line and Bar graph where the line and bar use the same axis. Is this possible? Seems to me there is no option to use the same axis only the option to use a line and bar on separate axis. Thanks
Hello All,I am trying to make a lien and bar chart that will have the academic year as the x axis, program pass rate as the y axis (bar), and national pass rate as the y axis (line). I am trying to show the relation of my programs testing scores for a particular year to that of the national average for that same year. When I go to graph this on my chart it does not show up the correct way/ is disproportional. I will attach a sample picture but visually the graph shows that the program pass rate is way below the national pass rate when it is the opposite. Is there a formula or another way to group the two by the same amount so it shows the right way ( it groups the program pass rate by: 1%, 10%, 100%, 1000% and groups the national pass rate by: 1%, 2%, 4%, 10%, 20%, 40%, and 100%)Any advice is greatly appreciated!
Hi, I have Tables and Fields:Employee Table:Fields: EmployeeID, EmployeeName, PhoneNo, LDAP, JoiningDate, LevelProject Table:Fields: ProjectID, ProjectName, JoiningDate, ClientIDClient Table:Fields: ClientID, ClientNameEmp-Proj Table (Join Table between Employee and Project):Fields: RecordID, ProjectID, EmployeeID, ClientID, EmployeeName, ProjectID-ProjectNameI want to implement form rule Set a rule like: “When EmployeeID is selected, show only projects from the Emp-Proj Table where EmployeeID matches the selected employee.”This will filter the projects based on the employee selection.I am unable to implement above rule after relationship establishment to tables . Please help or share screenshot to implement When EmployeeID is selected, show only projects from the Emp-Proj Table where EmployeeID matches the selected employee.”ThanksBharat
I wanted to see if there is any way to accomplish this in the legacy form rules. When Plan Terming includes DMO or PPO (This field is a multiselect field) andWhen negotiations status is any of these, neg1, neg 2, neg3 andWhen action is voluntaryrequire Term Type
Hi All,I need to make changes to the main form used by a table. The change would consist of taking an existing muti-select field and break it out into discrete fields making it easier from a reporting standpoint for other applications like Hadoop. What is the best approach to transitioning to an updated form, where I can use the older version of the form for reviewing older records, and then the updated version of the form when creating new records. I want to maintain reference to old form for historical purposes, but start to utilize the new form going forward. This is a legacy form for awareness and I'm hoping to keep using the existing form without having the need to create a new form all together. My initial thought was to use a hard fast date as the cutover, and I was going to leverage Date Created in a dynamic rule but noticed that doesn't get stamped until the record is saved. Any suggestions on how to accomplish this when the form loads to create new entries?Thanks in advance!-
Hello Construction Qrew! Thank you to all who were able to make the Construction Meet Up on Tuesday, September 17th. Here’s a quick recap of what happened: Kaity Strong, Solutions Consultant, did a walk-through of the CRM Bid Management APP (available in the Exchange) and hosted a customer Q & A on it. One of the features within the CRM Bid Management App she highlighted was the Bid Ranking tool which helps to determine level of importance and likelihood of winning the contract bids. The audience loved that feature! She also helped answer questions on how to deal with connecting contacts tables to multiple bids, and the pros and cons of scaling Quickbase apps vertically vs. horizontally with on-the-fly mockups in Lucid chart. We loved the questions and feedback from the audience! To check out the session, you can click the recording hereand type in the password: k&^7*VB+ Our next meetup will be on Tuesday October 22nd. The week after EmpowerPro! We will be using our next Cons
I have an app that contains the address field. It is working normally.I am trying to create a new app with the address field. When I type the address into the lookup portion of the field and select lookup, the entire field goes blank and the map says no location to lookup. The address is not propagated into the street, city, state, and zip code fields either.Is there a setting that I am missing?
I'm trying to find a solution to clearing 2 formula date fields based on a selection in another drop down field. I've tried to set up a form rule for this but it appears the formula date fields aren't showing as an option in the "then" section...what I'm needing is when the user selects case rounds type as MD requested to then clear and hide the 2 formula date fields as they are no longer needed. It will let me hide the field in the form rule, but won't give me an option to clear those fields. Not sure if there is a better/different way I should be setting this up?
Hello all,I'm working on an improvement to our accounts payable process. At present we use smartsheets and have vendors submit invoices via a form. After that the process falls apart quickly and I want to fix that using QB.My questions are about that initial vendor input. I know I can create a form and set permissions for EOTI, I've done that in the past to create a visitor access log and it worked well. In this case we want them to attach a PDF file.Is there a reliable way to restrict the file type to ensure we only have PDF documents uploaded? In the past I never had issues with spammers finding and using the previous form I had set to EOTI. Now that I'm dealing with attachments how concerned should I be of the wrong person finding the link and spamming us with hazardous attachments. I was thinking of having an intermediate app that collects invoice data and attachments to isolate it from our core app. Then using automation to validate the vendors as known and unknown. If the ve
I am wondering if it is possible to use a "User" type field and base its values on another fields value? For example, when a User that has the value in "Warehouse" field "Nevada". I would like to show only the users that have the "Warehouse" value "Nevada" in the User list field. When a "Nevada" warehouse user is viewing a record. Alternatively, if the user is a "North Carolina" user only show "North Carolina" Users in the "User" list field.Is this possible?Brian
I would like to set up a conditional drop-down for data entry in an embedded grid edit report while sitting on a parent record in edit mode. The conditional drop-down will depend on a value which is looked up from the parent record. In my use case let's say we have two company numbers, company 1 and company 2 and I want the conditional drop down to only offer products for the company that the Parent record is associated with. My problem is that when I go to do the data entry in Grid Edit the record does not yet exist so the look up doesn't exist so the conditional drop down fails. The only workaround I can see which I don't like it all would be to have a button which would automatically add blank child records when pushed and then put the parent record into edit mode. That way the children will exist and the look up will exist. But then I need a process to be deleting those unused blank rows all the time.Any other bright ideas?------------------------------Mark S
I have an Employee database and a database that houses all our company records,These two apps were connected years ago and worked great. I used it for two fields -two sale rep field that was connected. I copied over the database to start a new company. Some roles can not see these two fields. Even though i opened up all permissions on the table where the fields were being used. When I tested the role on my end it showed that they could use it, but user continued to show me proof that they could not. It was greyed out or the drop down was blank.I tried all sorts of things, even removed her user and gave her a new role. Nothing. I was going to go live in a day and couldn't get these two fields to work and went into a different direction - QB would not help because of the two apps connected. said it was beyond their scoop of help and I should upgrade to get better tech support -hahahah ( which I eventually did) waste of money and i am only 3 days into this new pack
Is there a way to force an email address field to force it to have a "valid" email address makeup? I realize I can't actually validate the email address itself, but I want to require them to at least put in an email address in a valid format? (I have seen this on multiple forms across the internet, of course.)------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hi, I am trying to set up a field which will check if all of the emails provided in another field of the form have got @X.com or @Y.com domains.The example of list of emailsa.a@X.com;a.a@Y.com;b.b@Z.comI would like to have a formula that would tell me that email b.b@Z.com has got a wrong domain and can't be accepted and that only domains @X.com and @Y.com can be accepted.
So, for years now this is one feature that has always eluded me due to the fact that I've never been able to get it to work.How does one nest multiple API calls in a single button? I've read the old article that talks about "rdr" and such, but the example only shows a single API call which doesn't help. Right now I need this single button to ADD a new record in a specific table, which it does, but then EDIT the parent and then RETURN to the parent in edit mode. This is what I have currently:var text URLTwo = URLRoot() & "db/" & [_DBID_TABLENAME] & "?a=API_EditRecord=" & "&apptoken=APPTROKEN" & (If([THING1]=false, "&_fid_312=false" & "&_fid_304=false","")) & (If([THING2]=false, "&_fid_36=false"
Hello QB community - has anyone successfully used QB for a pricing tool?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.