Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi All,May I please ask where I can get more information on the recent QB optimization before running the performance optimizer, in non-simulation mode?Just want to make sure that there will be no unnecessary changes made.Thank you.------------------------------Iryna Pylypenko------------------------------
Is it possible to setup a scrolling text effect with a rich text field? i.e. HTML Marquee------------------------------John Ross------------------------------
Can someone help me to identify the syntax error in the following Case function?Case([calc Days Until Promise Dt], <Days(0),"Overdue", <=Days(2),"Due in 2 Days", <=Days(4),"Due in 4 Days" <=Days(7),"Due in 7 Days", >Days(7),"Beyond 7 Days")//Where[calc Days Until Promise Dt] is of type formula Duration
I have entered a report formula into my report to show all call types related to a user's ID # in the same column. For example, if user ID 123456 had one call on 5/1/22 for Call Type A and one call on 5/18/22 for Call Type B in the data table, the report would show only one line for user ID 123456 and in the Call Types column it would list both A and B showing that in the data user ID 123546 has had calls for both Call Types A and B.In my report I then added a filter to filter the report by a date range which would be selected by the user (Date of call is on or after <ask user> AND Date of call is on or before <ask user>). The report formula is not following the report filter I have added. For example:Expected Result - If the date range entered is 5/1/22 to 5/10/22, the report will show one line of date for user ID 123456 and only show the call type A that is in the data table for the call that came in on 5/1/22.Actual Result - If the date range entered is for 5/1/22
Above are 4 pictures of what I am experiencing. I had thought I had established a correct parent/child relationship. I have data in Work Order table "Status". I want that data showing up in Shop Labour. I also have a specific filter that states that to not show results if the work order status is "complete" or "cancelled."As you can see in the bottom image, I am getting data from a work order (3225) that is marked "complete" and also the Work Order - "Status" column is blank.What am I doing wrong? ------------------------------Sid Fontoura------------------------------
I was hoping to create a field that's auto-generated with this format [YY]+0000 <- where this increments by one every time a new invoice is added. Can someone help me with the formula?------------------------------frnmj------------------------------
I know there are many ways to enhance a form text area, like HTML tags for BOLD and Color changes. However, I was wondering if you could embed a URL and hide it behind a single word or phrase, like "HERE" or "Register Here", like you can in MSWord.------------------------------Byron Deane------------------------------
Does Quickbase have functionality to process payments directly in Quickbase in South Africa? My customer has funds that they want to collect monthly and want to do it directly out of quickbase? Will they have to connect to a third party app to do this order can it be done directly out of Quickbase?------------------------------Kelly Grewar------------------------------
I have two reports with identical fields except one ST (Straight Time) and the other is OT (Over Time)I'd like to produce a report that list the results from both.EX. Time field will return both ST and OT results.Thanks------------------------------TMurray51------------------------------
I have 2 tables (Invoice and Payments table) which has a one-to-many relationship. The Invoice table has an Invoice Amount field, and the Payments table has an Amount Paid field. Basically, I want the Amount Paid to be deducted from the Invoice Amount automatically once the Payment record is added.------------------------------frnmj------------------------------
We use QB to generate invoices across multiple tables within one app - how can I create a sequential numbering system that pulls the next number when the user clicks a button? We don't want the invoice # created when the record is made, we prefer to create it when it's ready to send.I currently have something hacked together using pipelines but there is a small delay which can result in duplicate invoices numbers in rare occasions. I have no problem reading/writing to a field using the API but I'm struggling to come up with a clean solution. ------------------------------Matt Hardy------------------------------
Is reference proxy must be unique ,I've been a handled an app which has reference proxy field & not unique ,Actually , The reference proxy for the grand child is the same as the parentmeans that :- A- In 1-m relation ship between (grandfather& parent) reference proxy field in unique in the grandfather table. That's correct B - The second 1-M relationship (parent & grand child ) reference proxy is the same field used in the previous relationship. ( Not unique & it used in the higher 1-M relationship) Here is the paradox I feel that is not correct at all ,Right ? See the below image to explain------------------------------Yasser Sabry------------------------------
I would like to know if there is a way to automatically transfer data from a Summary Report to a table that I would possibly call "Quota (Summary Table)". I know that there is an option to export the Summary Report to a CSV file and then I can import it into my Summary Table but I would like to know if there's a way to automate that or make the transition easier.I need the information to make a table that will help plan for the following day. The Quota (Summary Table) will provide an update of how many tons is left over on each site location (ramp) so that I can adjust the amount of trucks reporting to the site the next day based on total tons at the site location. ------------------------------Yobani Maldonado------------------------------
Hello, I'd have the need to have a custom header before the column labels. Is there a way that I can add a header that will be shown above the column label row? Header 1 would be custom not related to field names at all, then the 2nd row would be the column labels.------------------------------Barbara Alvarez------------------------------
I have been able to set up an e-mail that sends through MS Outlook using pipelines and it works well in taking values from fields in records, etc. However, I want to add a Word Document as a file attachment in the traditional way that files are attached in outlook - i.e. not a hyperlink.That file could be an uploaded file in a QuickBase record; or if there is a way to upload from DropBox and still get a traditional file attachment (not a link) that would work.Is this possible through pipelines? Jeff------------------------------Jeff Elliott------------------------------
I want to build a new app that our vendors can view their metrics with out having to use paid seats for them to log into. We need to basically compile data into tables and they can see the compiled data when they log in. So I guess I would need some sort of guest role?------------------------------Johnny DeVilla------------------------------
I want to add a specific color and background to each individual choice in a multi-select text formula field. All the choices would have a unique text/background assigned/formatted to it. Therefore when a selections is made it display whatever formatting that has been assigned.For example:Pending payment - green background and red textClosed - black background and white textInactive - orange background and purple textWould this be an If or Case function?Thanks------------------------------Kelly Lyons------------------------------
Hi,I am trying to create a formula field to be checked if the day is more than or equal to 14 days or unchecked if more than 14 days. Is this possible to be put in a formula. I started doing the if function but cannot seem to get the 14 days in the past to work.thank you------------------------------Zana ------------------------------
I set up a button to Submit a New Space Request that changes the Request Status field to "Submitted" and checks the a checkbox to "Certify" the request is ready to submit. This button was made to put on a report that goes on the user Homepage so that if they have done everything on the request besides certify and submit it, they could do so from the homepage instead of having to go into the record. I have dynamic form rules in place that when the checkbox to "Certify" the request is checked, it also turns on the requirements for several fields to be filled before they can submit. However, the button I created is allowing the user to certify and submit the request without those required fields being filled in. Is there a better way to set this up? Perhaps the submit button on the report isn't available unless the required fields are filled in?------------------------------Chris Swirtz------------------------------
I must be missing something, because several months ago when we set up one of our applications to be used via the mobile app, we were able to search and find an EXISTING record within the app and edit it offline and have our updates pushed once we were back in service. Now when we access the app offline through the mobile app we're only seeing an option to add a new record to a table. I'm also not being shown the homepage anymore. Is this a new restriction to the mobile app? I would hope not as editing existing records was vital for our mobile applications to thrive. Any insight is greatly appreciated!!------------------------------Skye Ellis------------------------------
We don't have the Include option/Operator on quickbase, Why? ------------------------------Jotform Admin------------------------------
Hello, OVERTIME BY WEEK I'm having trouble working out overtime in a summary report. I have a daily time card with [Time In] [Time Out] and it gives me ours worked per day, every day a new record is created with the time in time out. The state of Louisiana mandates overtime as (everything after 40 hours in a week is overtime, not anything over 8 hours per day) I need a report that will total all the standard hours and overtime ours for all employees or all projects project. This is easy if i use only one employee but if i have more than one employee i find the report will stop counting standard ours. Im including a screenshot this is as close as I've gotten you can clearly see these totals are in correct Here are my formulas. These formulas are in "Summary Formulas" in the summary report.Standard time s_tandard If([hours_to_number (tot)]>40,40,If([hours_to_number (tot)]<40,[hours_to_number (tot)]))OvertimeIf([hours_to_number (tot)]>40,Max(0,[hours_to_number (tot
Hi,I am trying to write a formula to show today's date when a checkbox is selected. The name of the checkbox field is "Completed".Thank you------------------------------Fatima Khan------------------------------
When a record changes (trigger) I want to be able to tell if a specific file attachment has changed. With most fields I can compare the field {{a.name}} with the previous value {{a.$prev.name}} to detect a change in that specific field. This does not seem to work with file attachmenty field types. Is there a different syntax?------------------------------Mike Smith------------------------------
I am pulling the information via a relationship from one table to another. However, the number is constantly showing up as a number. It is the Proxy Reference too. What am I doing wrong? I have encountered this before and have always been able to fix it. Not today! ------------------------------Jennifer Meyer------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.