Formula URL to append to text multi-line
Hello. I have a formula URL button that's designed to copy inputs from one set of fields into another. It works with one exception - I can't seem to copy over the text from a text multi-line field (wi...
Forum Discussion
Hello. Thanks for your assistance. I have part of a form in which users can create new records (in the same table) using data from the current record. I want users to be able to add comments to such a new record in the process. The formula, in a nutshell is as follows:
var text URLOne = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord"
& "&_fid_6=" & [Topic]
& "&_fid_7=" & [Details]
& "&_fid_160=" & [DE - Comment];
And then of course later the javascript gets that url. All the other portions of this url work - just not the comment, ie the new record has values in the other fields referenced in the above forula. So just to be crystal clear, fid 160 is the multi-line text field with edit logs. I included the other fields for context. I've tried this with the field "DE - Comment" as a mutiline with edit logs and without. Nothing ever copies over.
Thoughts?
var text URLOne = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord"
& "&_fid_6=" & [Topic]
& "&_fid_7=" & [Details]
& "&_fid_160=" & [DE - Comment];
And then of course later the javascript gets that url. All the other portions of this url work - just not the comment, ie the new record has values in the other fields referenced in the above forula. So just to be crystal clear, fid 160 is the multi-line text field with edit logs. I included the other fields for context. I've tried this with the field "DE - Comment" as a mutiline with edit logs and without. Nothing ever copies over.
Thoughts?