Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
//[Date of Survey]+Days(3)ToDate(WorkdayAdd(ToWorkDate([Date of Survey]),3))The issue is to skip the weekend days when a due date counts only business days MON-FRI.For ex: 9DEC is a FRI therefore a due date should be three business days returning WED14DEC. But the line 1 formula doesn't account for the weekend and returns MON12DEC as a due date.The second, more intricate formula, also does not work.First and Second Prizes to any suggestions!------------------------------marc viens------------------------------
We have a number field is set to 2 decimal places and works great. shows the total for the invoice and is great. To print it all nice we added a Rich text field with a formula that shows the total again"<table bgcolor=\"white\" border='0' cellpadding='1' cellspacing='0'\nstyle='width:100%;font-family:Arial;'>" &" <tbody>" &" <tr>" &"" &" <td style='text-align: right'" &" <p><span style='font-size:20px;'><strong>Total: $\n" & Floor([Total Retail], 0.01) & "</strong></span></p>" &" </tr>" &" <td style='text-align: right'" &" <p><span style ='font-size:14px;'>" & "</span></p></td>" &" <tr>" &" </tr>" &" <tr><td style='text-align: center'" &" <p><span style='font-size:16px;'>Thank you! </span></p>" & " </tr>" &" </tbody>" &"</table>"BUT its all perfect UNTIL
I am trying to auto-fill the details of a project basis the project number. For example, I have a table with "Project Dump" and there is another table called "Live Projects" where the sample projects will be worked by the trainees. While choosing a project from the dump to be assigned in the "Live Projects" table, I want the projects details like address and another URL link to be auto populated from the "Projects Dump" table. How do I achieve this?------------------------------Rahul Mathew------------------------------
Hi, I am new to managing Quickbase and I am building a new app for my team on QB. The issue is I have a list of let's say inventory and inventory related info in one table. On another table, I am adding a form where the user should be able to pick the inventory from the list of inventories that I have in the other table. I have tried table-to-table relationships but the field on the field is non-editable even though it is not set to read-only.------------------------------Rahul Mathew------------------------------
My formula fields no longer show errors. I can type in a wrong field name with no issues, or make the syntax wrong. It wont tell me until I try to save. Are others having this same issue?------------------------------Mike Tamoush------------------------------
I need to return the earliest date in a list of dates in a formula. Any idea how to do this?Here's what I have so far (just the list variable declaration):var list dateList = list( [Date stage set to Ready for Editor],[Date stage set to Ready to send to client],[Date stage set to sent to client for approval],[Date stage set to approved by client],[Date stage set to Published]);------------------------------Matt Makris------------------------------
Hello,I'm having an issue with a number my pipeline is pulling over, it changes the number. I have one app where a 19 digit ID is put into a record. When my pipeline pulls that record and creates a new record in a different app it changes the number. I have tried changing the field type on the second app but it is not working. Please help.This is the ID in the first app. but it pulls it over with this number.------------------------------Fatima Khan------------------------------
The previous developer created an HTML page that populates record values and creates a printable offer letter. I can't locate the page to edit it. A URL formula is used to generate the letter. Where would I locate offerletter.html?A portion of the letter is attached.URLRoot() & "db/" & Dbid() & "?a=dbpage&pagename=" & URLEncode("OfferLetter.html") & "&clist=a&rid=" & [Record ID#]------------------------------Terrence Murray------------------------------
What is the proper sequence of Pipeline channels and functions to allow a SharePoint List to connect to a Quickbase table? The goal is for Quickbase to GET data from the Sharepoint List. I can achieve this fine with a Pipeline I built that gets data from a csv within Sharepoint but I can't quite figure out how to get at into QB from SharePoint.I can't find any resources that point to a config like SP to QB. My current config looks like thisA) Trigger: Webhook and Incoming RequestB) Sharepoint channel function: Search Lists. (Account, URL, ID= the list id)c) FOR EACH MS Sharepoint ListLOOP: Quickbase Channel: Prepare Bulk UpsertD) QB: Add a bulk Upsert row(note in this step I am presented with the QB field but nothing avaible to map them to)E) Commit UpsertPlease advise. Thank You------------------------------Michael Mahon------------------------------
In an app that allows users to book a shift: Users are allowed to cancel their shift up to the 15th of the month prior to their [shift date] - for example, if my [shift date] is 1/6/23, I cannot cancel it after 12/15/22. I need either a date formula to calculate the cancellation deadline, or a rich text formula to show yes/no if the shift is able to be cancelled. Then I will use a form rule to hide the cancellation button if the cancellation deadline has passed.I've turned this over and over in my brain and can't figure it out. Thanks in advance for your help! :)------------------------------Sherry Blackburn------------------------------
Hello,currently I have 3 pipeline set to updates the dates. I am using the workflow of record updated and update records, but I am running into issue where it isn't properly recording the date/time.The use case is:1) If the attempt= first, update first attempt=current date/time2) if the attempt=second, update second attempt= current date/time3) if the attempt=third, update third attempt= current date/timeSo all three pipelines are having the data but sometime it is recording incorrectly. Could you please advise if I am able to use this case in only one pipeline. Let me know.Thank You------------------------------XYZXYZ------------------------------
Hi,I want to get all the application name that a user has access.Thanks,Neha Goyal------------------------------Neha Goyal------------------------------
I'm sure this is a simple mistake, but I'm getting a "expecting user/userlist but found textlist" error.Isn't this the function of touserlist? Field 29 is a user field.//list all installers scheduled on this date//table ID: _DBID_SCHEDULE, FID 29 = installer, FID 6 = datevar text myquery= "{6.EX.'"&[Date]&"'}";touserlist(GetFieldValues(GetRecords($myquery,[_DBID_SCHEDULE]),29))------------------------------Anne Martin------------------------------
When applying a date range filter to a dashboard, the filter doesn't work on a line & bar graph. I have several other reports on the dashboard: a few table reports, a bar graph, a pie chart, & a 2 series line graph, all of which are working fine. But specifically the line & bar graph doesn't get updated when the date range filter changes. Is this a known bug or is there something I'm doing wrong?------------------------------Harrison Smith------------------------------
Has anyone figured out how to find out which Pipeline a field is in? If you go to the usage tab, their will be an indicator that your field is in a Pipeline. However, the number given seems to have no relation to the Pipeline (in any useful way). Has anyone figured out how to find the pipeline a specific field is used in?------------------------------Mike Tamoush------------------------------
I am in the process of developing a form for my team and I am running into an issue. The form has several fields per entry dependent on the previous entry to keep an aggregate count as the entries come in (needs to pull in the previous value to calculate the difference over a set time). It is a process that is very simple in Excel, but I am new to QB and could use some guidance.The value pulled in needs to be from the same location as the new entry and should pull the most recent value from that location's records. How can I pull in the previous record's value, but only from the most recent entry at the same location?Let me know if any clarification is needed or how this can be achieved.------------------------------Ethan Kaste------------------------------
var date datevariable = AdjustYear([WTF],-1);SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159)So this is saying sum the Year to Date value in field 159 when the Distributor and Manufacture are the same and the Date is last year.WTF is the date field I'm trying to define as last year?Something is wrong, it works perfectly when I use this for the current year-to-date total.var date datevariable = FirstDayOfYear([WTF]);SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159)Thanks for your help!Lori------------------------------Lori Pelzel------------------------------
Normally when we have a grid and click to add something from a report you get a "browse choices" and it pop open a window.We can't get it to do that. It just scrolls through all the choices.. where is option to turn on the pop option?------------------------------Ali Mohsenian------------------------------
Hi,My company was acquired and sadly we will be shutting down our QuickBase account. I want to do two things before we shut it down: What is the easiest/quickest method to export all data from all the tables in the App? I spent a lot of time over the years building custom formula fields, buttons, custom reports, code pages, etc etc. So just in case we ever go back to using QuickBase in the future, it would be nice if I could somehow export and keep a record of all of that information so I could reference it to build a new app. Is this possible? Thank you------------------------------Robin Kautz------------------------------
I have a pipeline step which increments a field by 1{{a.times_bol_sent_to_requesting_client + 1}}That works just fine unless the field is blank at the start. Is there a simple way to update the syntax to also have it work when the times_bol_sent_to_requesting_client is blank?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Hello.My QuickBase features a dropdown list that when selected, should automatically fill another field with today's current date.Is there a way to check if anything has been selected in a dropdown? My best guess is something like this:If([Dropdown] = TRUE, ...)However, this throws me an error because the "=" operator cannot be used with textlists.Any ideas as to how I can work around this?I appreciate the help!------------------------------James Warren------------------------------
This is some strange behavior, and I can't see what is possibly happening. Anyone else experience this?I have a rich text button that performs some actions, and then uses Next URL. For my testing, I just used my NextURL to go to the app homepage.When I click the button from a form, this is the URL:https://mycompany.quickbase.com/db/bsnxkbpae?a=er&dfid=10&rid=610&NextURL=https%3A%2F%2Fmycompany.quickbase.com%2Fdb%2Fbsge67emnThis returns to the home page as expected.When I click the button from a report, this is the URL:https://mycompany.quickbase.com/db/bsnxkbpae?a=er&dfid=10&rid=610&NextURL=https%3A%2F%2Fmycompany.quickbase.com%2Fdb%2Fbsge67emnThis does not return to the home page, it simply lands on the report from where it was launched.Notice anything strange? The URLs are EXACTLY the same. How can two URLs that are exactly the same, function differently? What am I missing?? To add to the strangeness: If I copy the second URL and paste it in a new browser tab,
Been racking my brain on how to do this for a while but not seeing anything helpful on how to do this. I have a Table called Daily Action Log. A record is created to keep totals on the number of tickets that were completed in a day, month, year, etc. Right now, we manually and daily create the record with all this data for each employee. Which isn't a problem however we don't do it on the weekend so the data isn't collected. Trying to figure out how this record can automatically be created in the table with the data. Looked into pipelines but this seems to be to create a record based off a third party application so doesn't seem like what I need. I see Quickbase Actions, which replaced automations, but it seems it would create the record when an action is done in another table, which won't help since I need the action to be done in the same table. Am I missing something on how to do this easily? Just want to automatically create the new record
The last digit of a bar code number is a computer check digit which makes sure the bar code is correctly composed.The final digit of a Universal Product Code is a check digit computed as follows: Add the digits (up to but not including the check digit) in the odd-numbered positions (first, third, fifth, etc.) together and multiply by three. Add the digits (up to but not including the check digit) in the even-numbered positions (second, fourth, sixth, etc.) to the result. Take the remainder of the result divided by 10 (modulo operation) and subtract this from 10 to derive the check digit. Here is the Excel formula: =MIN(MOD((SUM(--MID(A1,{1,3,5,7,9,11},1))*3+SUM(--MID(A1,{2,4,6,8,10},1))),10),10-MOD((SUM(--MID(A1,{1,3,5,7,9,11},1))*3+SUM(--MID(A1,{2,4,6,8,10},1))),10))How can I convert this formula so that it works in QuickBase?Thank you.Mr. T
The only thing I have found about dynamic filters for calendar report is this post which really does not answer the question. Is it possible to apply dynamic filters to calendar reports?------------------------------Paul Peterson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.