Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
When I used Quickbase previously, I had set up automations to update records based on certain criteria. I no longer see "Automations", I only see "Quickbase Actions". Has this replaced the Automations feature? When I attempt to create a new action, the only option that I see is to have it create a new record based on criteria. I would like it to update a record instead. The "Add Action" options default to "add a record" and if I click the drop down, it has "Edit related records" is greyed out. I attempted to select the table and criteria to see if it would then be able to select, but it was still greyed out. What am I missing? TIA! In case you need addt'l info on the action I'm wanting to create: If the "Amt Paid" is $0 and the review date is not blank, update the field "filing status" to "not applicable" ------------------------------Annette Gioia------------------------------
Is there any way to automatically stop the default view from being "new style"? I have to click this toggle every time I open a report. I like the older view, seems to run faster and I've used it for the past 12 years, so I know where everything is. I don't want to spend time trying to figure out where to find certain menu options with the new style. ------------------------------Annette Gioia------------------------------
I currently have a formula rich text button in an app that I am using to open an Import window in a pop-up, then using the data-refresh option to refresh the page after the pop-up is closed. Is there any way without a code page to have the page be redirected to another URL after closing the pop-up instead of just refreshing? My use case is that I want to automatically trigger a Pipeline after the import process is complete. If I just trigger the Pipeline based on individual records being added, I'm running into issues of the Pipeline running multiple times simultaneously and creating conflicts and duplicate records. So my plan is to have the button open the Import window, let people run the full import, then use an API call to check a box on the form, which will subsequently trigger my Pipeline. I have a second button I can use for the API_EditRecord, but ideally would like to avoid the additional click.------------------------------Oana Whalen------------------------------
Hi everyone, Can any of you share with me how you navigated migrating your realm to UTF-8? We've only had QB for 2 years, but apparently, UTF-8 wasn't enabled when we started. Over the past year, I'm watching errors pile up because a lot of our data is in written form (vs. hard numbers). For example, we'll have survey data and even the questions being asked contain apostrophe's and parentheses. QB isn't handling them well, and all of these characters are generating errors. To correct this, QB Tech Support had me install and run an encoding scanner to identify the errors in our realm, and it looks to be numbering in the thousands; nearly every record and a majority of our fields are flagged as problematic. Some of the issues I see are that the encoding scanner doesn't tell me "what's" wrong with our data, just that this record or that field is an issue. QB Tech Support said that to turn UTF-8 on will affect the entire realm AND I need to have all the errors fixed before they
Good Morning Everyone, Wondering if anyone has experience with Quickbase notifications using the cell carriers to send SMS text messages. Most people in our company have AT&T and we haven't experienced hardly any issues with the notifications. However, a few of our employees have Verizon and I've discovered an irritating limitation: Verizon claims they can send messages (limited to 50 characters) as an SMS text message. If the characters are over 50 but less than 1000, they claim it should send as an EMS message and deliver in continued messages (see below for reference). However, this is not what I've observed with Verizon. Has anyone gotten any traction with this? Or am I just at the mercy of 50 characters with Verizon?------------------------------Aidon Olligschlager |Flight Support SpecialistPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 2482029587------------------------------
I apologize if I'm missing something obvious, but as I am trying out the new forms and added the stock add new child formula URL button, it is just text when I preview. Are buttons not rendering on the new forms? ------------------------------Tate Forgey------------------------------
I've had a request to have some sort of tracking functionality for emails related to a record in QB (similar to the link below). I feel like there could be a way to do this with a Pipeline to/from Outlook?? Has anyone done something similar? I'm looking for a hero :)Thanks in advance! https://capsulecrm.com/support/setup-and-configuration/storing-emails/#understanding-the-mail-drop-box------------------------------Sherry Blackburn------------------------------
HELP! I've racked my brain over this one. I have a Numeric Total Field (Currency) that gets it's value via serval different possible options. 1st it looks at a Manual Entry Field. If the Manual Entry field is populated then value is multiplied by the Fee Rate to provide a Total. If the Manual Entry Field is blank... 2nd it looks at a Snapshot field and multiplies that value by the Fee Rate to provide a Total. If both are blank then the Total is $0.00. My is issue is if I entry 0 into the Manual Entry Field so there is no charge (treating it like an override) the formula isn't calculating. How do I account for this in the formula? Current Formula: If([Domestic Wires (#) - Manual]<>0, Sum([Domestic Wires (#) - Manual] * [Fee Schedule - Wire Fee (Domestic)]), Sum([# of Domestic Wires (Snapshot)]*[Fee Schedule - Wire Fee (Domestic)],0)) I have tried this one too... If([Domestic Wires (#) - Manual]<>0, Sum(If([Domestic Wires (#) - Manual]=0,0), [Domestic Wires (#)
Hi we are converting an excel app. We will have a Projects table with 5 projects. There will be about 10 tables that have lots of calculations. There are about 300 variables that the user enters, and are used variously throughout the calculations. Im wondering how to organize the variables and calculations. I could add all variables as fields in the project table and link the tables or use query functions to use them in calcs. OR I could have a variables table, with a record for variable name and value, but not sure this works for the calculation field (diff formula for each record?). Any ideas how to handle this?------------------------------Gerry Munroe------------------------------
Hello All! Is there a way to quickly convert a Legacy Form to a New Form? I'm excited to implement New Forms on our apps, but if we begin changing existing forms to enhance the user experience, I think we will need to do the same in many apps and tables. Other than pulling up my existing forms on the side and making a new form manually, looking at the old form, is there a good way to convert Legacy Forms to New Forms? If not, can I submit that as a suggestion? Thanks so much!------------------------------Hayley BishopQuickbase Developer and App Admin------------------------------
I tried inserting a link to a rich text on the new form and would like to attach a couple document links like the "Include Links" shown in the example. I have been able to insert the URL, but not been able to display a particular text instead of the url address. Is this a glitch with the new form or am I missing a step somehwere? ------------------------------Lynda Schutter------------------------------
Hi all, I am working on a formula query to try to build a line graph that will show cumulative sales for the current user in the current year and previous two years. I had this working without the by user filter. Here is my formula…. Just to help explain fid 19 is a lookup field that is a user. That is our sales person for the project. fid 66 is a formula field and in it is User() to get the current logged in user. For some reason this is pulling blank lines (all 0's) and not pulling in data. //fid 7 = [Billing Amount]//fid 11 = [QuickBooks Invoice Date]//fid 18 = [Opportunity Type]//fid 71 = [Current User Is Team Member (=1) - Lookup]//fid 19 = [Project Solutions]//fid 66 = [Current User] var text QUERY = "{11.OAF.'" & FirstDayOfYear([QuickBooks Invoice Date]) & "'}AND{11.OBF.'" & LastDayOfMonth([QuickBooks Invoice Date]) & "'} AND {19.EX.66}"; SumValues(GetRecords($QUERY),7)------------------------------Ivan Weiss------------------------
Hi Everyone, I want to create a webhook that generates a record whenever a record is modified. The scenario is as follows: Whenever a record (A) in the parent table is modified, I need to create a record in another table (C) for each child record (B) associated with the parent record. I have a webhook set up on the child table (B), but it is only creating one record instead of creating records for all the child records. Let's assume we have parent record A with three child records. When parent record A is modified, the webhook should create three records in table C, each corresponding to a child record. This is my webhook configuration: Trigger: When a record is modified. Additional criteria: Based on a particular lookup field. Please provide any assistance or suggestions to ensure that the webhook creates records for all the child records whenever the parent record is modified.------------------------------Amir Sohel------------------------------
I have a jobs table and an invoice table. There is a one to many relationship built between the job table and the invoice table as there can be several invoices for each job. There are three field in each invoice (date created, final checkbox, partial checkbox) that I would like to be able to access via my jobs table for reporting purposes. I'm having trouble figuring out how to get this to work. I tried building a invoice -> jobs relationship to get a related invoice field to relate the two items but it isn't working. What am I missing?------------------------------Dee Kearns------------------------------
Hi, I use email reminders and, in most cases, my default reports are somewhat large and render horribly as the inline email report. Has there been a suggestion submitted to be able to select a custom report rather than have the reminders default to the default report? If not I'd like to submit that suggestion: Allow the selection of a custom report rather than defaulting to the default report for email reminders. If there is currently a way to get around the default report today please let me know as I'm not aware. Thank you, Barb ------------------------------Barbara Alvarez------------------------------
We just had an incident and found the solution, and thought others may benefit. A user suddenly was having issues on the mobile interface. He would be editing a record and it would suddenly change the GUI, the screen would go white. Sometimes you could see a partial screen, other times it was completely blank. We realized it would happen as soon as the user clicked into a text field. The issue was, the user had set (unintentionally) his iPAD to use a floating keyboard. This can be done in settings or by pinching and squeezing the full keyboard. This floating keyboard completely wrecks the QB interface. As soon as we switched it back, everything was fine. Not a big deal, no one general uses the floating keyboard. Though it took quite a bit of troubleshooting to determine the cause. Hoping to save someone time in the future!------------------------------Mike Tamoush------------------------------
I have a table with a model year field that is a reference field in a relationship. It won't show up as available to use as a dynamic filter on reports. Any idea why not? There are only 21 model years (all unique).I have tried using a formula field to change the data type of the model year from number to text. No dice.I added another field that is a duplicate numerical field named model_year that is not a reference field nor is it part of any relationship. It won't show up either? I tried changing this field to a text field and it still didn't show up.The field is available to select as an x or y axis variable. I don't understand what the issue is.It doesn't appear to be because of a feature limitation:------------------------------Adam Keever------------------------------
I have tested out a 3rd party API call in POSTMAN successfully! The first step in POSTMAN was to authenticate as a POST and to generate an "Access Token". The second step in POSTMAN was to make a query as a POST using the "Access Token" and return a record of data. I'm having an issue on how to duplicate this process using Pipelines within QuickBase. I can use a Webhook to make the initial POST to authenticate and I see the returned "Access_Token" response in the activity report. However, I don't understand how I can pull in the "Access_Token" to the next step and make a query using the required "Access_Token". Can someone point me in the right direction direction???------------------------------Kevin Moore------------------------------
I'm looking for a methodology to take a CSV in pipelines and convert that to a raw text in order to put in the body of an API call. I have had no success passing the CSV (as binary) via QB URL so this is my next step. I'm essentially trying to submit a CSV with an API call but does not seem we can do that from a URL. If anyone has experience in doing this I would love to hear your tips/tricks!!------------------------------Greg G. ------------------------------
I need a simple Pipleline roadmap to build that will do a Table to Table import on a schedule.I had this built with Automations and it worked perfectly, but now that automations are going away, and I get Errors trying to do a migration, it has now stopped working properly which is now affecting daily business.Can someone please help and give me a simple roadmap to create a table to table import?I find Pipelines very frustrating, and any help is appreciated.------------------------------Les Kimbler------------------------------
I have data that is for the same company but is manually put in and is sometimes misspelled and not the same way it is entered. Is there a way for QB to look up the misspelled entries and autocorrect that field to be the correct spelling of the company and therefore match all the entries up to the one correct company? Can this be done with a formula? ------------------------------Amy Migliore------------------------------
Me and table to table relationships don't like each other. I have done this before but for some reason I'm stumped on this one. I have two QB apps. The matching field between the two are TAX ID. I have the table from the other app into my main app already set-up. I'm trying to set up the relationship but keep getting the wrong thing. The Parent table has the TAX id field and I can set it as the key field if needed. The child table also has a TAX id field that the user keys in the number. I want that child table to pull in other fields from the parent table when the two tax id fields match. How should that the relationship be set up? Thanks ------------------------------Carol Mcconnell------------------------------
Hello,I have a subscription that is set to send a Table report, however the actual email received displays a summary version of that report. Is there a way to force the email to send the actual table report and not a summary version of it?------------------------------Dan Park------------------------------
Hi, I'm using "Call Pipeline" and "Callable Pipeline" to log some Activities information into a QB table, to help me troubleshoot when needed. So, for each run I'm logging the URL of this run, Pipeline name ...etc Using some Jinja functions like {{Time.now}} {{a|count}} $prev ...etc I really need to also log if the step returned an error (Example attached) and if possible, to print that error. Any thoughts will be appreciated, Thanks! ------------------------------Adnan Mohamed------------------------------
Does anyone know if there are release notes or an explantion of the new option in multiple choices fields, 'user input'? I can't seem to figure out what the intention is, or how to use that option. It appears to simply change the MC field into a typical text field?------------------------------Mike Tamoush------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.