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);"




 
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
OK, so put back the formula the way it was.  I thought you meant that it did not create the record.  You are saying that it does create the record, but the fid 7 is blank.

When you view (not edit) the source record that you are copying, can you tell me what text is on the field [Product Description]?  ie does it in fact have text in it?