Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Having an issue with pipelines and multiple calendars in a single mailbox.I can get calendar events created/updated/deleted into a table with a single calendar, and am using the id of the event to track unique records.I'm finding in the pipeline activity that event ids aren't feeding into the pipeline with unique values, but the create/update/delete is working somehow anyway with one calendar. Does Quickbase track uniqueness of outlook events somewhere behind the scenes? It works so I'm not complaining too much on this one.My actual question...Adding a second pipeline, pointed at a different calendar in a mailbox doesn't trigger the additional pipeline at all. Is this possibly a bug? This function reads like you can connect multiple calendars from the same mailbox.
Currently, the %recLink% in notifications allows the user to open the record in view mode. What URL can be used in a notification to open the record in edit mode? Bonus points if the user can be pointed to a particular form (in edit mode). Thank you!------------------------------Colleen Burch------------------------------
I have a parent record with child work records. The parent record also has child records attachments. I'm pulling all of the information from the parent recod into the child work record, so the user does not have to go out to the parent record to see the details. The one issue I have is how to show the attachments from the child record onto the child work record?Tables Parent Table--Grievence child record--Work record Parent Table--Grievence child record--attachments
I am trying to setup a structure where you have a Co-Name, Type and Subtype (3 connected tables) I have the relationships setup where the following works. Each co has one type each type can have one subtype Subtypes are conditional on the type selected. Is there a method to allow the subtypes to be a multiselect option? I would prefer to have each of thes in a separate table for ease of management of the data Thank you.------------------------------Eric Fixler------------------------------
I've built a formula that allows us to push a button and it extracts information from quickbase and throws it in an editable email for us to send through our outlook. I was wondering if there is a way to do the same thing, but include a PDF attachment? ------------------------------Newman, Savi------------------------------
Hello, I'm currently working on implementing a conditional drop-down field. I have a parent table named 'Units' and a child table named 'Programs.' The Program associated with specific units. I was able to create a conditional drop-down however, I can only select one option in the drop-down, is there a way for me to make a conditional field a multi-select text drop-down? Thanks, Dipa Panchall------------------------------DIPA PANCHALL------------------------------
A sister company of ours is transferring a copy to us of an app that we want to use. I have received the application transfer notification email from the pipeline, but it is directing me to sign in to our sister company's quickbase realm to retrieve it. Since I am not set up as a user in their realm, I am unable to proceed. We've transferred apps before but it seemed it was much easier and I can't remember what we did to complete the transfer. Does anyone have any suggestions? What am I missing?------------------------------Doug Crandall------------------------------
I've seen several posts on manipulating dates, but none that seem to specifically apply to Webhook JSON POST in the Message body. By default, { "date": [ { "value": "[mydate] " } ], exports as mm-dd-yyyy, but I need to format to yyyy-mm-dd Is this possible to reformat in this dialogue? Thanks, James------------------------------james crump------------------------------
Hello! I have a table called "Topic Repository" that lists out a training topics and how often we need to train on that topic. For example: Topic Being Trained Training Cadence Required (Contract Requirement) Date of Most Recent Training HIPAA Monthly X/XX/XXXX Hospice Quarterly X/XX/XXXX Diversity, Equity & Inclusion Yearly X/XX/XXXX I have another table (in the same app) called "Training Records" that logs different trainings. For example: Training Title Date of Training Hospice 12/14/2023 Hospice 2/3/2024 HIPAA 8/10/2023 HIPAA 10/10/2023 I would like to create an automation/webhook/formula field, so that when a new record is added in "Training Records", that record's Date of Training it will update Date of Most Recent Training in "Topic Repository". It needs to only change this field if it's the most recent date. One training topic in the repository can have many training records. Does anyone know I can do this? I've watched s
I am graduating to more Cross app integration but adding users to several apps (and remembering to add them to all applicable apps) feels like a daunting task. I am reading about groups and it seems that I can have users in a group and then I can assign groups to apps. I am still having trouble wrapping my head around how the security will work. So I have a group that does outdoor recreation activities and they have an app to manage their equipment and with in that app they have a role that limits what they can see and the role is based on the club they work at. Now we are building out a procurement app and I don't want to have to rebuild those same roles in the procurement app but I want to limit it so that they can only track orders for their club. If I add the group to the procurement app will it use the role from their equipment app? ------------------------------Julie Meeker------------------------------
*Note, my title says End of Life, but should read End of Sale (webhooks will still work, just can't add any more). However, this posting still reads the same. Hoping to get more eyes on this blog post, and if there is enough uproar, maybe Quickbase will reconsider. The comments on the post are spot on (I would add a comment, but for the life of me cannot figure out how). In addition to the current comments, webhooks are great for very simple tasks (if a new record is created, create record in my combined table...), keeping the number of pipelines down to a manageable amount. If I had to convert my webhooks to pipelines, I would suddenly have an extra 100 pipelines, making it nearly impossible to search through. I understand that my existing webhooks will stay, but in the future who wants to search through thousands of pipelines? Let your voice be heard if you think the removal of webhooks is a terrible idea! https://community.quickbase.com/blogs/brian-cafferelli1/2024/03/15/creation-of
Hey folks, Working on a project where I need to track down App Tokens in use some code pages. Is there a minimum or maximum length of App Token Strings? Thanks!------------------------------Sam Joneshe/himSenior Technical Account ManagerQuandary Consulting Group[Set up a call with me](https://fantastical.app/samrjones-tWiK/qcg-tam-checkin)------------------------------
Hello, I would like to send a weekly reminder email 7 days after the record is created and would like it to keep sending until the Est. Start Date field is filled out. Can this been done? I would like it to only send the records that they are the record owner on. As an added bonus is there is a way to have the reminder email to start up again once it reaches the date in the Est. Start Date?
Hi Folks, I'm trying to create a landing page for a button. I want to use field values from the table to be displayed in the landing page, How to do that using Code page? Thanks in advance, ------------------------------RH------------------------------
Hi, I have 2 dropdowns fields: 'Category' and 'Subcategory'. In 'Category' field I have dropdown of the below value: A, B, C And in 'Subcategory' field I have dropdown of the below value: 1,2,3,4,5,6,7,8 Is there a way to show just part of 'Subcategory' dropdown list depend on my selection in 'Category' field? For Example: If I will select Category A, 'Subcategory' dropdown will show me only 1,2,3 If I will select Category B, 'Subcategory' dropdown will show me only 4,5. and If I will select Category C, 'Subcategory' dropdown will show me only 6,7,8. ------------------------------Thanks in advance, Ori Dotan------------------------------
Hi Everyone, is anyone facing the issue when you try to filter report view for today date, it was working before but today if you select filter by today it will automatic select isempty for you even when you input today date as custom. it's still not working. Many Thanks------------------------------Emorn Reardon------------------------------
Hi, I have 2 fields: 'Author role' (user) and 'Category' (dropdown list: A, B, C, D, E). Is there a way to show just part of dropdown list, depend on the user on 'Author role' field? For example: If the user will be PM he will see only the values A,B,C in 'Category' dropdown and If the user will be PE he will see only the values (C,D,E).------------------------------Thanks in advance,Oriel Dotan------------------------------
Hi, I'm a newbie with QuickBase. My involvement with QuickBase is more consuming data for our BI platform using API Do query. I added new fields in a table in QuickBase now when I do the get records adding those new fid to the column list, using API Do Query I receive the fields, but the values are in zeroes. When I go to the physical table in the source (Quickbase) the values are there but I am receiving them in zeroes. Do you have an idea of what I missed when creating those new fields? Thank you in advance for any light for me on this. ------------------------------Vanessa Torres------------------------------
I need to create a field that Auto-generates the User who input a date into a date field. What are some ways of doing this?------------------------------Ricky WhiteRicky------------------------------
I am wanting to import or copy a set of master records from a template job(one of many so I need to be able to select before I push the button) , The selection being made on the jobs form. This process was working before they made code pages the only place you can run javascript code. The formula i Used before is this URLRoot() & "db/" & [_DBID_JOBS] & "?a=API_GenAddRecordForm&_fid_18=" & URLEncode ([Contact info ID#])& "&z=" & Rurl() This code still works in another app but the 18383 is the reference to the Job that the detail records are to be copied from. I am having problems getting the code pages to even show up on the form as a button. What am I doing wrong? ------------------------------Loran Prince------------------------------
Is there a way to convert a pdf created using patch processing to a word document?------------------------------Amna Anwar------------------------------
please help me in creating a formula text field that checks whether the candidate is 18yrs or older based on the dob field------------------------------vikas pasula------------------------------
We need help building a pipeline for our Overall Status fields that has multiple conditions. We want to grab Overall status based on the criteria given below. QBID Overall Status Program Status A. If all QBIDs are in Completed status Completed B. If A is false, & if one or more QBIDs are in In Production status, follow these rules based on Overall Status 1. If any Overall Status = On Hold On Hold 2. If 1 is false, & if any Overall Status = Development Paused Development Paused 3. If 2 is false, & if any Overall Status = In Jeopardy In Jeopardy 4. If 3 is false, & if any Overall Status = At Risk At Risk 5. If 4 is false, & if all Overall Status = On Track or (blank) On Track C. If B is false, & if one or more QBIDs are in On Hold status On Hold D. If C is false, & if one or more QBIDs are in Backlog status Backlog E. If D is false, & if one ore more QBIDs are in Solutioning status Solutioning ------------------------------NOEL H
I build a Rich Text Field to be included in a subtable for Exact form plus. The field has some html and multiple fields. The fields info outputs perfectly fine but html like bold is outputting as html. Can I not include html in rich text field to be included in subtable?------------------------------Amna Anwar------------------------------
I created a pipeline and it updates a number of records but the logic went a little too far. Is there a way to undo the last pipeline run or a trick to recover the previous state of the records?------------------------------Conor Gray------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.