Forum Discussion
... you may need some one on one consulting. I can't real'y debug a huge formula like that without access to the app.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Rebecca Knecht, MS ACSM-CEP
Life Scan Wellness Centers
Clinical Director
410-707-4726
Www.lifescanwellness.com
- DonLarson6 months agoQrew Commander
Rebecca,
That is a nice sized formula. I suggest breaking up your development into pieces and then stringing them together. It helps me read and debug. Also since you have large formulas, I would recommend downloading Visual Studio Code and the Quickbase extension. It is so easy to make a simple mistake and need to roll back to the prior formula that works. You cannot do that unless you put your work into a source control system. I use GitHub. It is cheap and easy.
I took your example and made a sample which you can find here:
https://github.com/mcfindustries/Magic/blob/master/Community/LifeScanSample.quickbase
I can confirm that this works as a stand alone. If you have another error in the larger field, debug unrelated to the PHQ Follow Up is needed.
------------------------------
Don Larson
------------------------------ - DonLarson6 months agoQrew Commander
Rebecca,
One more thought. Create a new Formula Rich Text field in the table, and use the code from GitHub to test the functionality.
------------------------------
Don Larson
------------------------------ - RebeccaKnecht__6 months agoQrew MemberI only added that one section unoriginal ally posted. The rest of the formula was already there and working. So it just need to bogies out why the one part is having a syntax error.
Rebecca Knecht, MS ACSM-CEP
Life Scan Wellness Centers
Clinical Director
410-707-4726
Www.lifescanwellness.com - MarkShnier__You6 months agoQrew Champion
Rebecca, if you email me directly to the email in my signature line I will get on a zoom call with you.
Mark
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - DonLarson6 months agoQrew Commander
Rebecca,
To trouble shoot:
- Remove the new code from the original formula and save it. Does the prior functionality come back? If it does not then you need a deep dive into that field as something other than your addition has changed.
- Create a new field and only put in the logic for PHQ Follow Up. If this works as a stand alone then you have it correct. Your issue is to surgically insert it into the existing field with correctly placed & and commas.
------------------------------
Don Larson
------------------------------ - RebeccaKnecht__6 months agoQrew Member
The original huge formula works perfect alone. I did end up figuring it out. I should have been linking the hyperlink from elsewhere in the form rather then trying to add it directly.
------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------