Populating form fields with DoQuery results

Here is an demo. There are two tables Records and Ipsums. The table Ipsums contains 59 records of hilarious Lorem Ipsum themed text. For the demo you can think of these records in Ipssums as fragments of a document you may want to include into the [Document] field you are editing in the table Records. To test enter a [keyword] such as "QuickBase", "Ipsum" or a word of your choice and press the button. The [Document] field will be populated with the [Sample] field in each Ipsums record that matching your keyword.




Clone Ipsum ~ Add New Record
https://haversineconsulting.quickbase.com/db/bnsfbfx9a?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=663

Notes:

(1) The logic for matching Ipsums records actually are those records containing the keyword along with always including three records for "QuickBase Ipsum", "Product Manager Ipsum" and "Script Ipsum". Consider the inclusion of these three records as boilerplate.

(2) Obviously I just dreamed up this example out of thin air. Whatever your requirements are I am sure the script can be easily modified to suit your needs.