Wish I had seen your tutorial earlier. Have been “volunteered” to create a dynamic form for the web, but I am NOT an IT staffer. Just got picked b/c I pick up apps quickly.

I’ve figured out the basics of LiveCycle Designer on my own & with JP Terry’s book…but he’s not much help for beginners with scripting.

I have radio buttons and I need to hide or display subforms as a result of the radio button chosen. Have any advice? Book skims it, but I need a step by step like your tutorial.

Help for the frustrated new girl?

Mallee

i have see your video, thanks for teaching how to bulid a webservice PDF but your web service only will retrieve one value only.. wonder it there is another tutorial about retrieve arraylist and etc, that mean multiple value….

example is the pdf, user must enter his username…

once the username is enter it will get from webservice and retrive his name, address, phone number and etc into different field.

wonder could you help me out or give me some advice

—– form1.#subform[0].Body.ZZ_CODE::change: – (FormCalc, client) ———————————

var sCODE = xfa.event.newText
var sZZ_CODE = $.boundItem(sCODE)
var oDataConn = Ref(xfa.sourceSet.AbraData)

oDataConn.#command.query.commandType=“text”

oDataConn.#command.query.select = Concat(“Select distinct ZZ_DESC from PS_ZZ_HRTABLES Where ZZ_CODE = “, sZZ_CODE,””)

oDataConn.open()
oDataConn.first()
AbraSub.presence=”visible”
AbraSub.ZZ_DESC = sCODE

I get an Script Failed error – Error: syntax error near token ”

If I can get this working I would then like to be able to take multiple fields into my where clause to populate the other fields on the form. For example, i will have a country code and a state code which will drive combined the data that shows on the form. So where clause like so ” Where state = “, sZZ_State,” and country = “,sZZ_COUNT,””)

Any help would be greatly appreciated. In fact I could even fax you a beer!

But I’m interested in doing something similar, but for populating a dropdown control at the point the PDF is loaded/rendered/displayed.

I want data from my database, “exposed” via a webservice, to appear as items in a dropdown control on the PDF.

How is this done? I’ve tried all sorts of things including steps similar to the ones you perform in your demo, but haven’t got anything to work.

Please help – a video tutorial on this would be fantastic.