Forum Discussion

MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
8 years ago

Copy a child record that contains a Multi-Line Text Field.

I working on a quote form and need to ability to copy a child record on the quote. (Quote being the parent, and Details being the child records). I can get it working just fine with the following ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
That javascript refresh is super handy, but it also hide error messages.

To debug,

Do this and then it will expose the success or failure message.  

var text URL= URLRoot() & "db/" & Dbid() & "?a=API_AddRecord"
& "&_fid_15=" & [Related Sales order]
& "&_fid_13=" & URLEncode([Related Product])
& "&_fid_7=" & URLEncode([Product Description]) // this is a multi-line text box.
& "&_fid_8=" & [Product Quantity]
& "&_fid_9=" & [Product Unit Price]
& "&_fid_24=" & ToNumber([Taxable Item]);

$URL

//"javascript:" &
//"$.get('" & 
//$URL & 
//"',function(){" &
//"location.reload(true);" &
//"});" 
//& "void(0);"




 
MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
8 years ago
It is the multi-line that is creating the issue.  As long as I have just one line of text, it works, when I add a second line, it fails (it doesn't create the record at all).

In addition, if I add the = character to a single line, it fails to display the description, but it does create the record.