Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have so many complaints from users and receivers that the reports that are being sent out automatically are horrible looking because it's in the new style. When I even click off that green toggle and send manually it comes out the new style. Is there any way anyone has fixed this horrible reports? I have searched on here and I know lots of people years ago hated it then when it was released. Since I started the new email that can be sent out to non QB users the format is horrible. Maybe I need to go back to the way I use to do it- send it to me and forward out the email. PIA that is..... I was also told that if I bought the extended package that QB offers they could fix those reports. I highly doubt it. thanks for any insight - I think it's a long shot
Is there still no way to reset a user field custom list to blank? I have nearly 1000 users. If I want a customer user list, I have to click remove user 1000 times, then slowly add back in. Is there still really no other way??------------------------------Mike Tamoush------------------------------
Is there a way to filter the record picker based on value in other field?Ex: picker shows name, email, departmentWant to filter picker to only show records in picker that have a certain department
Is it possible to use GetRecords to query a table in a different application? The formula only seems to accept the table alias for tables within the same application.Thanks for the help.
Hello,I am hoping someone much smarter than I can help solve this puzzle.I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords()) formula query in order to showcase how many records the user can expect to generate. The first thing I did was to go to the report, unswitch the 'new style', choose 'more', and then select "show expanded url for this report". Which gives me this (made minor change to allow the formula query to save):Size(GetRecords((("{'33'.IR.'this+wk'}OR{'33'.BF.'today'})AND{'76'.XEX.'No+Street+Address'}AND{'61'.XEX.'No+Employer+Name'}AND{'68'.XEX.'0'}AND{'19'.EX.''}AND{'82'.EX.'Send+Letter'}AND{'60'.XEX.'ABC'}AND{'69'.XEX.'Paid'}AND{'69'.XEX.'Promise+to+Pay'}AND{'69'.XEX.'Escalated'}AND{'17'.EX.'Delinquent+in+30+days'}")), [_DBID_ACTIVITIES]))The above expanded url equals the below (report parameters)How can I modify this expanded url and turn it into a workable formula query?Any and all tips/ t
Is there a formula that can be used in a summary report to show the average rating of only the last 4 entries of a given part number? Current table is simple with 2 fields. A part number is selected through a relationship dropdown, then the selected part number is then given an inspection rating of 1, 2, or 3 based on inspection criteria, then saved.Background:I am attempting to setup the % of parts to inspect based on the average rating of the last 4 inspections. My issue lies in the fact that not all parts are delivered and inspected on the same schedule (i.e. weekly, biweekly, monthly, quarterly or biannually) so I am unable to use a time period to capture an equal rating across all parts. Without a formula that only captures the last 4 entries of a part number, I fear I will need to add and manage a dropdown of "delivery schedule" on 1000+ parts to allow filtering to capture the last 4 inspections completed. (or keep using the 15 spreadsheets that I cur
Have a formula that I can't find what error is. Error I'm getting is:column: 81 > Expecting , Any help appreciated.Here's my formula:List(", ", If([Approval Status] = "Pending", [Related Administrator Name]) )
I have a field in two of my tables entitled "Group ID". When these fields match, I want them to populate a third field called "Household ID". Is this possible? I've tried formulas and other ideas, but no luck.
Hi everyone,I'm currently exploring using QuickBase within the construction industry and would love to hear from those who have experience with it. Specifically, I'm looking for insights on the following:Pros and Cons: What do you find are the major advantages and disadvantages of using Quickbase in construction projects?Functional Requirements: How well does Quickbase meet your specific functional needs? Are there any gaps or challenges you’ve encountered?Technical Complexities: What technical complexities or challenges have you faced while implementing and using Quickbase? Any tips on overcoming these hurdles would be greatly appreciated!Thank you in advance for your feedback and experiences. Your insights will be invaluable as I navigate this platform!Best,Prachi Thakkar
I have AND statements nested in an OR statement and it is not working.I initially simply tried to say:If "Asset Sub number" is anything other than 0 and "Should this asset share a tag with Master" = "Yes" then make "Send Tag to FA team" editable.ORif "Contact (First Last Name)" is not blank AND "Tag will be mailed to this address" is not blank then make "Send Tag to FA team" editable.This did not work and so I elaborated on the above as shown in the screenshot. That too does not work. As soon I type in a Contact (First Last) name, the "Send Tag to FA team" becomes editable.You can see from the OTHERWISE statement that it did not read my logic correctly at all.How do I fix this? Thanks!
Hi , I am currently using quickbase trial account which will expire soon. I have created builder account with same email used for trial account . My question is will I be able to access existing app created by trial account after its expiry through builder account .Thanks,BR
So I have pipelines to import and update data from quickbase to Google Sheets to essentially mirror each other.I just tried a pipeline that imports data from a newly created record to Google sheets and got this error message:Remote service reported an error: Invalid JSON payload received. Unknown name "values": Cannot bind query parameter. Field 'values' could not be found in request message.When I update a record I get this message: Remote service reported an error: Invalid JSON payload received. Unknown name "dataFilters": Cannot bind query parameter. 'dataFilters' is a message type. Parameters can only be bound to primitive types.I am having a hard time figuring out what this could be as my test environment pipelines for google sheets work fine.Any insight would be appreciated.Thanks,James
Hi all - I have a dataset importing into QuickBase but the dates arrive in EPOCH time (milliseconds since 1/1/1970). These import into the field dtmDateCompleted, a numeric field. I am trying to create a formula date/time field that will convert the EPOCH date into the correct format for reporting. If the record does not have a date completed (dtmDateCompleted is NULL), then this formula Date/Time field should remain blank. I have the conversion for populated fields functioning correctly; however, for dtmDateCompleted fields that are null, it is listing 1/1/1970 instead of leaving the field blank. TL;DR, the below formula is not accepting the first IsNull() condition in a formula date/time field. This is the formula I have so far: If(IsNull([dtmDateCompleted]), null,If(not IsNull([dtmDateCompleted]),(ToTimestamp(ToDate("1/1/1970"), ToTimeOfDay("00:00:00")) + Seconds([dtmDateCompleted]/1000))))Thank you!
I have two tables (Table A and Table B) ---- the tables are not related. I would like to embed a specific record from Table B (using the old record form) into a record form within Table A ---Table B -- I have a number field called [Index]. The index field is unique but it is not the key field. The specific record from Table B I would like to Embed into a Table A form is where the Table B field [Index]=1I assume I would need a URL formula field in Table A -- that has the "Embed as iframe in forms" checked. I need help with creating a formula that grabs the record from Table B where the [Index] = 1Any advice is appreciated.
Hello,I am new to using the Copy Records step in Pipeline.I have a pipeline running with no errors but also creating no data. It's activity log reports that it skips all of the source table's records, even when there is no query. The Merge Field is set to the Record ID#, which was the only option to choose.The pipeline structure is simple:Step A: Search a User tableStep B: For each User found, copy the records from a Master table to a Child table. Are there more steps to implement to use Copy records?
I have a table-to-table relationship set up where the names of clients should pull from one report into another where we are entering data for that client. The parent table is the report with the names of clients and the child table is the report where we are entering the data. I am trying to get a lookup field set up to pull the clients name, however the look up field is not generating the actual names, it only generates the number of names there are. I need help, lol. I am not tech-savvy; my boss thinks I am. I've attached a photo; any help is super appreciated.
Hello, does anyone have a formula saved to determine whether a numeric field is an odd or even number?Thanks!
I have a table that could have multiple records where the member id# is the same. I would like to display these additonal records on the form of each record that is related. I am using the new forms and tabs. I want to display the records on a tab. I was thinking it would be done by a summary report but I can't see how I can filter that summary report to match on the member id#.How would I go about this?Thanks
Hello All, I need a help with formula for converting the existing records to upper case and also want to put a check which converts new entries to standard format. I have a Name field where some entries are lower case, some upper case, some with space and extra. I want to make sure1.That all the names are converted into upper case.2.Whenever a new entry is made, even if it is done in wrong format it gets converted into standardized format. Currently when I am trying, to use this from advanced settings, no field is getting converted to upper case, and also checking the " Turn custom data rules on" option it is restricting me from adding any new records. Can someone please guide me on how I can achieve the above result, please
Hello!I am wanting to create a report that easily identifies missing data/blank fields in my app. Most of these are text fields, but we have some numeric and date fields as well. In short, we want to monitor that data is being effectively entered without making every field mandatory. I would love if I could just run a summary report based on blank values on the specified fields to generate something similar to the dummy table below, but I have been unable to figure it out as currently configured. FieldQty MissingClient POC - NameXXClient POC - EmailXXClient POC - PhoneXXAdjuster - NameXXAdjuster - PhoneXXAdjuster - EmailXX Any help is much appreciated! Thank you,
Is it possible to export/convert data to a Geojson file? Or are there other solutions?
Hello,I need help with rounding up a whole number in Quickbase. My formula in Excel is =IF(ISNUMBER(D59),IF(ROUNDUP((Q55/10),0)<5,5,ROUNDUP((Q55/10),0)),"")Round doesn't work when the number from the formula in Quickbase is over 100 or larger.I want to be able to take something like 2,250/10 = 225(Q55 in formula above) and have QB give me 23. If I put in 1 in my formula it would give me 5. 1/10=.1 returns 5.Thanks in Advance. Jennifer
Does anyone have any idea why I am getting this error when trying to update a record in a table from another record in another table?Validation error: Invalid date/time value: 0.0I don't have any date/time values that are being updated. They are all date values being updated by date value fields.
Hi all! Happy September and back to school season :) Here with another monthly Qrew meet up for this group. We are planning our next meet up for Tuesday, September 24th from 1-2PM EST for another product-focused session.Thank you to all who attended the August meet up regarding our Product roadmap and Pipelines questions. We are continuing our focus on the product with another session picking up where we left off last time withsome Pipelines-specific tips and best practicesan overview of our most recent Beta programs and how you can get involveda preview into what our first annual EmpowerPRO will look like Please join us in two weeks, and find the registration link here: https://quickbase.zoom.us/meeting/register/tJckc-yvpz0qEt2FbURadjK-QHvCYVZ96WiMIf there are any specific questions or suggestions on topics, please feel free to drop them in!
Hey!I have an idea, I want to build a Quickbase Application that is designed to operate as a Resume Builder but... with the idea of using D&D as the sort of UI.Purpose: The primary purpose of the app is to showcase professional experience, skills, and accomplishments in a unique and engaging way by using a Dungeons & Dragons (D&D) character sheet format. This approach not only highlights traditional resume information but also gamifies the experience, making it more interactive and memorable for potential employers and colleagues.Scope: The app will encompass various elements of a professional resume, translated into a D&D format, including character attributes (skills), campaigns (companies worked for), quests (projects and achievements), and other relevant experiences. It will also calculate and display character attributes (Strength, Dexterity, Constitution, Intelligence, Wisdom, Charisma) based on the user's professional experiences and skills learned during their c
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.