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!
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?
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!!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?
Can I set my form to ""Save & Keep Going"" based on a time interval of some sort?
I realize this probably can't be done natively within Quickbase, but does anyone have any ideas on how to work this functionality into a form? My particular use case calls for my users to fill out a form, and often times this form may take over an hour to fill out. Unfortunately, QuickBase's page token error only allows a form to be open for 60 minutes so I am trying to find a way around this. I have tried running an auto-refresh script in the browser, but none of the information that has been previously entered into the form is saved when the browser refreshed. I assume the only way around this is to get the form to save automatically with some form of CRON. Thoughts?
Another jQuery help request...back to basics..
I could use some help with a simple looping script I have been attempting to put together for the last two weeks with no success. The purpose of the script is to easily add a range (large range) of phone numbers to our quickbase database without the need of csv importing or repeatedly using "Copy+Paste Special" in data entry mode. I have been learning Javascript as I go, depending on the project I am assigned/asked to do. Originally I had a JS function in the IOL file that I was attempting to call from a Formula URL button, but with no luck. It went something like this : function addTNRange(start,end,prod,loc){ // Error checking here // for loop to add a record for every TN in the given range alert("Range added.") }; I have tried both the basic IOL method and getScript. Is this the right approach? Is there a better method for what I'm attempting to do?
Is there a timeout limit for ""&z="" & Rurl() ?
I successfully use API_GenAddRecord to create records in a child table, and preset some values. The user then selects choices from drop down menus and when the record is saved they are returned to where they came from in the Parent record because I'm using &z=" & Rurl() at the end of my formula. This works as expected except I have recently come across an occassional issue where the user is NOT returned to the Parent record upon save, they are returned to the View mode of the saved form in the Child table. This only happens when the user has remained on the Child record for a long period of time (30+ minutes) before saving. It appears that there is some sort of time limit where the &z=" & Rurl() no longer is recognized and therefore the redirect back to the parent does not happen. I'm interested to see if there is a reason for this and is there a specific time limit after which the formula won't recognize that there was a &z=" & Rurl() that needed to fire after save? Wondering if anyone else has come across this unique problem before!
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?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?
