Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
I have an app in the Exchange called URL Formulas for dummies which explains one way to nest formula URLS.
Note: formula URLs and not formula Rich Text fields.
Define your steps and then nest them like this.
Define each step as a separate formula variable, in order to improve readability. Then just slice off as much of this salamiI as you need.
$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))))))
Note: formula URLs and not formula Rich Text fields.
Define your steps and then nest them like this.
Define each step as a separate formula variable, in order to improve readability. Then just slice off as much of this salamiI as you need.
$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))))))