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?50Views0likes5CommentsCalculate total number of days between today and [Date in Pipeline] excluding weekends.
Hello! I need help on this. Calculate total number of days between Today and [Date in Pipeline] excluding weekends. I have the below formula, but I get an error message saying "Expecting text/datetime/workdate but found date" WeekdaySub (Today(),ToDate([Date in Pipeline]))9Views1like7CommentsHow 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?7Views1like9CommentsFilePath 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!7Views1like7CommentsHelp 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!7Views1like6CommentsNested 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 forTO Service Mgmt Cost Center and none are checked for NONTO 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!!6Views1like11CommentsUsing the equals(=) operator when referencing a date to a number in an IF statement
I am looking to create a numeric formula field in a table. I am looking to define a specific number based on the date in a field called "Period Tested". For example: If Period Tested = 01-01-2016, display the number "1" If Period Tested = 02-01-2016, display the number "4" etc. I've written it out as such: If([Period Tested]="01-01-2016",1, [Period Tested]="02-01-2016",4) I am using theFormula - Numbertype for the field. I get the following error when I try to save: The expression [Period Tested] on the left hand side of the operator "=" is of type date while the expression "01-01-2016" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions. I'm not sure how to circumvent that in the system exactly, but I need the final number to show based on the date from the Period Tested field. Any idea how I can work around this? I looked a bit and didn't find any operator that could replace the equals(=) in this scenario. Thanks for your time!6Views1like4CommentsCan 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?5Views1like19CommentsqdbEF error, an application token must be supplied. HELP!
I am not a programer. It seems everytime I go to try using this applcation, I run into programming issues. Now I am trying to pull my old Exact Froms up in MS Word (2016 version) and I get this programming error:qdbEF error, an application token must be supplied. HELP! All I want is access to my Exact forms already built and in the system.5Views0likes1Comment