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 concept in mind and I think that Quickbase has the capabilities, but I just want to get input from others who know a lot more than I do. So, we are a travel company and we have partner companies that purchase certificates from us. Currently, we print them out with a specific code and number on each one and FedEx to partner for distribution. Recently, we have decided that we would really rather the certificates go out digitally and that is going ok. And now, I was wondering if it is possible for a partner to login to their "limited-access" portion of Quickbase and 1-enter in required info (name, email, account#) of person to receive certificate and Quickbase can then generate and email certificate and/or 2-partner logs in and is able to enter amount of certificates to be sent to his location. I am confident that #2 can be done, but I am curious about #1. Please share opinion, info, guidance. I can tend to overthink the obvious. Tha
Please help with this "thought'...If....[INSULATED ?],"FALSE"AND [BLDR SCHEDULE.HANG DATE] is tomorrow (or Monday if today is Friday)"red"Thank you....
I want to filter records in a dropdown based on whether a related field is true. Specifically, a project dropdown should only reflect projects with a "funded" status and hide "completed" and "cancelled" Conditional dropdowns doesn't seem to apply, since one reference field is involved.
Hello,I need help with a formula i am trying to use. I found this in another discussion from last year but it did not work for me.If([Audit Type] = "Standard Monthly", [Verint ID] or [Audit Type]= "New Hire", [Verint ID] or [Audit Type]= "Soft-Landing", [Verint ID])I want to use my multiple choice field "Audit Type" to determine when the "Verint ID" field should be unique. I tried the formula above and it gives me the error below. It will not allow me to save any record for the 3 choices above even when the "Verint ID" is unique.
I need to rename an attachment. I want to remove all blank spaces and replace them with underscores. I found a post from 3 years ago that asked the same question. There was no inherent solution at the time.In a pipeline, I can upload the file to Sharepoint and add text to the front or end of the name, but I can't inherently adjust the original name.In the below example, I am adding a string of characters to the beginning of the name but I can't figure out how to adjust the 'File name' property of the Attachment type. Any suggestions on how to change the the 'File Name' attribute prior to calling a pipeline (i.e., formula-text field) or within a pipeline will be appreciated.Thanks...Aaron
Hello,I want to create a multi-select field from the records/options that are housed in the parent table. I have over 100 records/options in this table, and I want to create a multi-select field based off that. Is it possible?
Hello, looking for help on the following problem. I have a child table tracking step changes to a parent record. Each Step change has a From Step, To Step and Step Date:Record IDID NumberFrom StepTo StepStep Date11001InitialSecondary1/1/202421001SecondaryTertiary1/3/202431002InitialSecondary1/15/202441002SecondaryTertiary1/17/2024 I am trying to calculate the time between steps by ID Number. I think I need some way to pull the Step date of the previous record related to the ID number into the prior row to run the duration calculation, but I'm not sure how best to do this. When its the last step related to the ID number, this value can be today().Here is what I think I need a calculation to do:Record IDID NumberFrom StepTo StepStep DateStep End Date11001InitialSecondary1/1/20241/3/202421001SecondaryTertiary1/3/2024Today31002InitialSecondary1/15/20241/17/202441002SecondaryTertiary1/17/2024Today Any suggestions would be appreciated!
Good morning folks! Writing to remind everyone of our second Women's Qrew meet up that is taking place tomorrow, 7/16, from 1-2PM EST! Based on last month's conversation, we heard a desire to learn more about how to leverage your QB building skills to grow your career. Joining us will be two guest speakers to help foster a conversation around this topic:Nichole Braswell, Quickbase Developer at Sympo &Sherri Kottmann, Chief People Officer at QuickbaseWe're looking forward to hosting these two amazing women, and hope to see you all there! If you don't have the calendar invite, please join us via Zoom . As always, please feel free to reach out to me directly (tluccio@quickbase.com) with any questions.
Hello! I've been working with formula fields to concatenate multiple field values in connected tables to limit dropdown options for users picking a related record. I'll try to write out the example, then put the problem I'm running into below.Table 1: Customers (Child) | Table 2: Inspections (Parent)Customers have a date (date) and a type of inspection (multiple choice).Inspections have a date (date), types of inspections that could be scheduled (multi select text - same options as Customer types of inspections) . Each inspection also has a scheduling status (multiple choice - open, scheduled, capped)Customers concat field:[Customer date] &"Open") &If(Contains([Inspection Type],"3-day"),"3-day",Contains([Type], "2-day"),"2-day",[Type])Inspections concat field:[Inspection Date]&[Scheduling Status]&If( Contains(ToText([Inspection Type(s)]),"3-day"),"3-day", Contains(ToText([Inspection Type(s)]),"2-day"),"2-day", ToText([Inspection Ty
I am trying to use the AI Smart Builder to build a pipeline. I tried a very simple request to start off but the builder just seems to hang there in the "Initializing" state forever.The text I entered to seed the AI builder was:"when a new record is added to the Change Mangement Attachments table in the <abcdefg> app, send an email to the person that created the record."Here is where it stalls. Any suggestions?
Any way to set the default font and font size in rich text fields on forms?Thanks.------------------------------Jennason Quick Base Admin------------------------------
I have a Form Rules Conflict that I cannot resolve. It is supposed to work like this: the user can select from 1 up to 8 steps of approval from the "# of Approval Steps" numeric, multiple-choice field. If they select 1, then Approval Step 1 "shows" (2 thru 8 "hide"). If they select 2, then Approval Step 1 and 2 "shows" (3 thru 8 hide).What is instead happening is that when 2 is selected only 2 displays, instead of 1 and 2. Likewise, when 3 is selected, only 3 displays, instead of 1 and 2 and 3 etc.. all the way through 8.I think the form rules could work if there was a way to "turn off" the 'Otherwise' section. Is there a way to do that or is perhaps Custom Data Rules the preferred option or ?
Problem with data involving a Time Card Table and a Dispatch Table.one Time Card : many DispatchesEach tech has one Time Card per day and 2-3 Dispatches per day.The Techs daily Time Card Record ID# is entered into each Dispatch when created. Here is what the columns in the Dispatch tbl look like (with about 10 columns of misc dispatch data missing for this example): Example AttachedThis is one week of activity, and I want a summary report in the Dispatch tbl to show the total hours the techs were on the clock, to compare travel time, billable time, and clock time. This example (164:29) is all I can get to show up on a Summary Rpt. I need to have only one TOTAL CLOCK for each Related Time Card. The actual time for tech GO was 31:28 and for tech JD was 48:30 for a total of 79:58.
Table: Take/off CalculationsWhen ESTIMATOR VERIFIED is checked I need Pipeline to duplicate all records associated with GRAND BAHAMA.ALL to Grand Bahama.L and Grand Bahama.M
I have a "Reminder" notification setup to trigger when a date field is after the value by a certain amount of days. Is there a way to specify the report to use when sending this email? Right now it is using the "Default Report", but I would like to change to a different report if possible.ThanksBrian
Hi,I have a URL formula field button which runs some other automation functions. This works fine when manually pressed.I have no issues with the scheduling part. I'm sure its something simple, but what I can't figure out is what I need to do in the Pipeline to simulate "Pressing the button"? Thanks.
I want to write a pipeline which can tell what field is modified in a table.who modified it and when . Below is table structure I am using.Table name,field name,modified by,modified date,action done(replace,add,delete).I am using quickbase action but it can't tell which field is modified . All other videos and link requires that modified field name should be known beforehand if using pipeline. I also don't see any option in pipeline where we can get field name . Can anyone please help.
Hello all! I could use some help with a pipeline. I have a table called assets. When the sales team adds assets to an order they enter a quantity. There are times that the operations team then needs to take an asset with a quantity of 4 and split it into 4 separate asset records with a quantity of 1. I need to create a pipeline for this use case. I have seen the sample create child pipelines and neither one fits my particular use cases. I was just curious if there were any jinja/pipeline wizards here that could give me a hand. Thanks!Nick
I have a reference field with drop down options. When I update the field inside the form and save, it doent get saved but the when I update it with grid edit it works. What could be the reason? Please help.
Hello, I have a button in the embedded report to allow the user to quickly add an update with the current record. However, I don't want the button to add an update display if this record is considered closed and the user not add an update with a closed record - only add an update with a current active record. Is there a way to only have this button show in line with a current active record that needs to have update records added? Screen shot of the purple buttons in questions.
I am relatively new to QB, but am excited about the possibilities for tracking multiple things.I have a table containing the names of documents within our system (primary). Each of those primary documents reference other documents. In addition, each primary document has a set of abbreviations/terms.I have built a table (table 1) with the documents and their identifiers. There is a second table (table 2) that has a list of universal abbreviations/terms.In a third table, I would like to choose a single primary document from table 1. Then I would like to choose multiple documents from table 1 that the primary document references in the text. Then I would like to choose the multiple abbreviations/terms from table 2 to associate with the primary document.Example: POL-0001 has a reference to SOP-1001, POL-1003, SOP-1004, and SOP-1005. It also has 17 abbreviations/terms that are used in the document. I would like a table that has all of these it
In an AR tool i am developing, I am calculating the amount owed for a project. If the total is positive for the amount column, it should be "Open", if the total is 0 it should be "closed", and if the total amount is negative it should be a "Credit". The issue I am having is some totals are summing to "-0.00" registering as a credit, and some totals are correctly summing to 0.00 as "Closed". How can i fix this?
I am working on creating a new form, using the new form options, to update a legacy form. No major issues, other than a bit of wonkyness regarding field spacing. The only real issue is the displaying of formula url fields displaying as a button. I have 4 buttons (2 are hidden via dynamic form rules) and the only difference between them (other than what they do) is I selected a display color.2 of the buttons display with white font and perhaps a white boarder, and the other 2 display with black font and a black boarder. For the life of me I can't figure out where the setting is that determines if the font and boarder should be white or black. The formula url on all buttons have no formatting included in the formula.Anyone know what might be going on? I'd like for all buttons to display with my chosen back color and with white font and a white boarder.Thanks
I am trying to set up a date field that has changed logged within the form, similar to text fields. Is this possible in Quickbase, maybe using a formula? We are tracking target completion dates. These sometime change, but we want to track how often the target has moved and we want that visible in the form (hence not wanting to use pipelines to achieve this and tracked in a separate report). Any suggestions/solutions?The current field is Date/Time, which does not allow logging.
I followed the example listed here: How to use Pipelines to email a report at a specific time of day | Qrew Discussions (quickbase.com)However, my Json reponse includes a date. The example formats Percentage and Currency, but does anyone know the syntax need to format a date data? I need it in the MMDDYYYY format (no time stamp).Thank you.Mark
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.