Not sure where to post this on this site so figured this looked best. I am trying to follow a tutorial you had posted a while back and cannot get it to work.
Basically I need someone to choose a value from a drop down list (which is pulling from an oracle db). Then based on that drop down I want it to populate other fields on the screen. Right now I have 2 fields on the screen ZZ_CODE and ZZ_DESC. When they choose ZZ_CODE I want it to populate ZZ_DESC.
Here is my script:

—– 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! 🙂

Stefan,
I have completed mutilated my code since i posted. So now I have done this below going by what I found in Adobe documentation:
I now do not get an error but my other fields are not updating. My drop down list is populating correctly but when I choose something nothing else changes on the screen.
I am also getting an Oracle error listener could not resolve SERVICE_NAME. This error is odd because I can login through the Data View and it pulls back the tables but when I
preview I get the Oracle error – weird…I will have to buy more beer for this one!

—– form1.#subform[0].ZZ_EEID::initialize: – (JavaScript, client) ——————————–

var sDataConnectionName = “AbraData”;
var sColHiddenValue = “ZZ_EEID”;
var sColDisplayText = “ZZ_EEID”;
// Search for sourceSet node which matchs the DataConnection name
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex).clone(1);
oDB.open();
oDB.first();
// Search node with the class name “command”
nIndex = 0;
while(oDB.nodes.item(nIndex).className != “command”)
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayBOF”, “bofAction”);
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayEOF”, “eofAction”);

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex

Hope this works I tried another time and it still cut it off.
Thanks for all your help. So Stefan are you available for consulting?

—– form1.#subform[0].ZZ_EEID::initialize: – (JavaScript, client) ——————————–

var sDataConnectionName = “AbraData”;
var sColHiddenValue = “ZZ_EEID”;
var sColDisplayText = “ZZ_EEID”;
// Search for sourceSet node which matchs the DataConnection name
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex).clone(1);
oDB.open();
oDB.first();
// Search node with the class name “command”
nIndex = 0;
while(oDB.nodes.item(nIndex).className != “command”)
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayBOF”, “bofAction”);
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayEOF”, “eofAction”);

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex &lt oRecord.nodes.length; nColIndex++)
{
if(oRecord.nodes.item(nColIndex).name == sColHiddenValue)
{
o
ValueNode = oRecord.nodes.item(nColIndex);
}
else if(oRecord.nodes.item(nColIndex).name == sColDisplayText)
{
o
TextNode = oRecord.nodes.item(nColIndex);
}
}
while(!oDB.isEOF())
{
this.addItem(oValueNode.value, oValueNode.value);
//IDList.addItem(oValueNode.value, oTextNode.value);
oDB.next();
}
// Close connection
oDB.close();

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

var sZZ_EEID = xfa.event.newText
var oDataConn = Ref(xfa.sourceSet.AbraData)

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

oDataConn.#command.query.select = Concat(“Select * from SYSADM.PS_ZZ_RATING Where ZZ_EEID = “, Ltrim(Rtrim(sZZ_EEID)))

Greg Blodgett,

As far as I can tell, you Initialize script looks OK. As for your Change script, based on what you posted, you’re missing the following statements after you set the data connection’s select statement:

oDataConn.open()
oDataConn.first()

That should explain why fields bound to the second data connection remain blank after you select an item in the drop down list.

Also, if you are editing this form with Designer 8.0 and have saved is as an Acrobat 8 PDF (XFA 2.5) form, then you also have another problem with your Change script: You’ll first need to clone the data connection before you set its commandType and select properties. Otherwise, you’ll get a security error.

Please give these tips a try and let me know if you get your form working.

Rachel,

Can you simply modify the Display Pattern to remove the symbol (which looks like a foreign currency symbol to me)?

Or are you wanting to modify the Display Pattern with FormCalc script?

Jeff,

Unfortunately, I don’t believe the XFA Picture Clause spec provides a way to do conditional formatting in such a way that you could specify to a particular sub-pattern within a compound pattern like “num{‘One x’}|num{‘Two x’}” where it would choose “One 1” if x was 1.

I think your best bet is to use the Change event script to filter the input and set the output.

Hi, Stefan
Could you, please, help me with one issue relater FormCalc for?

I’m taking some list by this code:
var userCode= xfa.resolveNodes(concat(“$record.empls.empl.[fg_code==”””,fgCode,”””].empl_code”))

