ContributionsMost RecentMost LikesSolutionsRe: Overnight Failure of ROUND and FLOOR Function... Anyone Else???Exactly... it has been a great test and prototype tool, and as our business changed, we adapted well. Now we are maturing and in time will use this as the basic framework. G ------------------------------ Glenn Phillips ------------------------------ Re: Overnight Failure of ROUND and FLOOR Function... Anyone Else??? Hi Mark, It has been a great tool, we just have more complexity than the platform supports. Really, we've used this as a functional prototype tool as we've figured out our unusual business model. We use this for back-office management of real estate transactions as a brokerage in 32 states, and for back-office management of a multi-state real estate title insurance company. I really didn't want to invest the time in the API-backend of QB, which I'm sure would do more of what we need. But I can see our future is bigger. So for an example, in the web UI version, freezing data points with SNAP has been good EXCEPT undoing them is not good. And we need to freeze lots of lookup data on each real estate contract that we can do admin override to correct if needed. I do a lot of odd things to pull data between forms to match multiple scenarios that is really hacked. In a SQL environment, it would just be some simple views and queries. We also will need far more digital document management and interaction between digital form data points and our software. And we need more interaction between our back-end system and our new website that is coming out soon. (You can see our current website at www.LakeHomes.com which attracted about 6 Million very active visitors last year). I'm not casual in my assessment. I love the tool for most of what we do. While I'm leadership now, my background is Computer Engineering and data system design and development (including Innovations Awards and case studies on our work from Harvard, Auburn Univ, Dell, etc.). I anticipate the next generation of our system will be a three to four programmers/data engineers for a year, even with a good framework. Appreciate the interest! G ------------------------------ Glenn Glenn ------------------------------ Re: Overnight Failure of ROUND and FLOOR Function... Anyone Else???Well, since it turned out to break other formulas dependent on the garbage, I think changing my code is much easier... chase the broken data. Much easier than if the return was a valid but wrong number! ------------------------------ Glenn Glenn ------------------------------ Re: Overnight Failure of ROUND and FLOOR Function... Anyone Else???Hi Mark, well, it may be that rounding is not supported that way, but it has worked for years for us as written, so something did change besides our code. In terms of panic, the trick is to find all the places we use this function so we check how it is written. It may not be many places, and we could go through all the formula fields one-by-one, but we may have 300 formula fields, and some are lengthy. I could likely do it in an hour I suppose, and probably should, but if it is a QB bug I just bugs me to spend the time. We have one table with a very complex form that really has outgrown what Quickbase will do, but we're updating it to buy time, as the replacement of it with a more robust software would be a very expensive project and take months to complete correctly. Appreciate you for looking into this and your observations!! G ------------------------------ Glenn Glenn ------------------------------ Re: Overnight Failure of ROUND and FLOOR Function... Anyone Else???Interesting... I did confirm FLOOR has same issue, gives the exact same wrong answer. I did not test CEIL but I bet it fails too. So, based on the info you provided, I found I can force by numeric percentage calculation from the error of.. Round(0.251, 0) = -1.#IND0000% (but should be 25%) to work IF I "game it" like this... Round(0.251 * 10, 0.01) / 10 = 25% So that confirms what you noticed Mark about the zero places. Thanks, that was helpful so now I'm pondering if I patch my formulas to keep us working until Monday or if someone will see this and the tickets over the weekend, even if it is the deployment team. The hard part of that is that I don't know an easy way to search all my formulas fields for a single specific function (does anyone know such a method?) As far as a cause, I wonder if they pushed a library out in advance of the code update coming? G ------------------------------ Glenn Glenn ------------------------------ Overnight Failure of ROUND and FLOOR Function... Anyone Else??? The ROUND and FLOOR functions no longer return valid numeric values. Last night (6pm Central Time US 2/5/2021) these were fine. This morning, Saturday 2/6/2021 at 8am they return numbers with alpha-characters in the them. I stripped my formula down to confirm that it is an issue with the QuickBase function and not my code. When my formula is only the number: .251 the result is correctly: 25.10000000% When I change the formula to: Round(.251,0) the result is incorrectly: -1.#IND0000% The problem is repeatable across multiple forms and fields. It breaks an important form we use 7 days a week. I submitted a ticket to QuickBase, but in the past they did not respond on weekends. Kinda puts us in a bind. Anyone else seeing this issue? Thanks, Glenn ------------------------------ Glenn Glenn ------------------------------ Re: Email notifications stopped workingSeems emails for password reset and add new users invitations are not firing either. G Re: Will support restore an app on a Sunday? I submitted a ticket this morning, but no response from a live person.Thanks! (I looked for the hours that support responds, can't find it anywhere. Guess that presents the appearance of more support than actually provided... which is probably great for marketing, and great for most users who don't work weekends who will never know.) GWill support restore an app on a Sunday? I submitted a ticket this morning, but no response from a live person.With no phone support, I am trying to determine if my ticket to have an app restored from backup will be addressed today (a Sunday)... or even if this takes more than a day in general.