Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm trying to get the formula below to work --- ToText(GetFieldValues(GetRecords("{24.EX.'"&[PriceKeyA]&"'}AND{9.OAF.'"&[Invoice Date]&"'}AND{10.OBF.'"&[Invoice Date]&"'}", [_DBID_PRICE_TABLE]), 3)) (Table A) (Table B) *[PriceKeyA] *[Start Date] - fid = 9 *[Invoice Date] *[End Date] - fid = 10 *[PriceKeyB] - fid = 24 &nbs
On the Exchange Beta App (Project Management Starter App) their are links under the Report Shortcuts section on the Home page (dashboard). I know how to add a link, however I do not see how the text was changed from the URL to the name of the report. ------------------------------BuildPro------------------------------
Am I seeing correctly that starting May 31 QB will finally have a native Multi File Attachment??? Kudos to finally implementing one of the most requested features. Now, how about those native signatures......?!------------------------------Mike Tamoush------------------------------
Hello, I have a field that is being generated by a pipeline and unfortunately due to the formatting of my jinja, creates blank lines: Is there a way to format this via a formula text field so that it appears as follows: or perhaps edit the jinja2 so that it doesn't create the spaces. I am open to all recommendations Thank you------------------------------Shane Miller------------------------------
Hello, I am trying to add a clickable link to a form I have. I'd like for the URL to take the numbers in a field and put it into a URL . For example the URL is https://pleasehelpmesolvethis/1234567/abc I have a field called Contact ID that I would like to fill in the numbers. Does anyone know how to do this?------------------------------Evan Holler------------------------------
Does anyone have a work around for the following? I have a table with Parcel Numbers. They can be quite long, something like 06545500006452300. I have this in a text field. When downloaded to a CSV, it will show as 0654550E+12. Essentially, trying to turn it into a number which excel can't handle. Anyone run into this, and have a good work around?------------------------------Mike Tamoush------------------------------
Hello Everyone, I have been trying to research if it's possible to highlight an existing date field in red if that field is already blank. I have updated my form to now require that field to be filled in. An example is we have clients come to our office for resources. When a new client comes in we create a profile for them, verifying a few documents they are asked to provide. In some cases, we will help the client without the verifying documents. The field "Verified" is then left blank so that when the client comes back they bring the documents and we can update the verification date. Is there a way that while on a client's record the "Verified" field can highlight red when either viewing or editing?------------------------------Alex Bartholomew------------------------------
Anyone else seeing very slow performance the last 2 days? It's taking 20-30 seconds for our forms to load and general navigation of the site is reduced. ------------------------------Thanks,Chris Newsome------------------------------
Hey Community, Do you have a way of using a formula field so I can reference the user Table and pull in the "Last Visited" value into my employee table within my app? I have a user Ref. field on my table and I use it to assigned Project, Tasks, Approvals, Etc. to my users. I see that we have a last visited value on the user table on the backend of the system Anyway to reference that last visited value inside of my app?Thank you!------------------------------Jack Woods | Low Code 4 Lyfe------------------------------
Hello, I have read up on all the community topics that I can in regards to pipelines and prev values/ current values. I have read through most of the Jinja2 documentation.From all that I have read, I have created the following jinja2 code within an update step for a field type Text - Multi-line:{% if a.dba != a.$prev.dba %}_dba changed from {{ a.$prev.dba }} to {{ a.dba }}{% endif %}{% if a.Tax_ID != a.$prev.Tax_ID %}_Tax ID changed from {{ a.$prev.Tax_ID }} to {{ a.Tax_ID }}{% endif %} With this in place, if I change dba and tax_id and then click save, this appears:_dba changed from 4 to 5_Tax ID changed from 4 to 5Perfect!!! Exactly what I wanted. I then have a formula text that formats the above field. However, if I add more if statements to this jinja2 code:{% if a.dba != a.$prev.dba %}_dba changed from {{ a.$prev.dba }} to {{ a.dba }}{% endif %}{% if a.Related_Broker != a.$prev.Related_Broker %}_Related Broker changed from {{ a.$prev.Related_Broker }} to {{ a.Related_B
Can we move a table from one application into another with all the relationship intact?
Currently attempting to send employees reminders regarding several topics, also these employees don't have user names within QB and I would be pulling their email addresses from the database. Currently able to run it if I assign the index location, but seemingly unable to get looping functions to work. I am able create duplicate send email actions with their index location, but seems problematic. Currently operational with manually calling out [0],[1],[2]. but obtain error messages when not all three requests are completed, additionally, I am limited to 3 records. Seems like there should be a simpler method to loop these requests ------------------------------Jonathan Hade------------------------------
Currently trying to revamp the email notification template we are using to convey information about ETO requests to make them more readable. Wrote up some CSS and used a <style> tag to inject it rather than writing it directly inline. the <style> tag has a type of text/css, yet I am getting an error about using javascript? Is it the tag type that is triggering this error? <style type="text/css">.EmailBody__sectionTitle { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; color: #1d1d1d; font-weight: 800; text-decoration: underline; } .subContainer__label { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; font-weight: 400; font-size: 1.2em; color: #0000FF; } .subContainer__data { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; font-size: 1em; } .subContainer__information { font-style: italic; font-family: 'S
Hello, I need some help. I need to generate a Percentage based on How many times a member joins a meeting per year. I have each attendance as a simple checkmark and then another field for a date. We have various types of meetings some are only like twice a year or the most we have is 11. Each record is per person so I have dates filled and just if they attended or not. Is there anyway to make quickbase know Which meeting is the last and make that a number to use to add to a formula to calculate a percentage? How would I write a formula where I could have the total number of Checked Attendance/ by the Maximum number of meetings per year. Like have one record have 7 meetings and the person only attended 5 and have the field with the formula generate 71%. but then the next record have 5 meetings and have only 1 meeting and have the field with the formula automatically generate 20%? Or does this have to something that Has to be manually done because the records can vary too mu
Hi, I'm trying to make a button that opens a specific form in edit mode depending on where the record is in a process. Using URLRoot() & "db/" & [_DBID_EXAMPLE] & "?a=er&rid=" & [Record ID#] I was able to get a button that opens the form in edit mode, but it only opened the form that had a role associated with it open in edit mode (i.e. Role has Edit Form (Full site) set to Form 2 instead of blank. When changed to blank it went back to default form). I want to be able to have it open Form 2 in edit mode at one point in the process, open Form 3 in edit mode at another point the in the process, etc.------------------------------Nolan Pilozo------------------------------
I see that Quickbase has announced a TBD date on the Automations End of Life date in the October Release Notes.Quickbase October 2022 Release Notes Automations not reaching End of Life in January 2023 The next phase in our Automations retirement journey is the End of Life phase. This is the final phase, when the Automations feature will be completely removed from the product. Pipelines is the future of automation and integration in Quickbase. It supports both orchestrating workflows within Quickbase and integrating workflows across your tech ecosystem, all in one place. To prepare for the End of Life of Automations, we gathered feedback from many of you on how you plan to continue creating new no-code workflows. This uncovered an opportunity for several key improvements to Pipelines, which will replace Automations. These improvements will make it easier to build and govern pipelines, and help pipelines run faster than ever before. We also heard that you needed more time to accomp
Hi all, I am looking for a way to configure a button that when I click it, it opens a new tab to add a comment, after finishing the comment, I need to save it then close that tab automatically. Do you have an idea on how to achieve this? Thanks!------------------------------Esteban Vega------------------------------
I would like to use a dummy variable in a pipeline to store the parent Purchase Order ID. If existing, use the existing ID, if not create a new PO and use the new ID. The pipeline would then continue, adding child records to the "poholder" ID. I haven't used dummy variables before and wanted to check if the formatting is correct? And if I can just nest this statement within another text field. If not existing: {% set poholder = c.id %} If existing: {% set poholder = b.id %} Thank you!------------------------------Christine White------------------------------
I am currently trying to add a user to a userlist field named "assigned to" on file import that uses the value in a lookup field that is based on another table of credit card numbers and the credit card holder name. This field changes users consistently so adding it to the credit card information table will not work. Dynamic rules do not apply on import so what steps in a pipeline will do this for me? ------------------------------Chris Baker------------------------------
Hello, we have a application set up to track the tickets we submit to vendors. Each ticket has many correspondence records. Our stakeholder would like to see the latest correspondence records for a given ticket when they click to view the ticket information at full page. I have embedded the report in the records successfully, and it works fine. I am wondering if there is a way to get the report to expand to the width of its container? Each correspondence record contains a lot of text, and having the report only occupy ~25% of the page is not very appealing and makes reading correspondence difficult. Is there any way to modify this? ------------------------------Alex Couts------------------------------
Hi, I am new to quickbase pipelines. I would like my flow to do a if-then-else base on a value in the message body. In step A, I setup a Webhooks-Incoming Request. And then in Step B, I want to evaluate a data from {{a.body_params.header.Action}} to a value. If true, then do something. That's it. However, seems like no matter what I typed in the box, the evaluation result always set to "True". (i.e. "evaluates to TRUE" become the pre-set constant result). Anything I did wrong? Besides, I can't pick a data field from the A.Body Parameters.Header UI. It shows "No results found". How to let quickbase to learn a data model and so it can populate data fields? Here is the return from the the webhook. Thanks for any suggestions. Cheer, Kinson------------------------------Kinson Lam------------------------------
Is there a way to open New Forms in Full Screen? &ifv=1 does not work.------------------------------Charlene Dougall------------------------------
Hello, We have created three different forms under 1 table. If someone creates a record using form 1 we would like to view that record in the form 1 format and if someone used form 3 then we would view that record in the form 3 format and so on. I know we can create different reports and select what form is used for each report but we would just like 1 report for all the different forms and QB to show whatever form format that was used for that record. Is that possible?
Hi - We built a new form using the new form building and created a report that is setup to view the new form. We have been able to edit/view the records from this report (showing the new form). But today, the record won't open. It seems to be in a loop trying to open the URL. We have not changed anything in the table/report/form. Thanks for any help!------------------------------CARRIE IWASAKI------------------------------
We have an employee database where employees are able to generate time-off requests to be approved by their manager and correspond with accounting information for PTO purposes. Requests are made using a form from a table that holds records of PTO requests, each new request adds a record to that table. Currently, when a user goes to edit the form, the drop down selection list signifies that it has found records (20 records, the amount of employee records) but the select options in the menu are blank? they are select-able and employee information does populate the subsequent fields once an option has been selected but I cannot get the records to actually appear in the drop down list. Typing anything in the box to filter, filters out all records. Before Selection: After Selection (populates information): At the field level for the table that the time-off table is referencing (employee name is a look up from the employee records table) I have selected the options th
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.