Forum Discussion
_anomDiebolt_
9 years agoQrew Elite
NEW ASK
I want your most complex formulas for testing my parser. I don't need any field values or other information just the raw formula as pasted into the textarea of the field editor page. Feel free to include formula variables, comments, poor formatting or even a formula that does not work.
You can enter your formulas here:
https://haversineconsulting.quickbase.com/db/bmn6xsqv2?a=nwr
Please only contribute formulas that are not confidential as at times others may view the submissions and I will be using them for testing with other developers.
I have added all the formulas listed in QuickBase's formula reference table but these formulas are rather simple. When entering your contributed formuls please selected the option "Contributed" for the Source field.
As this project progresses I will provide a script to extract all formulas from an application or perhaps even an account if you want to contribute to my testing efforts on a larger scale.
Thanks in advance.
I want your most complex formulas for testing my parser. I don't need any field values or other information just the raw formula as pasted into the textarea of the field editor page. Feel free to include formula variables, comments, poor formatting or even a formula that does not work.
You can enter your formulas here:
https://haversineconsulting.quickbase.com/db/bmn6xsqv2?a=nwr
Please only contribute formulas that are not confidential as at times others may view the submissions and I will be using them for testing with other developers.
I have added all the formulas listed in QuickBase's formula reference table but these formulas are rather simple. When entering your contributed formuls please selected the option "Contributed" for the Source field.
As this project progresses I will provide a script to extract all formulas from an application or perhaps even an account if you want to contribute to my testing efforts on a larger scale.
Thanks in advance.
_anomDiebolt_
9 years agoQrew Elite
FWIW, my parser now works on all the examples in the formula function table
https://login.quickbase.com/db/6ewwzuuj?a=td
I only had two small errors dealing with unary operators and numbers starting with a leading period which were quickly corrected.
On the other hand I found at least four typos in QuickBase's documentation:
Nz([Mon]) + Nz([Tues] + Nz([Wed]) + Nz([Thurs]) + Nz([Fri])
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=p
To WeekdayN([Order Date])
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=e3
Nz([Length of Project], [Estimated Length of Project]
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fa
Month(ToDate("Jan 10, 2000")
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=9
Can you spot the errors?
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784
https://login.quickbase.com/db/6ewwzuuj?a=td
I only had two small errors dealing with unary operators and numbers starting with a leading period which were quickly corrected.
On the other hand I found at least four typos in QuickBase's documentation:
Nz([Mon]) + Nz([Tues] + Nz([Wed]) + Nz([Thurs]) + Nz([Fri])
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=p
To WeekdayN([Order Date])
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=e3
Nz([Length of Project], [Estimated Length of Project]
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fa
Month(ToDate("Jan 10, 2000")
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=9
Can you spot the errors?
ASK: Please Give Me Your Formulas
https://community.quickbase.com/quickbase/topics/formula-parser-in-javascript#reply_18555784