Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a list of "Project Types". Attached is a summary report of this table and field. But, I really want to show it in a Pie Chart. Specifically, I want "Commercial EPR New Build and "Commercial NewBuild" grouped into one category and then all others in a "Other" category. I am thinking a report formula using the Count function. Is that right?
Hi all -- two part question here.I am trying to create a change approval flow for a complicated approval matrix. I have designed a table to pull user names for each approval "role" from a related table based on a field (region) in the record. Where I am getting hung up is that depending on the content of another field (change type) some "roles" don't need to approve. I thought I could create a dynamic form rule to delete the content in the unrequired "role" fields, but realize that I cannot change that data since it is pulling from the related table. Is there a better way to manage this matrix with multiple dependencies? Example below:The linked Table contains Multiple Regions Role-->FinanceOperationsMarketingRegion AsiaBillLiamAnneEuropeStephPaulMaria Each Record in the Change Request table is linked to the region and has a change request type. For change type 1
Wondering if anyone has heard any updates on the plan to phase out Webhooks in June.It seemed to me that idea had perhaps the most backlash of any, and by a lot of the most prominent users and QSPs. It is seemingly unanimous by the community that it is a very bad idea.I am very curious to see if they actually respond to feedback as they promise they will, or continue on with their plan.
Within any table in any app, there is a link right on top for "Reports & Charts" for that particular table. And as soon as you click it, the first potential two sections are Recently used reports, and Mine, reports I've created. Then all the common or other group reports after thatAbove the list of reports is a New & Organize button to either make a new report, or organize your existing reports.Why does the Organize only allow you to update the "Common" reports, or a separate group of reports, but not your personal ones under the Mine section. The Mine section is alphabetical, and will not let you change it. It doesn't make sense that you can change the order in every other report group header but your personal one.Am I missing something?
OR my state abbreviation breaks Quickbase filters. Does anyone have a formula to share?
Does anyone know why my users listed in my list-user field that is a lookup from another table display in red? Usually the red means the selection is not a valid option, but since this is a lookup field, that shouldn't apply. I noticed this a long time ago in a different app and it's always bugged me, but when it just came up again, I had to ask! Thanks!------------------------------Brittany Zane------------------------------
Hi all, I am creating templates for our projects that contain a set number of tasks done in a specific order. I want to use a pipeline to create and schedule tasks when a new project is created. I'm running into a roadblock where I can't figure out how to keep the predecessors of the tasks so we can set a start date when the project is created, and it will populate all future task dates. I hope that makes sense. The pipeline is working fine to create the tasks, but I can't figure out how to set the predecessors. Here is my table structure (simplified):[TABLE] Template Projects- Project Name[TABLE] Template Tasks - Task Name- Duration[TABLE] Template Project/Tasks Associations- Related Project- Related Task- Predecessors[TABLE] Project - Select Template (Related Template Project)- Start Date[TABLE] Tasks- Related Project- Task Name- Duration- Start Date- Project Finish- Predecessors(Please be kind, I am new to this)Thanks in advance!
When I save it reroutes me to the previous screen instead of the saved record. I'd like for it to stay on the record each time without having to go to the dropdown for save a keep working every time. Can i default it to this save option? This is the New Form
** Update:I managed to retrieve the ticket ID by using {{c.json.ticket.id}}The only one which remains is to do the same for the users, though that is not reading the value when formatting the jinja the same as the ticket request, even though the structure of the .json is the same.Hi Everyone,I have a Make Request, which has an endpoint which is pointing to our Zendesk instance: https://instance.zendesk.com/api/v2/users/search.json?query=email:{{a.email}}As you can see above, I am using the email address which is stored in the record field a.email - this checks if this end-user exists on Zendesk.After running the pipeline, it returns the following in the Output (I've redated extraneous data){"users":[{"id":13617301225116,"url":"https://instance.zendesk.com/api/v2/users/13617301225116.json","name":"Nick Green","email":"redacted@gmail.com"]}extra data redacted}In the above users array it has the "id":13617301225116 value which I would like to send back to the Quickbase record to populate
I have a due month formula field that needs to be sorted and reported by date and not by text. I'm trying to have it show as MMMYY (JAN24, FEB24, etc) since it's just a due month and not a specific date. I have a "dummy" date field that's the first day of the month, and I am using a formula text field to get the right formatting I need. I have the date field formatted as the abbreviated month, but it still includes the day.I'm using the formula below, but it says the first Month (red and bolded below) can't be used as a variable name. I copied this from another thread that worked for everyone who responded in it. What should I put there instead to get the date to change to the text month? Am I missing a step somewhere? Is this even the right way to go about this? var date DateWords = [My Date Field];var text Month = Case(Month($DateWords),1, "JAN",2, "FEB",3, "MAR",4, "APR",5, "MAY",6, "JUN",7, "JUL",8,"AUG",9,"SEP",10,"OCT",11,"NOV",12,"DEC");$Month & " " & ToT
Hi, so I am having the user choose what type of employee they need to hire.if they're hiring a contractor, they'll also have a choice to an a full time position to convert that contractor later in time. I'm thinking - if they want the contractor data (Department, Level, Role) the same for the Full time position - I'd like to to have them click a button "same for Full time position" that will push that data over to the new fields for the full time detail. This would all be on the same record and form.Thanks!
Hello,I'm trying to count how many records I have that have for Field "Account Name" that contains the work "Wire" and the Field Name "Funding Indicator Name" that contains ASC. I'm not getting an error for the way I did the formula but its not counting when the two fields on a record have the "contains" word.If((Contains([Account Name],"Wire" & Contains([Funding Indicator Name],"ASC"))),1,0)Appreciate any suggestions. Thank you
Not sure that's a great title, but it's the best I could come up with right now. I created the below table for ease of end-user data entry. (To increase adoption rate and reduce pushback.)I would like to create fields/or a table, that would basically take the column headers and the associated numbers into the more useful table that has a multiple choice field for offense type, the date and # in the column. I believe this is very doable, but I am just drawing a blank tonight.
I have an NDA project that I would like to restrict from "public" viewership. I have created a field (checkbox) to identify an NDA project. I then went to the dynamic form rules to create a rule to hide specific tabs. However, doing so has a reverse effect on all other projects. Is there another way I can isolate these types of projects?
Please comment like and subscribe. We are checking to see if comments are getting sent back to contributors.
Hi guys.I am currently working on a project thats going to automate role granting process based on the requests in ServiceNow so I am looking to utilize the HTTP API to grant user a role through API_AddUserToRole. First I want to export current roles related to all active apps in Quickbase - a whooping 429 apps to be able to create a predefined drop-down (we are currently not creating more roles/apps).I understand that through API_UserRoles call I can get all roles associated with one app, so if it means that an account with admin access on all apps can generate list of all roles for all apps.How can I streamline granting such admin access to 429 apps? Or granting some access level to all apps?Any advice or strategies would be greatly appreciated.
Is there an easy way to rename all historical records in a field (similar to a find/replace in Excel)? We've changed the name of a specific group of people: Something along the lines of "reporters" will now be called "reporting party". In addition to changing the text option in the dropdown for newly created records moving forward, is there a way to do find/replace type function within QuickBase for all existing records? I suppose I could export all records, change them in excel and the import them back, but there are a lot of existing records and I'd prefer to do this within QuickBase if possible.
Hey QREW! The Rocky Mountain QREW group is planning an Empower Happy Hour recap if anyone is interested. Let's chat about the fun tidbits from Empower together, come join the Rocky Mountain Qrew Group for more details! Rocky Mountain QREW Group: https://community.quickbase.com/group/rocky-mountain-qrew
Hi,I want to create field of 'Record owner role' and see his role when new record is opened (before saving) in order to restrict some fields with rule. Is there way to see record owner role (not user role)?
This is probably common knowledge but I'm having trouble finding the answer. If I change an existing field entry on a form from a radio button selection to an auto-populated field based on a formula, will only new entries be affected or are there other considerations I should be aware of to ensure I don't lose historical data?
I'd like to create a QR code that pulls up a record in the QB app on a tablet when scanned with the tablet's camera app. This QR code would be a field in my Packing List table. When the packing list is printed out by our office staff, the QR code will be printed as well.Our warehouse team would like to scan the QR code and be taken straight to the record of the packing list in the QB app on their tablet instead of looking for the record in the app.I've had some success generating QR codes but having trouble directing to a record. Here's my code for the QR code."<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="&[QR Code URL]&"\"alt=\"\"/>"where [QR Code URL] is 'https://cfkent.quickbase.com/db/bpc9xkysz?a=dr&rid=[Record ID#]------------------------------Howard Fu------------------------------
Hi, From the previous post (Add Save and Keep Working Button on form for a new record ), Hunter provided a wonderful solution to save the new record.If going further, is it possible to edit the new record within the same URL? I tried the following, but got the error message "Missing "rid" parameter""URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=%%rid%%"&"&_fid_20="&URLEncode("Yes");My intention is to use one button instead of two buttons to provide the function:(1) save the current new record (2) edit this new record. Any suggestion? Thanks in advance!
I'd like to have a field on a form automatically populate based on if a specific text string exists inside of another field. Let say field 2 will be populate with the text "red squadron" if field 1 contains the text "red". Can I do this with a formula using contains or would I need to create a table where all possible combinations that contain the text "red" would align to being in red squadron?
I'm using the API to create records, from time to time I get an error that says incompatible value, today I got it again:"lineErrors" => { "7" => ["Incompatible value for field with ID \"43\".", "Incompatible value for field with ID \"93\"."] }This is the record in question:{"6"=>{:value=>blah}, "11"=>{:value=>"2024-04-16T07:59:30-05:00"}, "12"=>{:value=>"2024-04-16T14:50:00-05:00"}, "13"=>{:value=>"blah"}, "24"=>{:value=>blah}, "25"=>{:value=>blah}, "43"=>{:value=>21418}, "93"=>{:value=>269}, "15"=>{:value=>11356}}There are 3 more record that are created properly, those 3 records share the same values for 93. I also check the records for the value on column 43 and all those exists.It is driving me crazy. Any idea?
I am having difficulty getting my mind around this to even begin.I need to summarize the Revenue for a project: The Revenue Date can be a single, or multiple dates, and the Revenue Amounts can vary.Upper management wants to see this on a single form, which is no issue as I have the following: Revenue Start 1, Revenue 1, Revenue Start 2, Revenue 2, and so on.The issue is how do I create a Summary Table that combines all the Revenue Start Dates in the correct month column and the Revenue Amounts?The Summary example below is when we had one record (form) for each Revenue Start, and Revenue Amount.I need the same thing when all of these dates and amounts are on a single record (form)...
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.