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 table with a field for email address. I would like to remove the hyperlink, so it doesn't open a mail client when you click on it.I have tried to set the type as both email and text, but don't see anything in the settings.Is this possible?Thank you,-Rob------------------------------Rob Brown------------------------------
I need a code that color codes a range of dates. For example: +15 days through + 30 days should be yellow +2 days through + 14 days should be orange + 1 day though overdue should be red This is what I have to start with, but I don't know where to go from here: If([Approved End Date]=(Today()+Days(30)),"<div style=\"background-color:yellow;\">"&[Approved End Date]&"</div>",ToText([Approved End Date])) Any help would be greatly appreciated. Thank you!------------------------------Meagan McOlin------------------------------
When I initially connected my QB Connection table to a Google drive CVS file the source key field (text) was spelled: FMLS#. Today the source of the field in Google Drive changed the name to MLS#. My connection is still looking for the old spelling and not finding it so the connection is failing. I have tried to change the name of the key field in the QB connection table to MLS# but it is not making the connection to the Google drive field. I can't add the new field and change the key field to the new field because I have other tables relationships that used the FMLS# field has the key field. Any suggestions?------------------------------George Bramhall------------------------------
I have following if condition in a pipeline do loop. trying to determine when the search count is equal to 1.The below expression is not working.------------------------------George Romanowski------------------------------
Hello! I have a rich text field where the user can enter a marketing description. We are limited to 250 characters including spaces for this information. I have this field set up to accept a maximum of 250 characters.To help the user, I also have a field that counts the number of characters in the field.I'm running into an issue where any time the user enters non-English text, the character count is way off. For example, the German word "setzt" is counted as 149 characters. The Japanese word "ヘルプ" is counted as 146 characters. Is there something special I need to do with the formula to accurately count non-English characters?Thanks!------------------------------Karen Henke------------------------------
I have a table sync with a Yahoo account that has a tendency to fail unless I update the filter to not look back further than a week, depending on how many emails meet the criteria to bring in. Is there another approach I can take that would be more reliable and not involve as much babysitting? Can Pipelines take care of appending emails with specific criteria to my table? Any recommendations would be greatly appreciated. The aim is to bring in emails where the subject contains certain information and the sender is a specific email address.------------------------------James Carr------------------------------
Good morning, I feel like I always have an impossible task. Right now, we're using an excel spreadsheet, but would much rather utilize QuickBase.I have 2 tables created (tasks) and (meter reads). I need the following formulas that communicate with each task date, and source information. I have made a relationship between tasks and meter reads as well, but am struggling to figure out the formula to insert. There is 3 different formulas I need per meter reading that automatically calculates in it's own field. ------------------------------Newman, Savi------------------------------
I need to filter data which is the grid edit report and I'm unable to figure it out. Report has 1000+ records and also I need to edit multiple records at the same so looks like grid edit is a better option.------------------------------Mrunali Kadam------------------------------
Hello -I need different values to appear when adding a record, editing, and viewing. I know we can do this with multiple fields and form rules but I need an extra step for editing a record. When the user first edits a record one field would show (a summary field from another table), when they change a value on the form while editing I then need to show to a field that holds that summary value + the changed value. Would it be possible to do this using a single formula field?For example:Summary = 50, X = 10When adding a new record I would see 60When viewing the record I would see 50When editing the record I would, at first see 50If I change x from 10 to 15 I then want to see Summary + (abs(10-15)) = 551. Currently, when i edit and change the value from 10 to 15, this would show me 65. Is there a way to capture the difference between the original X value and the new value entered? 2. Is there a way to add a condition to a formula field to show different fields based on when the user is ad
I have a formula date field that is sometimes null and sometimes not. Lets call this [Date].I have a pipeline that attempts to update a field [Second Date]. The pipeline simply says, update [Second Date] with [Date].The problem I am having, is if [Date] is null, it does not update. It only updates if [Date] is NOT null, otherwise it skips it. I can't use {{CLEAR}} because I want the two date fields to match, so I don't ALWAYS want it to clear.Does anyone know if this is a bug or by design, or have a work around?------------------------------Mike Tamoush------------------------------
Hi,I am having an issue with updating an existing record. The key field is exactly the same but new downloads keep creating new records.------------------------------Fatima Khan------------------------------
I am using a formula to calculate "Total Contract Value" for our clients. This is what I have so far. The problem is, where the Invoice Duration field is null, my formulas are not calculating anything. The non-null Invoice duration parts of this formula are working. So I know it's in the IsNull section of my formulas. Invoice frequency is a Multiple Choice field, Invoice Duration is a numeric field. If invoice duration is blank, we want the formula to automatically assume ongoing invoices. This formula field will show us the total annual contract value of said invoice amounts.If([Invoice Frequency]="Monthly" and IsNull([Invoice Duration]), [Invoice Amount]*12,[Invoice Frequency]="Monthly" and not IsNull([Invoice Duration]), [Invoice Amount]*[Invoice Duration],[Invoice Frequency]="Quarterly" and IsNull([Invoice Duration]), [Invoice Amount]*4,[Invoice Frequency]="Quarterly" and not IsNull([Invoice Duration]), [Invoice Amount]*[Invoice Duration],[Invoice Frequency]="Annually" an
Hello team,I have a table called Products. Here, there is a column called Supplier-Product number which is formula field and I have made it unique according to the requirement.When I am bulk importing the records from spreadsheet, if there are any duplicate records those are getting rejected with an error message. However, the unique records from the spreadsheet are also not getting uploaded.Is there a way, to reject only duplicates and upload only unique records?Thanks & Regards,Aishwarya Jinde------------------------------Aishwarya Jinde------------------------------
I am working on a pipeline that will update a set of records when a separate record is updated. Use case, The user needs to create several records to perform the same task at multiple locations. A separate pipeline is created to create one master record for all of the child records. I need to update each of the child records when the master record is updated. This is where the complication comes into play. The update may involve 1 to 24 different categories, each with their own set of data to update. Should I use 1 step to update all 24 categories regardless of a change or add conditions for each category to only update if there is a change. This would result in 24 steps in each iteration of the Do loop. I am concerned about performance issues for a large update. If the master record has 500 effected records, the Do loop would effectively run 12000 steps. I welcome your suggestions.------------------------------Paul Peterson--------
If i make it so a specific field is not editable by anyone, even admin - will a pipeline that modifies that field work (supposing the pipeline belongs to an admin)?I have a pipeline that populates a satellite app with data from a master app. I don't want even admin accidentally grid editing the satellite app data, so id like to make it read only, but am not sure if the pipeline will still work?(I realize this is better suited to be a sync table, but for now it is too difficult to change the satellite table into a sync table)------------------------------Mike Tamoush------------------------------
Is there any native way (I'm thinking using Pipelines?) to bulk upload files and attach to records. Not sure how this would work, as I need to somehow associate each file to a record ID...One thought I had, perhaps there is a way to bulk upload files and have them each be created in a new record? if I could do that, I also have some ideas of how I could make things work.------------------------------Mike Tamoush------------------------------
As a marketing / feature end of life story by Brian Cafferelli from 12-21-2020 it stated that "We are also exploring improvements to the collapsible groups in the new table reports, so you can collapse all groups while still seeing the subtotals. That is a change we're considering making as a fast-follow after new table reports become the default in Spring 2021."At this time when you collapse the group the subtotals still disappear. Is there a way to activate this feature, or is it not live yet?------------------------------Brian Hunot------------------------------
Is there a way to open a specific form from an existing form without using the API_GenAddRecordForm API?For example, I'm using form #10, but I created a clone form #11 that's more printer friendly and removed some fields. I then added a formula button on form 10 to print form 11. I'm wondering if there's a way to do this without using that addrecordform API since I'm not adding a new record. You'll see in my formula I'm referencing the form to open, but the button is simply opening the existing form: "<a class=\"OpenAsPopup\" data-height=900 data-width=900 href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] // PO Record ID & "&dfid=11" // Printable form ID & "&z=" & Rurl() // Redirect & "&apptoken=<"/MY APP TOKEN"/>" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'><img src=\"https://images.quickbase.com/si/24/058-printe
Hello,I have 4 tables. Lets say the tables are A, B, C, and D.The relationships are current set up A->B->C->D each with different key fieldsOn my C->D relationship Table D is already populated with data and the Key field in C has already been connected via one to many relationship with D. However Table D does not seem to be working with this relationship. The related field is there but the existing data is not taking on the relationship even thought the key field of C and the related field of D are exactly the same. It is only allowing be to create a new record under D which gives option in the reference field to relate back to C. How do I ensure Quickbase works with D's existing data?I hope all this makes sense lol!I figure it out thank you ! Not sure how to delete so just editingBest,Noel------------------------------NOEL HODGES------------------------------
I'm interested in an AverageValues() function similar to SumValues() for use with GetRecords() where the value type of the field is 'Time of Day'. Since there is an Average function that accepts Time of Day values, I'd like to be able to feed it the list of values returned from GetRecords() to calculate the average. If there is another way to perform this, please let me know.Thanks,------------------------------Joseph Gomez------------------------------
Hi...I am a mid level QB however, I am still trying to get comfortable with customized reports. I need to add a turnaround report to the dashboard. I have the formula but I am not sure how to go about this??(Number of separation /(total month FTE+Contractors))* 100So the separation would be based on [status] "Inactive" on [termed date] of the current month.The total month would be based on the total employees on [status] "active".How do I do this as far as formula wise? Report Formula or Report Formula?------------------------------Holly Cathcart------------------------------
I'm sure there is an easy answer...I have created a new record in [JOBS] table. I would like for the record (appropriate look-up fields) to automatically be added to [MASTER JOB BUDGETS] table. I know how to do this manually, but is there a way for it to automatically happen?------------------------------BuildPro------------------------------
Hi - seems like the community login auto logs in my company's login instead of mine. How do I change login to mine?Thanks,Holly------------------------------CMS ITOperations------------------------------
We have a lot of restrooms in our parks. I have created a simple system that allows anyone (everyone on the internet) to scan a QR in whichever restroom they are in, and it automatically takes them to a record creation page for that specific restroom, allowing them to report problems like water leaks etc. that we may not have noticed yet.I have two tables. "Restroom list", a master list with a record for each restroom, and "reported restroom issues", which is a repository for all submitted restroom issues (by whoever scans the QR in any restroom and fills out the form, which creates a record in this table). The table, "restroom list" is connected to the table, "reported restroom issues" via a one-to-many relationship. One of the fields in the "reported restroom issues" table is "Park".When a record is added to the "reported restroom issues" table, I would like to have an email automatically sent to the manager of the park in which the restroom issue record was reported. The only f
I have an Employee Table, and a Documents Table.I need to be able to upload 1 document, and have it automatically display on each employee's "page" I have two tabs.Employee Information - Essential DocumentsI want to be able to upload a document and it automatically go under each employee's "essential documents" tab.SOS!------------------------------Newman, Savi------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.