Forum Discussion

JoshuaCase's avatar
JoshuaCase
Qrew Cadet
6 years ago

How to Add Many Records in seperate table from a form URL Formula button

I am looking to create a formula URL button that creates multiple tasks associated with a single project.  Each task is unique with a different task name BUT it does follow a template so all tasks are...
APIs and custom code
Button
JoshuaCase's avatar
JoshuaCase
Qrew Cadet
6 years ago
Mark,

I have run into an issue now of course.  How do I tie my code past the third line?

Currently, I have:

$URLONE & "&rdr=" &
URLEncode($URLTWO)&
URLEncode("&rdr=" & URLEncode($URLTHREE))&
URLEncode("&rdr=" & URLEncode($URLFOUR))&
URLEncode("&rdr=" & URLEncode($URLFIVE))

I get an error and only 3 tasks get created.  I assume I am missing the correct redirect pattern but I can't figure it out.  Am I limited to only 3?

------------------------------
Joshua Case
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Here is the generic format for up to 7 redirects.  Slice off as much of the salami as you need.  I have no idea why the nesting of the URLEncoding is required, but it just is.

$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEVEN))))))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JoshuaCase's avatar
    JoshuaCase
    Qrew Cadet
    6 years ago
    Thank you!!

    ------------------------------
    Joshua Case
    ------------------------------