formula url not completing code

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a complex formula url button that appears to work when all of the conditional statements are met, but when it comes to a condition that is not met, it doesn't go through the rest of the code.  Below is the end of the formula... so, for example, if [UpdateLCs] = no, then I get an error saying that QuickBase cannot understand the url... tasks one - nine are added, but it never makes it to the point of $DisplayParent to direct me back to the parent record.  Is there a way around this?


$EditRecord

& "&rdr=" & URLEncode($AddTaskONE)

& URLEncode("&rdr=" & URLEncode (If([UpdateStatements]= "yes", $AddTaskTWO)))

& URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateStatements]= "yes", $AddTaskTHREE))))

& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateStatements]= "yes", $AddTaskFOUR)))))

& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateEstmts]= "yes", $AddTaskFIVE))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateEstmts]= "yes", $AddTaskSIX)))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateNotices]= "yes", $AddTaskSEVEN))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateNotices]= "yes", $AddTaskEIGHT)))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateNotices]= "yes", $AddTaskNINE))))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateLCs]= "yes", $AddTaskTEN)))))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateLCs]= "yes", $AddTaskELEVEN))))))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode(If([UpdateLCs]= "yes", $AddTaskTWELVE)))))))))))))

& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($DisplayParent))))))))))))

Photo of Jennifer

Jennifer

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
I do not know an elegant answer, though there certainly may be one.  An expedient work around may be to make a formula variable to edit the record and set a dummy checkbox to be true.  Then for each of your IF statements, when they are not true, instead if being silent, instead edit that checkbox to be true.  That way it will be a valid URL.  The dummy checkbox will be needlessly edited to be true many times, but who cares if it works.

I have not tested that theory, let me know if it works.
Photo of Jennifer

Jennifer

  • 10 Points
Worked perfectly!  Thank you very much!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Thx for letting me know.