Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I have a client who is wondering if it is possible to track the visitor traffic to the code page/form we made for them in QuickBase. Is there anyway to possibly do this? Even something like increasing the number in a field by 1 every time someone opens the page will do.
Typically when an employee leaves an organization the first thing the Quickbase administration team is supposed to do is to put them on the Deny List. Those users, annoyingly, will still appear as drop down choices for any user fields where the user comes off the default user set. Is there any way to run a pipeline say each night to look for these users on the Deny list or with no access to the app and deselect that user from the green "Show is User Pickers" checkbox? ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
I am updating an app that allows EOTI users to add records (submit permit applications) to a table (Permit Applications) . There is a formula-number [Amount Due] field derived from several [*Category*] field values. The logic includes 40-50 hard-coded values (fees and expiration dates for pro-rating). The fees and dates will be changing in the near future. The payments are processed externally and not connected to QB. However, existing QB records will report an incorrect Amount Due when the hard-coded fees/dates change and be inconsistent with the external Payment system. I am considering 3 solutions to replace the hard-coded logic, but I am looking for feedback and/or alternate suggestions. Update the existing table. Create a new field for each of the 40-50 parameters and replace the hard-coded logic with the related fields. Use Default Values to initialize values for new records. Going forward, update the Default Value when fees/dates change. Create a new table (Parameters).
I created a rich text formula button that opens as popup. I would like to not see all the browser information at the top. Is there a way to hide this within the formula? Current formula var text RID = If(IsNull([Record ID#]),"%%rid%%",ToText([Record ID#])); var text URL = URLRoot() & "db/" & "bqwrgfdsi" & "?a=nwr&dfid=13" & "&_fid_131="&$RID & "&_fid_10=" & [Customer] & "&_fid_8=" & "QC Picture" & "&_fid_12=" & "OSP" & "&_fid_60=" & [Pole/HH Number] & "&NextURL=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=") & $RID; var text LABEL = "Save & Add Document"; "<a class='btn btn-info OpenAsPopup' style='background-color:#8fbb40; color: #ffffff; border:#ffffff; border-radius:28px; text-decoration:none;' data-replaceRid=true href='" & $URL & "'>" & $LABEL & "</a>"------------------------------Krista Sibery-----------------------------
Hi all, I want to create a table to cross check the bank account statement. Is there any way to create a table to calculate the balance base on the previous entry and cross check if it consistant with the "balance" entry? Vinco------------------------------Yiu Vinco------------------------------
Hello, I have 2 date fields, one of which calculates a duration in another field based of the initial date entered. I would like the duration field to stop counting once the second date field is completed. Primary date field is named Admission date Duration field is named LOS Secondary date field is named Discharge / Transition Date I'm unsure how to set this up. ------------------------------LB------------------------------
This may be a simple solution, but I am unable to figure out how to do it. We have created a new app that requires yearly review of records. All reviews are due by June 30 of each year. The first date for this will be 6-30-2024, but then, when a review has been completed, I need that date to change to 6-30-2025. Children is the parent table with Annual Reviews as the child table. I'm not sure if I can just do this on the parent table and or if it should be done on the child table. If more info is needed, just let me know what is needed. Thank you! ------------------------------Amy Gosz------------------------------
I have a Rich Text Formula to display values from fields in a paragraph format. I have searched and tried so many different things but I can't seem to figure out what I am doing wrong. Please note, I will add the else statement which would be for a female, but I need to get the first part fixed first. I'm not sure if the / in the field names is actually throwing the error or not. I don't want to rename them if I don't have to. For this version, the ) at the end is yellow highlighted and it tells me 'expecting text'. The fields are in green text so I feel I'm on the right track with this version. If([Sexo / Sex]="Male",[Primer Nombre / First Name]&" is an "&[Personalidad del Nino / Child's personality]&" boy who enjoys "& [Pasatiempos / Hobbies]&". He loves"&[Animal Favorito / Favourite Animal]&" and eating "&[Comida Favorita / Favourite Food]&". His favorite subjects in school are "&[Clases favoritas en la escuela / Favorite Subjects in Sch
Hi , I'm looking to create pipeline to import CSV file on schedule base, the file located in a virtual server on Azure environment. looking for the best way to do that. Thanks.------------------------------Natanel Sela------------------------------
I have a very simple problem that seems to be more complicated than it should be. I have a report that I would very simply like to report on the previous day. This works fine from Tues-Fri, however, when it comes to Monday it needs to be manually adjusted for Friday. QB does not seem to have work days built into the date field. I've tried a few report formulas which can display the previous work date just fine. Though I cannot for the life of me figure out a way to filter the report on that date. Another option would be to somehow make a formula that shows the number of days in the past that the previous work day occurred. Any help would be much appreciated.------------------------------Cody Mckelvey------------------------------
I am trying to populate a table named Metrics using formula queries. I populated several fields from the Opportunities table with no problem. See Attachment. I am trying to populate # QWT Leads (number of qualified water treatment leads) from the Leads TBL with no success using the following formula query: var text QUERY = "{145.OAF. ' " & FirstDayOfMonth([Month (First Day)]) & " '}AND{145.OBF. ' " & LastDayOfMonth([Month (First Day)]) & " '}AND{80.CT. ' " & "Qualified" & " '}AND{81.CT. ' " & "Water Trmt" & " '}"; Size(GetRecords($QUERY, "brravks49")) 145 is a date field, 80 is the Lead Status and 81 is the lead type, all in the Leads table and "brravks49" is the Leads Table. What am I doing wrong? ------------------------------Denis Rochat------------------------------
Hello all, hopefully someone can help me figure this out. I have a large daily data set that has fields by time, both by hour and by actual time. I am looking to separate some of the records into a particular time period. Is there a formula I can use that will add a checkmark to records between the hours of 12 and 16 (4pm)? I'm currently at a loss, and formulas aren't my strong suit to begin with. I appreciate any feedback.------------------------------Rachel Difiore------------------------------
I'm looking to convert a text field into a number based on what the text field says. Example: If the content is "1 - Low confidence" convert to number "1". Thanks!------------------------------L Green------------------------------
I just figured out how to enter App "Categories". Problem is, I seem to have run into a limit. I was trying to create a category for each department. Seems as if I can only create 7 categories. Is that accurate?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hi guys, I have a question for converting number to text in QuickBase. For example, I have a numeric field show £29,190.90. But I want it to show as Twenty Nine Thousand, One Hundred and Ninety Pounds and Ninety Pence Sterling. Can someone help me please? Thank you!!------------------------------Harris Tse------------------------------
Hi guys, I have a question for converting date to text in QuickBase. For example, I have a date field show 16-02-24. But I want it to show as 16th February 2024. Can someone help me please? Thank you!!------------------------------Harris Tse------------------------------
I have two tables - Departments and Divisions. They are related in that each Department can have multiple divisions. Works fine on the parent table. Where I need help is using that in another table. In table 3, i have Department and Division fields. But, I want Division to ONLY be the available options based on Department. For example, if you choose Public Works, then I only want Solid Waste and Admin to show up, as those are the child records of Public Works. But, if you choose Information Tech, I only want the options of IT and GIS to show up as it's children. How to do this?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Is anyone willing to share what price they are paying per read. We used to be on a user based plan and paid around $30k annually. We were then forced to move to a usage based plan where our cost skyrocketed to $250k annually. I was mostly ok with this because our usage and apps had grown significantly. The next year we had another increase in price of $100k making our total $350k annually. Well we are now up for renewal again and I was told that our account is being flagged and that we now have an additional $200k increase, which makes our total $550k annually. Keep in mind that our usage and apps has not changed in 2 years now. I was told that the driving factor was that we were receiving a price per read of 17 cents and the current MSRP is 24 cents per read. I have been reading on reddit and here that people are getting a price per read of 11 cents. So we went from $30k/year to $550k/year in just 3 years. How can they do thi
My Dashboards, and I assume everyone's, are a 9*12 default size. I know their can be multiple tabs. But, can I increase the size of a dashboard? I couldn't find a help article on this. If I can, how so?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I have an application in which there is an intake (Parent) table which can then be assigned to different users across multiple (Child) workflow tables. Since there is a user assignment for each child record, how can i possibly summarize the users across the multiple child records and display it on the parent record?------------------------------MICHAEL SARGENT------------------------------
Hello Community, I'm relatively new to QB and hoping this is an easy one for someone. Background: Parent Table - Orders Child Table - Actuals Relationship One-To-Many Orders -> Actuals The Child table (Actuals) is a timecard export (csv) from our enterprise software that I plan to update periodically using manual refresh as part of the Connected Table functionality. The child table has many timecard entries for several orders. Ultimately, I'd like to create a report from the Parent table that summarizes fields from the Child table. eg. Sum of JTD Hours related by the Order #. So, I've created a relationship between the two tables and added summary fields to the parent table. When I run the report and use the summary field in the report the data is blank. After reading several discussions I've played around with Reference IDs, Keys, Proxy fields, formulas pointing to other fields, join tables but I haven't been successful. From what I g
I have table that I columnar averages, not totals. I can't find that setting. Screenshot attached.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
We sell services to clients for an hourly rate. The workers who perform the services then get paid either a percentage of that rate, or a flat amount [yes, I know the flat rate is also a percentage of the total, but Accounting wants to be able to enter it as a flat rate because of other factors]. So if I have two fields - Percentage to Pay and Amount to Pay, what they want is to be able to enter either one, and have QuickBase calculate the other. For example, the hourly rate is $110. They want to enter 65% in the Percentage to Pay field, and have the amount calculate as $71.50. If, on the other hand, the pay to the worker is defined as $71.50 an hour, then they want to enter $71.50 in the Amount to Pay field, and have the percentage calculate as 65%. Is there a way to allow this? ------------------------------Charlotte Morin------------------------------
Hello Rocky Mountain Qrew! Today is the day and we are excited for our first meeting focused on Generative AI. As we are going to be creating app framework utilizing Smart Builder, we advise everyone to have a builder account for today's event. These are free personal accounts you can open that will allow you to build without restrictions. Your work-related account may have governance around creating apps or using AI tools so this will ensure you can enjoy the full experience. Please reach out to Mike Westin or me if there are questions ahead of today's collaboration. See everyone at 4pm!!------------------------------Nico CantilloECSM------------------------------
Is there a way to customize email reminders to only include the columns needed? Presently the email reminder is sending an email reminder that includes all available columns in the table. In this particular table it has over 300 fields.------------------------------Kimberly Massa------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.