Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm working on a summary report and I'm trying to count the number of weekdays in a fiscal month. I have the formula working for the calendar month, but our fiscal month is always the 22nd of the current month to the 21st of the next month. If there a formula that will capture this? I basically need the formula to take [Scheduled Date], find which month it lands, and then count the weekdays between the 22nd to and the 21st. Example:Fiscal Jan is Dec 22nd - Jan 21.Fiscal Feb is Jan 22 - Feb 21.Fiscal March is Feb 22 - March 21Etc The formula I have is below, which works but only for calendar month. var date FirstDay = FirstDayOfMonth([Scheduled Date]);var date LastDay = LastDayOfMonth([Scheduled Date]); WeekdaySub($LastDay, $FirstDay) + 1------------------------------Mario------------------------------
I'm trying to create a new sharepoint list item when a record is created with a pipeline. Right now, it works fine to create the item, using some fields. However, if I try to send any data to a Hyperlink field in sharepoint the api request to sharepoint fails. Also, if I send email address to a person field in sharepoint it doesn't error but also it doesn't get filled out. I know in a normal api request to sharepoint the hyperlink field is special in that it wants a url and link text, so I'm not sure if I'm supposed to do something special in pipelines to get it to work. ------------------------------Greg Vasquez------------------------------
Does anyone have any code to dynamically make a circle with a number inside it? Or a rectangle box with a number inside similar to the Dashboard widgets Gauge charts on a New Style dashboard. Think of a set of numbers colored billiard balls. I'm mentally struggling with how to best present summarized information to users to show the performance vs Budget of the combinations of 5 "Branches" (Regional Sales Divisions) and 7 Product Groups by month and YTD. I don't know yet how I will present that three dimensional information at a glance but if I could present the information visually with a gradient of say 10 stoplight colors from Green being good though Yellow down to deep Red, it would help me. I would need to be able to control the colors of he balls and the text on the ball or square dynamically by formula. ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
I have fields on the old form that are required but are still letting users save the form without the required fields. One field is a file attachment, and the other is a user field. It doesn't happen all the time but when it does happen, the person reviewing the form has to attach something in order to close it. I don't have any form rules mentioning the fields. During testing in a sandbox, I wasn't having any issues, but now that it's live it has happened a few times each week. Are there any known bugs for this? Thanks------------------------------Codi Smith------------------------------
I have a app to manage all my annual agreements. I would like an email to my management staff when 90 days is reached (later at 60 and 30) to remind them an agreement is expiring. My problems are as follow and am looking for the solution: Reminders don't let me include just a few specific fields. Customer Emails don't allow me to send based on a date being reached (Only when a record is added, modified, etc.) I don't want a subscription - Or do I? ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hi,Do we have an API that returns the "Last Visited" column data of an user? GetUserInfo API does return if a user has registered or not but it doesn't seem to return any more information.My goal is to know when a user has last visited in QuickBase through API.Thanks,Praharsha------------------------------Praharsha K------------------------------
Hello, In the Quickbase query language (https://help.quickbase.com/api-guide/componentsquery.html), it shows the query language for the XML service not for the JSON. How do you show all columns for the JSON service? When I remove the select portion of the JSON request body, it only shows a few default columns.------------------------------Zen Lin------------------------------
This is my first go at a Rich Text Formula, and I just think asking here will get the answer I can use to apply in other situations. I need to assign a Stoplight color to all open "Projects". I can apply the Open Filter no problem. For the stoplight, my team will use the field Condition2 to select "On-Track", "At Risk" or "Danger". The field named Condition2 will then display a Green, Yellow or Red circle, respectively. Also open to some other way of doing this by just using one field. i.e. Can my multiple choice simply be the desired circles and not the equivalent text options? I am fine if it needs to be the two field approach and got that idea from a previous.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Subject line is wrong, I AM adding a row .... What does this mean? ------------------------------George Bramhall------------------------------
Good morning. Does anyone know of a way to mass download file attachment records from a table? I have lots of pictures I want to download and delete from my app and can't find a solution that works well. Thanks for your help!------------------------------julie mcclenic------------------------------
I encounter a problem on mobile as follows: I use a dynamic form rule that fills in a related field. On desktop, as soon as that field is populated, all the lookup fields are populated. The problem is, on mobile when it fills in the related field, it is not technically 'selected' until you go to the related field, click on it, and click 'Done'. I also find that some selections further in the form trigger it (oddly, if i select something in a mc dropdown, it suddenly recognizes that it is populated, but simply typing text in a field doesnt trigger it). Has anyone encountered this and come up with a work around?------------------------------Mike Tamoush------------------------------
I swear at one point in my previous job I had some text widgets on a home page that I used to display the number of records that met a certain value, or a total of values from a field. I had these formatted in a large font with specific colors. I had a few year break from Quickbase, and now I can't remember how I did that. For example, if there are 27 total open requests in a table, I want a widget named "Open Requests" that displays the number 27 in a large font colored blue. Or another widget that would total all values from a certain field and just display it as a large number. Anyone know how to do that?------------------------------Mike Brady------------------------------
Hello Quickbase Community, I wanted to ask if you have ever experienced a glitch like this before: Basically, I'm trying to save the record and Quickbase is telling me that a field was modified before my changes could be saved (even though no one else edited this record), so I review the changes and select Keep, but it won't save no matter how many times I try. To make it work I have to cut the changes I had made on the specified field, then save the record, then refresh the page and paste the changes back and save the record. Has anyone faced this scenario before? how do you fix it? Thank you!------------------------------Alberto TabladaLead Software EngineerBlueWell GroupFlorencia+50688083124------------------------------
Hello Community, I hope this message finds you well. I am currently in the process of changing my QuickBase domain from aaa.quickbase.com to bbb.quickbase.com. I have encountered a challenge related to Formula Fields in my applications, where I have used the URL of my current domain (aaa.quickbase.com). As part of this transition, I need to identify and update all Formula Fields across my applications that include references to aaa.quickbase.com, replacing them with bbb.quickbase.com. The sheer volume of Formula Fields across numerous tables makes manually tracking and updating each field time-consuming. I am reaching out to the community to seek advice or solutions. Is there a way to streamline this process, perhaps through the use of a script or tool that can automatically list all Formula Fields containing references to aaa.quickbase.com? Any guidance or insights on this matter would be greatly appreciated. Thank you for your time and assistance.------------------------------Syed Ah
I have a pipeline that verifies whether 2 records exist in separate tables, if not the records are created, and then I need the record ID for each to add to a 3rd table because it is a 'many to many' relationship. I have the record ID for the first record, but not the second. Here is an outline of what I have... Record added to Google Dropbox imports into a Connected Table in QB (Trigger) Search Customer Records -> if empty, create new record, and then... Search Customer Rep Records - > if empty, create new record, and then... Search CRM Records -> if empty, create new record using key field, provided in the original import. However, the Customer Rep goes by the record ID which was not provided , and must be retrieved from the record that was created. How can I retrieve the record ID of a record created in a previous step?------------------------------Kelly Bianchi------------------------------
Hello, all! I am looking to share reports with users in a dashboard format. Do I need to give view access to my tables and data to all those using the dashboard reports? I have some information in my tables that I do not want to share via these reports, so giving full view access to the tables is not something I want to do. Thank you for your help and explanations!------------------------------Brittany Clark------------------------------
There was what I believe was the first meeting of the Mobile Qrew meetings and I have attached the recording. The Mobile Product Manager Polina Georgieva comes across as hugely knowledgable about the Mobile needs and how they are being addressed as part of the development cycle of new forms. Polina says Q2 for Open Beta and Q3 for GA of New forms behaviour on Mobile. The features are described starting at timestamp 45:00 so it's well worth watching for at least those 10 minutes. I think that this link will work ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Hello, Has anyone ever seen this error?" Exact Forms Plus Encountered an ERROR! NO Document(s) were generated! We're sorry but something went wrong!The following error occurred:Name of style already exists Exact Forms Plus v11.5.10 " Any ideas on how to resolve it? Thank you------------------------------Shane Miller------------------------------
If I have a global filter on a new dashboard, and once my table report is filtered I want to download that filtered report to a csv, is that possible? I have 6 table reports, that will at times, all need to be filtered with the same couple of filters. Then, all downloaded to csv. Any creative ideas on doing this? Right now, my best idea is a user focus table and have the user select their personal filters, then filter the reports that way. However, they still need to open each report and download, so I am not actually saving them much time. Not sure if there is a better way I am forgetting.------------------------------Mike Tamoush------------------------------
Hi All,I have a situation where I have developers that need to have access to add and remove users as well as modify the applications.Under this situation any role that has these privileges can totally take control of everything and also remove the administrator user and delete the application, does anyone know if there is a way to prevent this?Thanks,
I don't need a full accounting app, but I have a need to keep tabs on my contracts. Here is the way it works for us, need some help with the design of the app. We issue a contract for a certain dollar amount. It may last over several years. Therefore, don't need to track by fiscal year necessarily. From a contract, we will issue several Purchase Orders. I PO is a for a certain amount. The vendor will then send us invoices. Every invoice should track to a PO. So, I want to track a PO by amount and then sum all invoices related to that PO. On the original Contract, I want to track amount of all PO's issued. I was originally thinking a Contract table, then a PO table, then an Invoice table. Is that the right street I am going down?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels-------------------------
Hi Everyone,I need to import some data and some of the fields are related in the app, anyone have a trick to import in this way?Thanks in advance,Miguel
I do not have anything checked, and almost every day I get at least one spam email from you guys. Example of one I just received this morning: ------------------------------Sam Lopresti------------------------------
I have been successful setting fields in webhooks. However, if I try to set a user field, populating it from another user field, it does not work. What is the correct way to populate a user field using a webhook?------------------------------Mike Tamoush------------------------------
I want to color rows that are past my Next Due date field Red. I get that to work. But then, I also want to color code anything that is 30 days or less out Yellow. I tried this.... If([Next Due Date]<Today(),"RED")If([Next Due Date]<Today()-Days(30), "Yellow") It not only doesn't do red anymore, after working as a single line, but it also won't color yellow. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.