I need to do a scenario in a form where when a user input its companyid the fiel

I need to do a scenario in a form where when a user input its companyid the fields with company information will appear on its corresponding fields. I'm looking into Advance Form Utilities but bit lost on it. Have tried constructing code but unfortunately I always encounter exception error.

var compID = window.FormAPI.getValue("text7").id

FormAPI.attachAutocompleteFromQuery("compid", "java:jdbc/AppianAnywhere", "select compid, name from raawarequisition where compid = compID", "compid", "name", false)

Can any one suggest a better work around for this? TIA....

OriginalPostID-110614

OriginalPostID-110614