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 pipeline that when a record is created, it will search another table and if the project code matches in both tables, it needs to return a user value in one of the fields. However, there can be multiple records with the same project code but different user for each record. My pipeline finds the multiple records but is only returning one of the values in the List-User field. What is the jinja code to populate multiple 'user' values into the List-User field?------------------------------Amy Gosz------------------------------
I have one table that had all my sales for two years. I am trying to get the YTD AND PRIOR YTD totals based on a manufacture and based on the distributor.manufacturerdistributor date. Month. Prior Year Month this goes on for YTD AND PYTD. I'm also needing the $ diff and 0/0 percentage diff.had no luck with help desk but they are trying. If you could help I would be forever grateful (and probably still employed).------------------------------Lori Pelzel248.869.2000------------------------------
Good Afternoon All,My company is conducting a baggage survey where we must record all types and weights of baggage during the operation. My form is set up as items 1-20, as well as weights 1-20. I had no problem creating a total weight field, but I need a formula field that counts the amount of items. The item field has words instead of numbers (such as personal bag, checked bag, crew bag, etc.), so I need a formula that will count any of these as 1 and then total it up.Appreciate any help you can offer!Aidon------------------------------Aidon Olligschlager------------------------------
I have a form with a user field. It allows a person to enter a form, but select another user as the owner in a field called "PRM". For example, User 1 enters the form, but selects User 2 as the "PRM" owner.How can I create a field using a formula for User 2's email address?I know the formula below, but this would only bring in the email address of User 1 in this case.UserToEmail(User())Thank you!------------------------------Val Wong------------------------------
Hello,I have a table filled with records which gets updated every 15 minutes for the whole workflow process automation. When the triggered pipeline were not in place, it used to correctly document the user in Last Modified field. But with the triggered pipelines, it is just putting my name always as Last Modified. Can someone please provide a solution regarding this.Thanks!------------------------------XYZ------------------------------
Trying to avoid relationships. I would like to bring results from one table to another - something like a default record picker in the reference field. I need to have it in the dropdown with the possibility to select one record. Is it possible to do this through a formula field and get records? Last time I got results but they are not selectable.Thanks in advance. ------------------------------Ulyana Marchenko------------------------------
Hello community,What I am trying to do is the following: I have a main table that I use to build reports using queries within quickbase, in this scenario what I need to do is to evaluate if my project manager (let's say) Joe Black who has a Principal title appears in my query at least once, that way I can identify if Joe is indeed Principal and has one or more projects or the opposite.The part of the code that is not working is the evaluation part, and specifically because I can't store the logical result into a variable. I have verified and evaluated step by step the counting from my query and their conditions and it works perfectly except for this part:var number PrincipalJoeBlack=ToNumber(If($CountPrincipalJoeBlack>=1, 1));Which result for the variable PrincipalJoeBlack is 0 (although the condition is true)Don't know if there is a better way to do this kind of lookup with very specific conditions and cases without using if, I know there is no formula to identify unique value
I currently have data pulling in from another source via a pipeline. In the original source, the field is a multi-select but when pulling in they are separated by a semicolon (ex: Variance;Special/Cond. Use Permit)I am trying to figure out how to write a formula to convert this info from the text field into a multi select, allowing for teams to easily see all the different options selected.------------------------------Sarah Driscoll------------------------------
I have a subscription set up for four individuals using their specific email addresses with a semi colon and space between each one. For some reason the email is only being received by two of them and I can't figure out why. Those missing the email have looked in the company "Junk Email" folder to make sure it isn't getting flagged as spam or other "junk" and I've confirmed their email addresses twice now. Has anyone experienced this before and/or know how to fix this? Thanks!Rachel Miller------------------------------Rachel Miller------------------------------
I have a table in an app that I am unable to access. I can access its settings but not actually view the table and its records. I'm logged in with an admin account with rights to view all tables and view, add, modify, and delete all records. In this specific table's advanced settings the "show in table bar" option is unchecked and the "Include this table in global searches" is checked. When I tick the box to "show in table bar" and save, the box becomes unchecked. Does anyone know what might cause this behavior?------------------------------UNITAD ELMS------------------------------
I am using the Shipstation channel to get rates for shipping packages. Stamps.com won't accept any packages more than 90 linear inches (L + W + H), UPS won't accept anything over 150 pounds, and other carriers have other restrictions I haven't stumbled across yet.Is there a way for the pipeline to keep running with other carriers when one carrier throws an error? Right now, the pipeline just stops.If it opens up more options, I can also use Shipstation's API rather than the Shipstation channel.------------------------------Edward Hefter www.Sutubra.com------------------------------
Hello,Reminder emails and subscriptions don't seem to be sending to all my recipients, unless I have the email address actually typed out.Everyone seems to get the notification emails when I have the distribution set up like below. However, when I do it this way for for reminder emails and subscriptions, it only sends to the "vw@email.com":[PRM Email]vw@email.comAm I supposed to enter it differently? I use the "[PRM Email]" to signify using the email address that is entered into the form.Thank you!------------------------------V W------------------------------
Hi everyone! I'm currently working on a summary report and need help with creating a "reverse running total"(?)Here is is an image of what I have in my app now: Here is what I would like to get it to: For the field on the right of "Number of All pets", I would like to take the total of all my pets and subtract them from the "Number of All pets" to the left. Going downwards in a "reverse running total". I'm quiet unsure of how to do that without un-organizing my list and would love some help figuring it out.Thanks a bunch! ------------------------------Emma Snowden------------------------------
Hi - I've searched but can't find a similar use case to mine....I have a multi-select text field where users can choose all of the products related to the content they are submitting.When we promote the content, we can only show 5 products max. So I need the user to tell me which 5 products to show.Right now, I have two fields: [Products All] and [Products to Promote]The response options in both fields are identical.The user selects up to 20 in the [Products All] field then selects the 5 they want to promote in the [Products to Promote]You would be amazed at how many people choose [Products to Promote] which they did not choose in [Products All]Is there a way to make the response options in the [Products to Promote] field mirror what the user has chosen in the [Products All] field (so they can choose their 5 products from this filtered list)?------------------------------Karen Henke------------------------------
I'm seeing whether QB could provide a questionnaire solution. I want my clients to fill out a questionnaire in the mobile app. The questionnaire has about 10 questions with multiple choice answers. When I created some Grid Edit reports, it looks like you can't open those in the mobile app (or at least, I was unable to figure it out). Is there a way to make a flow that is more like Jotform or Google forms where the user can select their multiple choice answer for the 10 questions on the same form in Quickbase mobile?------------------------------Solace Sonder------------------------------
Good morning,I posted this question before in another form but did not receive any responses. I am not sure if that is because the question was not understood or there is no known solution.I am trying to create a "score" report based on quality data entered by our QA consultants. The first issue I run into is QB seems to be taking the average of an average since I created a formula field to do the math I need for the scoring. If I add that field to a gauge report summarized by average I get the incorrect "score".I then decided to try a basic formula query which gives me the "score" I need but since its so basic it queries all of the records. I know I can add additional variables to look at a smaller subset of the data but is there a way to use user defined filters for formula queries? Ex: If I set the gauge report to display the formula query field and add that report to a dashboard is there a way to have the dashboard filters impact what data the formula query reports back?I have been
I have not actually used QB Actions. But in looking, for simple tasks, this seems like it may be a good way to go. If I make an action, it won't interfere with all my pipelines running, and also allows me to clean up my Pipelines and only have necessary complicated ones.Is there a reason to use or not use Actions vs Pipelines? What is the best practice?------------------------------Mike Tamoush------------------------------
Just wanted to start a thread around the App Library that I presented on during Virtual Empower 2020.My hope is that this can be a place to share other use cases you've come up with, or simply ask questions if you've hit a snag.If you haven't seen it, you can find the demo app in the Exchange by searching App Library.------------------------------Ryan PfledererImplementation ConsultantQuick Base------------------------------
Does anyone know if there is (or will be) a way to pass filter values to the new dashboards via URL?Use case:I have a Project Dashboard that has numerous widgets summarizing data from various tables, with all related to a Project ID. I'd like to have a URL button on a Project Record that gets clicked, which would then open a new tab with the Project Dashboard, already filtered to that Project. But it doesn't seem that the URL changes when filters are applied to a dashboard. Any thoughts? Anyone read from QB release notes if this is a feature in the roadmap?------------------------------Anthony Guillen------------------------------
I created a button on a code page that opens a New Record Form in the window. When I added the code page to a Home Page as a web page, the button works fine. However when I added the code page to a dashboard, I get the following error---xxx.quickbase.com refused to connect. Quickbase is trying to open the form in the dashboard iframe. As alternative, I had to open the form in a new tab by using target="_blank". Does anyone have a solution to open the form in the same window when the code page is added to a Dashboard?------------------------------Charlene Dougall------------------------------
I don't really know how to explain what I am looking for...We have several different teams (from 1-24) and what I would like to figure out is how I can have one generic dashboard where the reports, charts etc... will automatically drill down to whatever dashboard that is logged into.For example; if a manager is over Team 6 then when he logs in - he goes directly to his dashboard - then the queries in the reports would run for Team 6 - and I do not have to build 24 individual reports for this weeks hours and add to the dashboards...Does this make sense?And does anyone have an idea about how I might start looking at doing this?------------------------------Hans Hamm------------------------------
I have a parent table (records within are Roadmaps, representing large-scale initiatives) and a child table (called Projects). My goal is name create a numeric identifier for the child record based on the Roadmap #, adding '-1' to the first child, -2 to the second child and so on. For example:BIG INITIATIVE 600 (Roadmap record ID) 600-1 Project Name A 600-2 Project Name B 600-3 Project Name CI also want to automatically add a child record every time a Parent Record is added (and plan to build a Pipeline to achieve this).Has anyone successfully done this? If so, can you share your steps? (eg is this two discrete actions or is there a way to include the 'RID=Parent RID, increment by 1' within the pipeline configuration?)Thanks! Renee ------------------------------Renee Tumacder------------------------------
Is there any way to have the users shown in a user field limited to users of a specific role?Use case:The app has a role called "approvers"In a form, I want a "Select Approver" field that would be a "user" type field. The selected user would get a notification.I know I can make a "custom user set", but every time an approver needs to be added or removed, an admin would have to go in and edit the field. This information is already in the app per the role. It would be much better to simply have a field that allows you to select from this list of users with the approver role. Is there any way to accomplish this?------------------------------Paul Easton------------------------------
I am using a Pipeline to search for recordsGet the value of a Formula Numeric FieldSum and write that value in another record.The error message I am getting is:Validation error: Incorrect template "{{b|sum(attribute='total_event_bom_item_sell_price')}}". TypeError: 'Record' object is not iterableI have successfully done this with other Formula Numeric Fields, so I am not sure why it would break for the same calculation somewhere else.I did open a Support Case but I have got Boston a bit flummoxed. Any ideas?------------------------------Don Larson------------------------------
Hi,I have one field and I want to do the cumulative sum in that field. For example suppose I have one field T1 and user has entered value 10 initially so that field should show value 10. Next time when user enter another value let say 20, then it should show sum of current value in T1 field (10) plus the latest value(20) which is 30. Is there any way to achieve this?I tried using three fields 1st T1 which get the actual value2nd T2 which will store the previous value of T1 and if first time user is entering the value in T1 then T2 should show the value of T1 next time when user enter the value in T1 then it should show sum of T2 value + new T1 value and put that value in T1. Please help if it is feasible to do in quickbase ------------------------------Hunny Vinod Kumar------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.