Calling two variables in a Formula URL Field

Question

I have a Formula URL field whose two formulas are as follows:

var text URLONE = "javascript:void(copyMasterDetailButtonHandler('&recurse=false&copyFid=117&destrid=0&sourcerid=" & [Record ID#] & "', 'mydbid'))"

and

var text URLTWO = "https://me.quickbase.com/db/homedbid?act=API_SetDBVar";
& "&varname=" & URLEncode("lQnum")
& If($da<>[lQda],
"&value=" & URLEncode("02"),
If(ToNumber($y)<9,
"&value=" & URLEncode("0" & ToText(ToNumber($y)+1)),"&value=" & URLEncode(ToText(ToNumber($y)+1))));

By executing $URLONE or $URLTWO, they work fine. Combining them so that they execute in order gives me the error - Uncaught ReferenceError: Invalid left-hand side in assignment

$URLONE & "&rdr=" & URLEncode($URLTWO)

What am I doing wrong?

Thank you!

quickbasecoachd · Answer

It will work if you change the javascript part to an API call. The code you are using was auto generated by that wizard which makes the button but the identical functionality can be created using an API.

kencasser · Answer

Thanks, Mark!&nbsp; I rewrote URLONE as follows:var text URLONE = "https://me.quickbase.com/db/masterdbid?act=API_CopyMasterDetail&amp;destRID=0&amp;sourcerid=1&amp;copyfid=117";but it isn't working.&nbsp; I'll have to play with it more tomorrow.

quickbasecoachd · Answer

You are using record ID 1 as the source.

I think that you want

var text URLONE = "https://me.quickbase.com/db/masterdbid?act=API_CopyMasterDetail&destRID=0&sourcerid=" & [Record ID#] & "&copyfid=117";

kencasser · Answer

That makes sense but now I'm getting "CopyMasterDetail does not allow looping relationships".&nbsp; I got this once before and I don't remember what was done to fix it, but it was a bear.&nbsp; I might have to open another Support Case.&nbsp; Thank you for your help!

kencasser · Answer

Okay, I found the "looping" culprit and fixed that.&nbsp; My Formula URL field is working fine except for one thing.&nbsp; $URLONE copies the current record to a new record and puts "Copy of" into a field.&nbsp; Then, I want to change that field in the new record using another API_EditRecord, but when I use "&amp;rid=" &amp; [Record ID#], it edits the original record, not the new "Copy".&nbsp; How can I reference that new record's ID# in the API call?&nbsp; Thank you!

Forum Discussion

Calling two variables in a Formula URL Field

Related Content

Using variables with class='SaveBeforeNavigating

Nesting URL API Calls in one Button

Using Variables in Formulas

URL Formula Button w/ Two API Calls

Delete Formula Button Error