Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am creating a new form UI and am now to the form rules. I have a rule that basically says " if [field] is not blank, change date to today". However, the date field is not even an option in the list to choose from in the 'Then' section. I am using 'Change value' as a choice. I certainly hope I don't have to create a bunch of pipelines to populate date fields as we have a lot of them for approvals, returns, etc. With the new form UI, how we can auto populate a date field...or maybe any other field?------------------------------Amy Gosz------------------------------
Hello, I have a check box that I need to automatically be checked if the value of the request is >2500 and <15000. I had this worked out fine with the formula: Case([Total]>2500,([Total]<5000),true,false,) However, I have been asked to add a third parameter....if the user is a particular person, their thresholds are different...I'm trying this formula below. However, the issue I'm running into is that, the box is being checked even if it is below 2500. Case([DOC]="Sean Regan",[Total]>2500,([Total]<5000),true,false,Case([DOC]="Grafton Montgomery",[Total]>2500,([Total]<5000),true,false,Case([DOC]="Jeron Pearson",[Total]>2500,([Total]<15000),true,false,Case([DOC]="Jared Bernshausen/Brian Oesch",[Total]>2500,([Total]<15000),true,false,Case([DOC]="Jay McClain",[Total]>2500,([Total]<15000),true,false))))) Please help!! Brandy ------------------------------Brandy Nunes------------------------------
Hi I am watching David Drockton Empower 2023 Pipelines: Performance Case Study. I am trying to import the YAML files and associate with a Channel, Channel ID & Account slug. I have a token that is connected to the Empower 2023: Pipelines Performance App, but not finding how to get the Channel ID & Account slug setup. I do have other Apps in my Builder Account with IDs & Slugs.------------------------------Bob T.------------------------------
Hi, I am trying to sum up values from one table to another but the formula is returning 0. I am confident that my formula is correct but I don't know if there is something wrong in the backend. //Variables var number PoOpenValues = SumValues(GetRecords("{106.CT.'Saguaro'}",[_DBID_PO]),113); //Formula If([SYSTEM: Break Query] = false,$PoOpenValues) I have a break query field that only runs the formula if the checkbox is false to save performance and I have a pipeline to capture a snapshot of this sum in another Value field. FID-106 is a text field called Program Name and FID-113 is formula-numeric called Open PO Extended Cost. The foreign table has about 25,000 records and I am not sure if the size is an issue. Here is an example of the values I have in the PO table. ------------------------------Christopher Mata------------------------------
Anyone found it annoying that using different fields in a row in the new forms doesn't align well - particularly regarding the checkboxes? I have a form which has three fields in a row. Left field - is for data entry and needs a label Middle field produces a warning message depending on the data entered - doesn't need a label Right field is a checkbox, which needs a label This is how it shows up, which looks funny. For the middle field, I could select Custom label and type a space so that it would align better with the left field, but I can't do anything about the checkbox field. I have several rows of data entry, which makes the offset checkbox for not applicable is hard to tell which line it applies to. I have put this in the QB feedback. I'm sharing here to ask if anyone has a better workaround, and to get you to like my feedback request. You'll find it under the heading "New forms - fix alignment for checkboxes with other fields" This seems like a prett
Hi All, Has anyone ran into the issue were the form rules will not hide or show the tabs. I have a standard user group, and administrative group. When I set permission to if The user is not administrator hide the admin tab. The user is still able to view the admin tab. ------------------------------Willis Taylor------------------------------
Hi everyone, I've had a play around with the new forms, and there's a few things I'm not keen on. I've found a couple of bugs where rules just won't let you edit them, you have to delete the rule and start again, but that's another story. I have a number of forms with rules that prevent a person from saving a record unless certain other conditions are met. With the new forms, they do look better, and a bit of optomisation to speed them up aside, I think they have a lot of potential. But they are lacking a few features from the legacy forms rules. Does anyone know if there are workarounds? I'd rather avoid adding more and more pipelines as we already have quite a few of those at the moment. But I would be willing to try if that's the only option with the new forms. Specifically at the moment, I need a way to prevent a form being saved and to bring up a popup message when certain conditions are/aren't met. Alternatively, if anyone is aware if those rules are due to be added to the new
I am using the new form designer and am trying to set a date field when a check box is selected and then use that date as a time stamp for the action so that it isn't overwritten the next time someone looks at the record. The problem is that my date field is not in the list of fields available for the change value action. I am able to create this rule correctly using the old form designer. ------------------------------Janet Walz------------------------------
In the new form, when I add a child record from a link on the parent record and then save the child record it redirects me back to the parent table in an "add new record" mode instead of back to the original parent record I was working on. This is causing duplicate records to be made because the user thinks the initial parent record wasn't saved. If I save the parent record before clicking on the add new child record button then it redirects back to the parent record I was working on just fine, but if that save doesn't happen before clicking the add child record button first then it will take us back to add new record to parent table. Anyone know of a fix for this?------------------------------Amber Goodman------------------------------
Hello, I am trying to have a user type in their email address in a form on Orientation, and depending if their email exist in another table called people, have the lookup field picker only show their information. Right now, I can't figure out how to limit the email lookup field to only their information. Any help? Thanks------------------------------Sean White------------------------------
I have a database setup for multiple projects. Notifications have been setup and works if I configure "Notify whom" to use the names in the field "Project Users (Field type List-Users). The problem with this is I can only include emails with an internal account, whereas I also need to include external emails. I don't want to have to create accounts for every email address who would have no need to access the database.Is there a way I can configure a new field somehow where I can manually enter the email addresses(including distribution list emails) I want to send to for each project and use that field for the "Notify whom"?I know I can request to set permission type to Open to allow external email addresses, but this also means every projects emails goes to one list of people rather than project specific. As there will be hundreds of projects, I don't want to have to duplicate a notification template hundreds of times with a condition on when it is triggered specific to a project ID.
HiI am aiming to calculate the total amount of working days between two dates whilst also considering Weekends, Bank holidays and Christmas Holiday etc.I have created a calendar for the next 5 years which puts a 1 next to the days that are actual working days. Within this table the desired result is achieved by simply filtering the start and end date and it totals up the working days, however I need this result to appear as a result of a start and end date on another table.Any help appreciated.After I have achieved this I will also need to calculate the end date based on a start date and adding a number of working days, which again needs to consider Weekends, Bank holidays and Christmas Holiday etc.Thank you in anticiption.------------------------------Stu------------------------------
Is there a way to clear a table (no relationships) and reset the record id counter? When testing it is possible to use up many Record#s. It would be good when testing is done to be able to clear the table and reset the Record ID counter.------------------------------Scott ShimerSouthwest Airlines------------------------------
Scenario/Context/Setup: Parent Table: "Main Roster" Key Field: Network ID Child Table: "Anaplan Roster" New file imported each week (does not override the previous) How do I get it so that each week when the Anaplan Roster file is imported (child), it will automatically associate itself to the correct Main Roster record with the same Network ID (parent)? Essentially, over time, I should be able to view multiple Anaplan Roster records under each associated Main Roster entry... and each week identify individuals missing in the Anaplan reports because they're in the Main Roster but not in Anaplan and/or identify any individuals who are incorrectly assigned to teams in Anaplan (thus have a running log for changes throughout the year). Currently, I can't figure out how to get child to find its parent record automatically... it's requiring me to manually associate each Anaplan record to its parent record (even with grid edit, it's takes too much time as there are hundreds
I'm having an issue with a Rich text formula field pulling a Combined Text Field correctly. Any time there is only one item in the combined field it doesn't pull over to my formula. Here is the formula for the "Contracts" Rich text field: If([Budget Classification]="2- Contractual", "<span style='font-weight:bold'>"&(ToText([BVA Project])&"<hr></span> \n <td " &(ToText([Combined Text Contract Document Title]))) &"<td>\n\n <td "&[Combined Text Organization/PO]&"</td>\n\n <td "&[PO #]&"</td>\n\n <td "&[Combined Text Contract Balance]&"</td>\n", [Expense Code])------------------------------Bethany Hudson------------------------------
Good morning, I've set up an email notification to send when my "TR1 Send Reminder Today" checkbox is checked. Here are my fields: TR1 Send Reminder Today formula checkbox: If(=Today(), true, false) TR1 Reminder date formula date: WeekdayAdd(, -3) TR1 Reminder Email Sent On Date/time The TR1 reminder date is set to 3 business days before the TR1 Site Survey Date. Once the TR1 reminder date is "Today", the TR1 Send Reminder Today checkbox gets checked. This change to the record should fire off the email and trigger my pipeline to populate the TR1 Reminder Email Sent On Date/time. I had thought that it would fire just after midnight, as soon as the checkbox was checked, but it didn't. This morning, the checkbox was checked, but the email didn't send. The pipeline didn't fire either. This morning, I blanked out the TR1 Site Survey date, saved the record, re-input the date and saved the record. This fired the email and the pipeline. I guess my question is, is the change of
I need to create "something" (report, table, any available ideas?) that will capture the data from 6 fields on the 1st of the month, every month. It needs to stay in QB as something that can be referenced anytime. How can I do that?I don't have access to create pipelines.------------------------------Renee Hansen------------------------------
Hello! I'm making a bar chart and grouping like objects with a report formula. For example, all store types that contain the word "New," I want them to just be called "New." We have New-A, New-K, New 5.1, etc. I have created the summary formula, so the series does work. However, the report gives the "New" doors an automatic color that I can't seem to easily change. Does anyone know how to do choose the color or even know if it's possible?Thank you!------------------------------Amber Gartner------------------------------
Hi All, I am currently working on a chart to show how many Rotators a Physician has each month. I have a table that tracks the name of the rotator, 5 separate fields for physicians (rotators are paired with 5 different physicians) (the fields are : physician 1 physician 2, etc), start date, end date, month,and year. Does anyone have any tips on how to chart the number of rotators seen by a physician per month. I have the # of observers as my Y-Axis, however, I cannot track all the physicans on the X-Axis since I have 5 fields for this. The only way I can think to fix this is by getting rid of 4 physician fields, and creating a new rotator entry for each physician; however, that would skew the data of the number of observers. Any help is appreciated. Thank you!
Weird, but last week I had a twilio pipeline working with the Twilio Channel all set up, was sending and receiving. Since I want to say Thursday 6/15/23, Twilio keeps throwing 404 errors at me for sending messages to the same pipeline. The pipeline URL hasn't changed, the pipeline does not register any activity, all the while twilio throwing 404 Conifrmed with a manual webhook twilio is sending the message, so I feel this is on the quickbase side, specifically with the "Message Received" handler of the Twilio pipelines channel. but like I said the "Send a mesage" handler is working fine. Has anyone been using this twilio connector encountered any recent issues? Or any ideas to get me back on track? tytytyty------------------------------Jamie Gray------------------------------
I created a new KPI block on the dashboard against a gauge chart for the average against a formula number field. On the gauge it shows a huge number of decimal, and that is brought over to the dashboard even though I have it set to only one decimal place. Any idea how I can fix this so it just shows to the nearest whole number?------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com------------------------------
I have been working on this for days and think I have officially lost my mind. I must be overthinking this. Any help is greatly appreciated! I would like to combine (add the totals) for quarters that I have grouped using this formula: If(Month([Monthly stat])<=3,"Q1",Month([Monthly stat])<=6,"Q2",Month([Monthly stat])<=9,"Q3",Month([Monthly stat])<=12,"Q4","") I want to add up Q1 + Q2, then display that total. Then add Q1, Q2, and Q3 to display that total, and so on. I want to be able to compare each quarter of the current year to previous years' quarter totals. Sort of like "At this time in 2020 or 2018 etc, our total payments received were ... $00000. So basically a running total for the current year where I can filter it to display whatever I need for this year, and a way to compare previous years to it. Does this make sense? ------------------------------Kelly Lyons------------------------------
Hi all, My department wants to track all categories and the level they were assigned to. Both categories and levels are drop down fields. There are 9 categories to choose from and 4 different levels. However, they only want to track level 0, if level 0 had 12 or more assigned in the category. Track level 1 if it had 6 or more assigned, Track level 2 if it had 3 or more. Track all for level 3 and 4. And they only want a rolling 3 month period. How do I create this? Example: Category 1 was assigned level 0 - 9 times (do not count) Category 1 was assigned level 1 - 7 times (count) Category 2 was assigned level 0 - 15 times (count) Thank you for all your help, Sandralee ------------------------------Sandralee Oster------------------------------
Hi Everyone, I have a formula I am trying to find but I'm losing hope. I need to remove a decimal in a string of numbers and reformat in a specific way. Regardless of the original length, I need to reduce the numbers to a total of 9. The first four are whole numbers and the last 5 are decimals. The desired out-come: 2.18 = 000218000 46.71428571 = 004671428 163.5 = 016350000 10.9 = 001090000 I currently have a team manually updating 812 records which is not efficient at all. There has got to be a better way, I just can't figure it out. Again, I'm not sure automating via a formula is possible but wanted to pick everyone's respective brains. ------------------------------Jamie Strauss------------------------------
Hi all, Can I save the table alias in a field and then use that value in a formula? Example is a field in the table that identifies another table where I will lookup a value. This works, the table alias is _DBID_UTILITY_MATRIX GetRecords("{query}", [_DBID_UTILITY_MATRIX]) This doesnt work GetRecords("{query}", [Calc Table Name]) Where [Calc Table Name] is a text field with value = [_DBID_UTILITY_MATRIX] Either [_DBID_UTILITY_MATRIX] or "_DBID_UTILITY_MATRIX" Any ideas? My fallback is to create a series of case statements with the alias hardcoded like this Case([Calc Table Name],"table 1",GetRecords("{query}", [_table_1], "table 2",GetRecords("{query}", [_table_2], "table 2",GetRecords("{query}", [_table_2]) Gerry ------------------------------Gerry Munroe------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.