Formula Parser In JavaScript
THERE IS AN ASK OF YOU AT THE BOTTOM OF THIS POST - SKIP THE DETAILS IF YOU DON'T UNDERSTAND MY TECHNICAL RATIONALE As some of you may be aware I am deep into creating a QuickBase Formula Parer in ...
Forum Discussion
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.
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