Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I have a multi-select field called Industry Relevance that I want to display as a list in reports and on forms (when viewing). I created this formula text field: Industry Relevance List using this formula: SearchAndReplace(ToText([Industry Relevance]),"; ","\n") This functions properly with the old style reports and old style forms, but with the new style forms and new style reports, it shows the text in a string. Thoughts on how to fix this? Thanks in advance! ------------------------------Karen Henke------------------------------
In New Forms, I'm attempting to create any kind of link or button that will open a PDF stored in another location while an EOTI user is Adding a record.EOTI Use Case:1. EOTI User is adding a record and needs to attach a hand signed form. 2. Beside the attachment field exists a Formula URL button to "View Blank Form" to allow for download/print. Button is set to Open Target: In new window. 3. Idea is that User can navigate to a new tab/window by clicking this button without losing their progress. We do not allow EOTI to Save/Edit... only Add/Submit in this application.Unfortunately, all methods I've tried (URL / Formula URL / Formula Rich Text / Rich Text Form Element) will not allow this navigation to occur and causes a notification to the EOTI User: This shouldn't happen if the button is target a new tab?Thoughts?------------------------------Kurt Johnson------------------------------
Hello all, I'm having some trouble conceptualizing the best way to achieve a report that would provide a retrospective look over time at the number of active assignments on any given date, to allow us to track changes in various related metrics over time. Basically I have a table of technician assignments where each assignment has a start date and an end date, and the same for vehicle assignments (and there are probably other things we may want to apply this concept to in the future). What I would like to end up with is a report that can query and display the number of active assignments as of, say, each Friday this year. To do this, I need some way to test whether each Friday date falls after the start date and before the end date of each assignment, then count the assignments where this is true. I've tried coming at this via a summary report, considered a pipeline, and attempted a record query formula field, but these each seem to fit well for one piece of the equation then get stuc
Is there a way to print the new form format? ------------------------------Carly Epley------------------------------
I am trying to make a Pipeline that will create a set of Tasks (child records) to specific Reports (the parent record). Everything is working until it gets to the Duration field that I use to record default time for a simple task in the list (instead of requiring a logged time entry). If I use the Smart Time entry that I can use inside the duration field, it bombs and tells me it needs to be an integer. I put it in numerically, and it simply does not fill in the duration when the Task record is created after the Pipeline finishes its run. Any suggestions for fixing this?------------------------------Jennifer Peterson------------------------------
I am struggling with the formatting for my Kanban Card (see formula below) How to obtain 8 spaces without repeating &nbsp 8 times How to change the font color to AF0061 for the Pipeline Time Fence field (this one field should be colored, the rest should all be black) Thanks in advance for Community help! 1 "<div style=font-size:10px>"&"MCD #: "&"<b>"&[Project ID]&"</b>"&"&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp SNow#: "&"<b>"&[IT SNow ID (Project)]&"</b><br>" 2 &"MCD Leadership Over Ride: "&"<b>"&[Pipeline Time Fence]&"</b><br>" 3 &"Objective Score: "&"<b>"&[Priority Score Final]&"</b>"&"</b><br>" 4 &"Work Effort: "&"<b>"&[IT ROM (T-shirt)]&"</b><br>" 5 &"Primary Team: "&"<b>"&[Kanban Primary Team]&"</b><br>" 6 &"Epic Own
Duplicated in error ------------------------------Annetta Coleman------------------------------
I HAVE A LOOK UP FIELD, BUT IT ALWAYS GO FOR MAXIMUM NUMBER OF RECORD ID OF PARENT TABLE, BUT I DON'T WANT TO SELECT ON IT. IT THERE IS A WAY FOR ME TO AUTO CHOSE THE RECORD ID I WANT AND NOT TO CHOSE FROM THE DROP DOWN? I DON'T WANT TO CLICK ON IT AND SCROLL ALL THE WAY DOWN TO CHOOSE THE MAXIMUM RECORD ID NUMBER OF OTHER TABLE, IT COST ME A LOT OF TIME.------------------------------Golden West------------------------------
I am looking for how to write a custom data rule to handle a Unique field. There doesn't seem to be any documentation or I have not found it yet. If you know the syntax for handling a unique field in a custom data rule please let me know.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Is there a way to show a Kanban Report on a Form that is filtered by the current record on the form? I am hoping to allow users to move the card to change the status of the record as opposed to using the drop down. Having a hard time just displaying the related record and It's got me scratching my head what I am doing wrong.------------------------------Troy MacPherson------------------------------
I want to remove the built-in 'Delete' options but keep the ability to delete a record (via Formula-URL and Pipeline trigger). I can get them to disappear by the table's Access permissions but this also eliminates the ability to delete a record via a Formula-URL Button+Pipeline trigger. Any ideas? ------------------------------Aaron Bab1692@att.com------------------------------
access issue when editing a record with a button from a report within a Dashboard: <qdbapi> <action>API_EditRecord</action> <errcode>3</errcode> <errtext>Insufficient permissions</errtext> <errdetail>You don't have permission to access that page.</errdetail> <username>ilya@maximind.ca</username> </qdbapi> However no access issue when clicking the same button in the native report (not from the Dashboard): Testing as a specific so user get the expected error upon clicking the button: <qdbapi><action>API_EditRecord</action><errcode>2</errcode><errtext>Invalid input</errtext><errdetail>ILYA BAM can edit data but you're testing as that user, so your change wasn't saved</errdetail><rid>4295</rid><num_fields_changed>0</num_fields_changed><update_id/></qdbapi> Any idea why user can't edit the records within the dashboard
Pipeline "Buckets" has a great facility to define a table, add rows, and create a downloadable csv file. However, in the finished csv I want it to sort one of the columns (headers) called publication name A to Z. Where/how can that be done? is it in the define table step? or later? Can this be done? Jeff------------------------------Jeff Elliott------------------------------
Hi allAre their any construction companies that have completed this connection? If you have found this valuable to your company, what is the best process for moving forward and how would you suggest to do so.------------------------------Jessica Matenga------------------------------
Hi, I'm struggling with something - hoping for some guidance. I have a parent table with a Status field (New, Pending, Closed). When the record is created, a pipeline triggers to capture the Status, and the Date/Time in a realted Child Table. I am capturing every status change in the same way so I have a history. In the Child Table I'd like to calculate how long each step takes. I have the Step Date/Time as a starting value, but how can I capture the End Step Date/Time? This would be the same value as the following record's Step Date/Time, but I'm not sure how to get that value into the previous record. Any suggestions? ------------------------------Troy MacPherson------------------------------
Hello - On my dashboard I have several gauge reports showing as counters and the numbers are all different sizes (and appear bolded compared to other text on screen), so I would love to use a Rich Text element instead to have more control over formatting. Is there a way to add field values (in this case a summary numeric value) to Rich Text elements using the code <> option? If so, are there any resources on syntax? ------------------------------Thanks in advance,Jennifer Paschal------------------------------
Help! I have a pipeline that runs great as long as I don't put in an advanced query. If I put that in, no matter what field I reference or syntax I use, the pipeline bombs because of the advanced query. Her's the syntax I am using: I am thinking this says Look in Field ID 12, and if that is greater than 0, select the record. Again, it works fine with no value in there, but any value seems to break things. Thoughts?------------------------------Don Strickland------------------------------
Hi I have 3 tables Office < Activities < Barriers encountered When our staff evaluated an office they log an activity and (among other things) check off any barriers that office has to the project. I can summarize the text 'Barrier short name' to activities, but I can't text summarize the text up to the office - the field shows blank. Has anyone done this or have a work around ? thanks------------------------------Richard Chagnonrichard.chagnon@northwestern.eduNorthwestern UniversityChicago IL------------------------------
One of the most popular Pipelines integrations in Quickbase is the Outlook channel. This channel allows you to move email messages and their attachments, as well as calendar events, into other systems such as Quickbase. It also supports sending emails and scheduling meetings in Outlook automatically. Within the Outlook channel, one key component is the ability to work with shared mailboxes. These are commonly used to collect messages like support requests or orders, in a way that allows a team to access and respond in a timely manner. Based on customer feedback we will be making changes to our Outlook Pipelines and how they work with Shared Mailboxes to create a better and more consistent experience. What is Changing and Who Is Impacted You may need to make changes if you are currently using a shared inbox in an Outlook Pipeline using the following steps: Send an Email Send an Email with Attachments Reply to an Email You can learn more about how these changes i
Hi there, I have a field "Current Stock", which should become non-editable on grid edit after 14th of every month. Prior to 14th the field should remain editable on grid edit. This I have achieved successfully on form rules. But is there solution which can be achieved on Grid Edit? Or is there any API to disable the grid edit functionality using scheduled pipeline? Regards! ------------------------------Aanokhi Gupta------------------------------
Hi guys, I am new to Pipeline, and I need some help doing the following task: Loop through the first half of a text field containing many numbers separated by ";", and comparing each number to the record ID. It accepted the code but when I run it, this code popped up "Skipped because set values are the same as in source object." {% set array = a.j_classification.split(';') %} {% set first_half = array | length %} {% set first_half = first_half//2 %} {% for i in range(first_half) %} {% if array == a.id %} {{1}} {% endif %} {% endfor %}------------------------------Jay------------------------------
Hello, When the user clicks the table button to add a new record and then saved the record the screen will go back to the previously entered record instead of displaying the current entered and saved record - I'm not sure how to remedy this or if there are settings that can be adjusted within the main table buttons to add a new record? Here is the order of operations for entering the record: Started on the Member's table. Click Add New Member. Input member demographics. Click Save and close. ***populated previous member record instead of new record just entered and saved The user then has to go back to the member's table to locate the record they just saved to find the record. ------------------------------LB------------------------------
I can't for the life of me figure out why I'm getting this error. My formula is 214 lines. I added it as an attachment since it's so long. Any assistance would be appreciated. Also, what is the significance of the of where they highlight the error because it honestly seems arbitrary (I know it's not). ------------------------------Ji Kim------------------------------
I would like to create a new table that mirrors as existing table. So anytime records are changed or created in one table it will show in the other. Is this possible in quickbase?------------------------------Elizabeth Schlagel------------------------------
I currently have 3 fields that i am adding to gether in a formula [Other Savings Field 2.1]+[Other Savings Field 2.2]+[Other Savings Field 2.3] now if i wanted to add Other savings 1.1 to it conditionally. How would i go about writing a formula like that. My thought was to maybe have a checkbox to add to total but woudl that work? How would the formula work? Or is there a different way to have that field added to total? ------------------------------Kari Lang------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.