and now i need loop throught this userCode list, I tried to do it by:
for i=0 upto comboLen -1 step 1 do
xfa.host.messageBox(userCode[i])
endfor
but no luck.
How can I loop formCalc list variable?

Thank you in advance,
Paul

Hi Stefan,

Can you help me in converting the following Javascript line to FormCalc-

var fields = xfa.layout.pageContent(xfa.layout.page(this)-1, “field”, 0);

Hi –
Is there a maximum number of lines that can be executed inside of a for loop?

Grasping at straws here, so figured it was worth a shot!

Thanks,

Sharon

Hi Stefan,
I am a beginner with FormCalc and am trying to create a form such that if a particular field has no value, another field is hidden. If the first field has any value, then the subsequent field is shown with a drop-down list and so on. The first sequence works but when I enter text in the first field, I automatically get “visible” in the second field in addition to my drop down list ! How can I just have the field become visible, but not put the word in there too ? I tried using the rawValue function as well as using a default in the object value, but it didn’t make a difference. Here is the script. Much thanks !
—– F.P1.work2::calculate – (FormCalc, both) ———

if (volunteer2.isNull | volunteer2 == “”)then
work2.presence = “invisible”;
else
work2.presence = “visible”;
work2.rawValue = work2.rawValue

endif

Hi,
I have requirement as.
Form will contain First Page with list of equipments in a table (Rows count is dynamic depending upon number of equipments). Other Pages will contain Individual Equipments.
First Page contains Table with Columns 1. Equipment No. 2. CheckBox.
The User will selects CheckBox & Press Button “Ok”. At this point it Should pickup Equipment in selected row & control should be moved to respective Page.
How we can get details of selected Row Dynamically?
Any help will be greatly appreciated.
Thanks & Regards
Mahendra Khandagale

mahendra,

Are you asking me how to automatically scroll down to where the equipment line is or how, upon checking the box, to get information about the related equipment?

Hi Stefan,

I have my footer at the last position, in the hierarchy,just after the table,so as the content of the table before it flows, the footer is been pushed to the last page.
Now my requirement is to print the page number on every page at the right bottom corner , so please tell me how to print the page number at that positon

Neha,

I have a tutorial on email submit buttons that will help you do what you describe. Note that the tutorial uses JavaScript, not FormCalc, however you can easily set the script language in the Script Editor.

Neha,

Please see my response to your comment on my email submit button tutorial.

Bev Williams,

My tutorial on handling list selection changes should tell you everything you need to know about detecting a change in selection in a drop down list. Once you have detected the change, you can change the items in another list by first clearing the existing items, using the ‘clearItems()’ method on the list, then by adding new items, using the ‘addItem(text[, value])’ method on the list.

If you can hook this up to a database as the source, then you should have a look at my tutorial on selecting specific database records.

@prasanth,

I’m afraid you’re going to run into security issues that will make it difficult for you to get those images.

Can you elaborate on where they’re located? User’s local system?

Generally speaking, unless you can get the base64-encoded image bytes for those images through some data connection or web site, you will not be able to load them into your form unless a user manually selects them from some physical location.

@prasanth,

When you talk about a “Graphic node”, I take it you’re not referring to an XFA form…

To get these images into your form, you’ll need to get their base64-encoded byte strings into some table, make a data connection to that table, and bind the image byte column to a repeatable image field (i.e. an image field in a repeatable subform) on your form.

@Mr. K Luk,

You can force the list part of a drop down list to open programmatically by using the xfa.host.openList({object}) function where {object} is a reference to the drop down list.

To do this when the user clicks into the drop down list, you can call the function in the field’s Enter event which occurs when the field receives input focus.

@Kiran,

This can be done quite simply using script that identifies the current page out of the number of pages. Knowing that each page gets an instance of the master page, you just need script in a hidden button, for example, on the same master page as the two images that does this:

// JavaScript:
if (xfa.layout.page(this) == xfa.layout.pageCount())
    Image1.presence = "hidden";
else
    Image2.presence = "hidden";

The code above will leave Image1 visible on all pages except the last one where Image2 will be the only visible image.

@Ainhoa,

You need to set the “Object palette > Value tab > Type property” to “Calculated — User can override” and choose “script” as the source for the calculation.

@Ainhoa,

Once the value is overriden by the user, the calculation won’t run anymore.

Also note the bug on calculation overrides. It was fixed in Acrobat/Reader 8.0.