Help with ""Contains"" formula
Hi, I am trying to create a formula that indicates the following: IF [field 1- text multiple choice] contains "GM" AND [field 2 - text] contains "GM", display text "GM Opp/GM Agency" IF [field 1- text multiple choice] contains "AA" AND [field 2 - text] contains "GM", display text "AA Opp/GM Agency" IF [field 1- text multiple choice] contains "AA" AND [field 2 - text] contains "AA", display text "AA Opp/AA Agency" I think that the AND portion if the formula is messing me up, but can't figure out how to fix. Below is the current formula I'm working with: If( (Contains([GM/AA Market - Opp],"GM" AND Contains([Agency/Client Market - Consolidated], "GM"), "GM Opp/Agency", (Contains([GM/AA Market - Opp], "AA") AND Contains([Agency/Client Market - Consolidated],"GM"), "GM Opp/AA Agency", (Contains([GM/AA Market - Opp], "AA"), AND Contains([Agency/Client Market - Consolidated],"AA"), "AA Opp/Agency", "NA")) Thank you!
Nested If Formula Error: Expecting Boolean but found number
Hey everybody! Can someone help me with the below formula? I get the "expecting Boolean but found number" error at the end of the FIRST If statement. If i change it to NULL, then the 2nd IF statement turns yellow saying it expects a different outcome as well. :( What this formula says is: TO Service Mgmt is the only Cost Center who can check the checkbox to override a field called "REG" (where the formula below lives). The REG formula defines if the employee worked 8 hours that day or not. The TO Service Mgmt Cost Center can work Sat/Sun and the rest of the CC's are Mon - Fri shifts, therefore, Sat & Sun should = 0. If( [Cost Center Name] = "TO Service Mgmt" and [REG Override] = true, 8 - Sum([FHL Form],[PTO Form],[JRY Form],[SCK Form],[Time without Pay Form],[Unscheduled PTO Form],[FNL Form],[FMLA Form],[HOL Hours],[Other Form]), 0, [Cost Center Name] <> "TO Service Mgmt" and [REG Override] = false and ([Day of Week] = "Sat" or [Day of Week] = "Sun"), 0, Sum([FHL Form],[PTO Form],[JRY Form],[SCK Form],[Time without Pay Form],[Unscheduled PTO Form],[FNL Form],[FMLA Form],[HOL Hours],[Other Form]) > = 8, 0, 8 - Sum([FHL Form],[PTO Form],[JRY Form],[SCK Form],[Time without Pay Form],[Unscheduled PTO Form],[FNL Form],[FMLA Form],[HOL Hours],[Other Form]) ) When i comment out the 1st IF statement, the formula works, but i think i STILL have something wrong with the formula b/c it automatically checks the REG Override box for all Days of Week for Mon - Fri for TO Service Mgmt Cost Center and none are checked for NON TO Service Mgmt Cost Center (which is an expected behavior). The expected behavior is for the person to check the box to override the REG value if they work random days throughout the week. With that said, the box should always be unchecked unless specifically checked. Hopefully that makes sense. Thank you in advance!!
Error - Invalid record data provided when executing form rules
Hello, I was getting this error when selecting a name from a lookup field on my form. I am now getting this error when i check a checkbox. I don't have any conflicts with my rules and I have not been able to find any information on this error. Is there anyone that can help me?
Error : Object Reference Not Set to Instance of an Object
I have run into this error a number of times. When I am trying to import an Excel file into QB, I receive this error. Object Reference Not Set to Instance of an Object I am referencing an Excel file that has been saved and in the correct file path that I provided to Quickbase. This problem seems to occur in files that I am importing that are small, so my solution to this has been to include irrelevant data in the Excel file and then leave the data out of the import. Any ideas why this would be happening and does anyone have a more elegant solution to solving this problem?Automation Error - 500 Internal QuickBase error
I created Automation which should do following: 1) When Table record "Completion" (checkbox) change and is equal to the value Checked 2) Modify same record in field "Completion date" to capture today date. Sometime it works and sometime not no rule. This time failed when in Grid Edit I Ticket to Complete above 10 records. When it fail no error capture in Automation Box in column ERROR COUNT LAST 7 DAYS bu I receive mail with error: "500 Error: Internal QuickBase error" After it happen, automation does not work those records anymore but for other yes. I faced it while marking above 10 records as complete but it is not even close to QB limitation. Any tip to investigate?How to limit a field ""Phone Number"" to only contain 10 digits?
I have a field "Phone Number", I need the user to enter 10 digit phone number in the field. If the user enters digits less than or more than 10, it should display an error message. Is this possible using native functionality or needs some custom coding? I tried using Phone filed data type but it accepts any number of digits in the field. Any suggestions?
FilePath URL not navigating via click
I feel like I'm missing something obvious here. The URL type field seems to be intended to provide clickable URLs to both sites (http://) and local file folders (C:/users/etc.). I can get it to work for sites but I cannot get a filepath to be clickable. If I copy and paste the filepath from the QuickBase record into the browser address bar it navigates just fine. But I can't click it. Can anybody tell me what I'm doing wrong here? Thanks!Unique Values
I have two tables with a relationship. Table A provides the unique value of Tree_GPS_Coordinates to Table B. Table B uses the lookup value of Tree_GPS_Coordinates and collect data for fields Year and Height. Goal: I want to prevent any duplicate entries for trees in a given year. (e.g. Tree1 cannot have two 2017 measurements) Problem: Year field cannot be marked as unique because many trees will be marked as 2017, 2016, 2015 etc. Tree_GPS_Coordinates is a lookup field. Question: How do I create field formula to ensure there are not duplicate entries? I continually receive the message "This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.
Rich Text Formula Button which saves record and opens new window
I am trying to create a rich text formula which will save the record and continue working so i stay on the form but at the same time opens a new window with a specific form inside of it. This app is basically a medical records app and the button pops open the patients health history. The formula works great if the record is already saved, but when they are adding a new record and i try to utilize it the new pop up window comes back as nothing there. I know this is because the record id doesnt exist yet, which is why i added in the "save and keep working" functionality. I believe the issue is my URL variable is at the top, so when the action runs, it's populating the URL for the popup window before the record actually saves. I can't figure out how to grab the record id AFTER the record saves. here is my current formula, any assistance would be so great! i've been working at this for 10+ hours and just cant seem to figure out a solution. var text URLone=URLRoot() & "db/" & Dbid() & "?a=dr&dfid=11&rid=" & [Record ID#]&"&ifv=10"; "<a class='Vibrant Success' & onclick=\"$('#footerSaveAndKeepWorkingMenuOption').click();var a=window.open('"&$URLOne&"', 'newwindow', 'width=400,height=800');\" >Patient Health History</a>" thanks so much!Find and append new unique values to secondary table
I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table within the app. The key field in the secondary table matches one of the fields in my daily upload. I have set up a QB action that should identify new unique values in the field related to the secondary table's key and copy these records. But I am running into a problem. Sometimes my upload will include several rows with the same value in the field that I want to use to populate the secondary table's key field . When this happens, my action is registering an error. I only need the value in one of the duplicate lines to write to the secondary table, but I need to preserve all of the lines in the primary table. Any suggestions?
