Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I need to have a report on my home page that has filters but I want to protect it from having users make changes to it. I have the report on the table home page and users utilize the filters available and oftentimes, because they are given the option, will save their changes and in doing so not make it usable for others (because they have filtered out other users/offices data). How can I have the report available to everyone, but not editable?
I am trying to create a report that will display records with the following rules. Each record has a date field (30DayReview). The record also has an "Approved" Checkbox and a formula checkbox that is checked only if a document is uploaded to a File attachement field.Currently the record shows in the report When the Approved checkbox is checked. When a document is uploaded to the attachment field, the formula checkbox field becomes checked and is dropped from the report. This is working. I would like to add the option to over ride the current rules with one rule saying that if the "30DayReview" field is older than 70 days in the past simply drop the record from the report regardless if the other rules are true. Here is where I am at:On my Test record the "30DayReview" Date field is set to 06-01-2024 12:00AM well outside of the 70 days in the past. The Approved checkbox is checked. The Formula checkbox field is unchecked.Wondering why
I have a form that uses dynamic rules to show fields based on a selection from a location box. This is working as expected.I added an additional layer where if I chose a GERMAN location, an additional field would pop up above the field with the German translation of the English field label. I made the translated field a formula fields with no actual formula so it was literally just a label. Once I set up my rules, I found I got a form error stating that there was a limitation of formula fields with dynamic rules. I believe this limitation was 40 and I had 53 (and needed about 10 more)I made some changes and the error is gone, but I also have no translations. I started fiddling around and found that I didn't need to use a text formula, and I could use just TEXT and make it read only and it would only show the label.Does anyone know if this will allow me bypass the limitation on dynamic rules? I am pretty sure the error specifically mentioned formula fields in the limitation,
I am working with webhooks in a pipeline to obtain parts info from Upkeep (a CMMS software). So far, I have a pipeline that receives parts info from a specific location into a JSON format. I used a Webhook step in the pipeline with an HTTP Digest request, URL Encoded content type and was able to get the parts I need without an issue. So far, I can use that JSON info (I can call it with "a.json.results" to reference the whole array, or "a.json.results[0,1,etc].'attribute (part #, name, etc)' " to call out a specific attribute from one of the returned parts (objects).My question is if there is a way to take the array of JSON results and parse that out into separate records in a QuickBase table? As in take the 100 or so parts that are returned, and create 100 records with the corresponding part #, name, etc. I attempted using the "Fetch JSON" step to then use an "Iterate Over JSON Records", but for some reason could not get that Fetch JSON to return any useful results like I have be
It looks like a number of you did not have an invite for today's meeting. I'm not sure what's going on but we'll investigate on our end and find out what happened here. We will make sure there is more advance notice for our February meet up so that any invite issues (should they arise) can be ironed out ahead of that.In terms of today's meeting, we got some got some great ideas for topics of discussion for future meetings. We'll be posting those in the next several days and looking for additional recommendations from the rest of the community!
Hello Ladies and Happy New Year! We have a meetup scheduled for Jan 21st from 1-2pm ET. We have a couple of topics we thought we could discuss to kick off the new year: Empower 2025 is scheduled for March 31st and April 1st. Who's going? Who's gone in the past and can speak to their experiences? We can give some insights into what's being demoed as well. Goals and discussion topics for the Women's Qrew in 2025. Do we have any goals we want to accomplish as a Qrew group? What product areas do you want to learn more about? Are there other discussions you'd be interested in talking about? If you have any other thoughts for agenda items, post here or feel free to bring it up on the call when we meet. Look forward to seeing you all!
I have been using the ole Magic Buttons "Multi-file Upload" with a code page for years, love it, but it does not function correctly with the new forms. It will add the files behind the scenes, but it will not return & refresh. If I use the back-button and refresh, all is good. - messy with new forms.Is there a way to fix the ole Magic Buttons "Multi-file Upload" code pager to work with the new forms?Now moving on to new forms....Using the lates QB Plugin for drag & drop upload of files, it simply will not save the parent before adding files, which clearly creates a relationship mess if you continue. Removing the button on parent add records creates another mess of users not updating or adding files.Within the button of execution, is there a way to save and go directly to uploading files when clicking the plugin button to add files? save the parent and enforce the upload of file(s).
Could you please let me know if there’s a way to update the values of columns C, D, and E for multiple rows within the same group when updating a record through a custom form using a button or checkbox?We can use filter on Grid and update one by one and Form rule to update a specific record Is there any way
Happy Monday. I work with managers to review many records, we make corrections, add notes and hit "Save and Next". Over the last few weeks, not sure what happened, but the "Save and Next" Option seemingly randomly disappears. Now I have to back out and go in a gain. Very irritating. Any ideas?
Hey!Mainly for aesthetic reasons, I am attempting to create a Formula Rich Text Button that just points to the Report Link (Built through a relationship). "<table style='width:100%;border: 0px Solid White'>" & "<tbody>" & "<tr>" & "<td style='vertical-align:top;text-align:Left;'>" & "<div " & $stylebtn & ">" & "<a href='" & [Report Link] & "' style='color: inherit; text-decoration: none;'>Tittle</a>" & "</div>" & "</td>" & "</tr>" & "</tbody>" &"</table>"The Formula returns no errors, but when pressed it just returns bac
I have been building a series of dynamic rules this afternoon and hit a snag. Basically, I have a list of questions that need to be filled based on location.Each question COULD be asked in multiple locations. I went thru thinking I could create rules to SHOW the question depending on the location. My problem comes when I have several locations which is basically are the EXACT same rule for a different location. I am finding the question only shows for the highest number rule. I did some googling and confirmed what was happening regarding the rule number. It seems the easiest way to fix this would be the ability to use an OR statement in the condition of the rule. I see several articles mentioning the same thing, but it doesn't seem particularly clear - I can create the initial rule, then choose ALL or ANY for subsequent rules. Is there no way to do an OR here? Should I be looking at this a different way?My example is similar to this:Boston Q
I am having a bit of a problem building a dynamic rule. I have a basic app, 2 tables. LOCATION and WALK. The location table is basically 2 important fields - Site and Area... Site would be the actual location of the walk, where area is a sublocation. So like - Site = Boston_Office Area = Cafeteria. The WALK table is a list of questions that we ask when doing a walkaround. These questions can be slightly different per site/location. There can be multiple area's per Site. In the app, the dropdown is LOCATION where we can choose the combined SITE-AREA. When I select it, it shows both the SITE and AREA in seperate boxes. The relationship is one LOCATION to many WALKS.My question is this. I am trying to show/hide fields based on location. I customize the WALK form, and go to set up a dynamic rule. I can see a SITE field in the list of fields I can use for a rule. I wanted to do a rule IF SITE IS NOT EQU
Just a quick FYI... We're doing some maintenance on the Community platform on Monday, January 20, 2024. We expect little to no interruption but wanted to shout it out just in case. Read about it on the Quickbase Status Page.
I have a form that is a series of text boxes with a label. 90% of our users all read English, but we have one location in Germany where some users do not.When customizing the form, I can see how I can add a text label. I was thinking I could add one of these text label fields for each text box I have which would be a German translation of the English label. So far, I think this will work for me. However, what I REALLY want to do, is this. I have a location dropdown on the form. I am already using dynamic rules to hide certain text boxes based on location. I would love to be able to hide the text label with the German translation for each text box by default, and then if I select GERMANY in the location dropdown, the dynamic rules would make the German text label visible. From the initial look of things, I can't do this. I am hoping someone can tell me I am wrong and may have an idea on how I can make this work.Thanks!Brian
We want to know when an employee's birthday is upcoming. We capture their DOB in a date field, so how do I get that month/day information in a format that I can use in a Reminder notification?------------------------------Keith Hendrick------------------------------
Hi, Mobile Qrew! We've put together a list of some handy things to do with the FastField integration in this Community blog: How to make the most of your FastField integration.It covers how to create FastField forms from Quickbase tables, use the AI Form Converter, manage users between accounts, and more. Feel free to ask any questions or leave feedback here for discussion. Thanks!
Hello, Wondering if anyone currently gets or moves the QuickBooks online invoice as a pdf into a QuickBase attachment field? anyone have any solutions using API, pipelines, or zapier? ------------------------------Manny Hernandez------------------------------
Rather than relate 1,000 records individually, is there a way for me to select/filter multiple records and then have all those relate to another table all at once?
I was wondering if there is a way to do an "editable lookup field"? I have 52 tables - one strictly for contact information for all US states, and one for each state that has some of that contact information, as well as some added columns for tracking our data on them. These tables do need to be separate with the way our workflow and filters need to be set up. I would like to be able to set it up to where if we are working on the tracking table and we find a better email, if we update it on that document, it updates on the master contacts. And vice versa, contacts updates our state's tracking sheet. I believe lookup fields are non-editable by nature, so I didn't know if you all would recommend something? I have lightly tested out a pipeline method for this, but I would need many pipelines to accomplish this effectively.
I have a field to display a thumbnail image;the formula is If([Image File (jpeg)]<>"" ,"<img style='max-height:200px; max-width:200px' src='" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e30/v0'/>")The image is not showing in the Form or Report view. Is the formula the issue?
Earlier this year, the people incharge of the development of Pipelines stated on a zoom call, that the Pipeline Error messages would be improved & become more useful. Here were are almost a year later, and I still receive emails with a subject line of "Error on Pipeline 5449755848XXXXXXX" with the generic body of "There has been an error in your pipeline." Unless I click on each email, I don't know if the message is anything we need to worry about.If you are like us, we have a LOT of pipelines. Some that have periodic errors, that we can't control or fix. So basically these emails have gone from "something is broken; look into a fix", to the boy who cries wolf (and are ignored, until someone notices an update hasn't run for over a day!)We have even gone through the trouble of creating our own QB logging table for our pipelines, where we write a log file at the start time of the pipeline, and update that record at the end of the pipeline (so if the record isn't marked completed with
I have created a pipeline with several steps, I have one step that saves a pipeline object which is just saving my api respond and that seems to fail inconsistently while it works other times. The error I get is Something went wrong executing a step. Try modifying your pipeline. What issues could cause this? Could it be a timing it issue in regard to it having to wait for the response?
Hello, Is it possible to consolidate several Text - Multiple Choice field types into 1 field for a report? I believe I would have to create a new field and a text-formula as well. My working theory is below:[Scope 1 Manufacturer] and [Scope 2 Manufacturer] and [Scope 3 Manufacturer] and [Scope 4 Manufacturer] ="Company A"We have over 100+ customers, so creating 100 field types for each customer seems to be ineffective option. Thanks! I appreciate this community's help.
very new to Quickbase. I believe I have followed all of the instructions on adding a lookup field to a new record form. I have the relationship between the 2 tables established and am trying to add the field to the child table. It gives me the dropdown list the way I would expect but does not show any of the data that is in the parent table.
I have an app where people can have many related child documents.Now, the app requirements have expanded, so that documents can belong to many people. I want users to be able to select multiple existing people records when they create a new document record and uploading the file attachment, basically like a multi-select text field but for existing soon-to-be child records. I'd prefer to avoid creating a many:many assignments table for the sake of simplicity but if I have to then I have to. Any ideas?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.