Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Shailevit
Community profile Shailevit Level 3
Job title here
Location here
12 BADGES
Level 3

Level 3

Learn more
Joined the community 14-03-2009 5:14:08 AM
Offline
Top badges earned by Shailevit
Customize the badges you want to showcase on your profile
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
So here is the new and improved form. I implemented the new changes to the Table1, where every check box does now behave as predicted with new instances and fields are filled appropriately.So new issue is how to script a JavaScript (as oposed to FormCalc) in calculating all the amount fields in the table. I have it working using formcalc eventhough it throws an error.Other issue(s):Form does not allow printing or saving - very odd indeed.And how can I calculate a follow-up date via JavaScript, t...

Views

541

Likes

0

Replies

0
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thanks Bruce,That JavaScript worked great and performed as I expected. My only other small trivial issues are these:When I open the Form in Adobe Acrobat XI, I get a warning message: Cannot save form informationeventhtough I made sure that the security of the form (in LC ES4: File -> FormProperties) is disabled to allow form saving.Also I added a script using Action Script, which basically adds all the amount values in the amount of the Table1 and Sums them. The function works fine, except I sti...

Views

553

Likes

0

Replies

0
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
I have made a few changes to the form, but the same problem still persists. Please find the link for the form. Again it is an issue with cells being overwritten during an action script when a new instance of table rows is created. I think looking at the script I see the issue, but am perplexed at how to correct it. I also included the action script.Action script for check box one: Type: Action//+ Result3: SetFocus("$Node4")//+ Result2: SetFieldValue("$Node3","tovalue","FR 1")//+ Result1: AddInst...

Views

536

Likes

0

Replies

0
Help with Table cell data being passed via action script
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
I am trying to pass some data to a table cell that is set-up to grow dynamically. Each time a check box is selected, a new Instance of the table row is created, and the first cell is being populated via an action script.The issue is that the first cell populates fine, but each successive row, the first cell is being overritten and the new cells are not being populated.I have attached the script, but looking at it, the error seems obvious, but the solution escapes me.The error seems to be that bo...

Views

345

Likes

0

Replies

0
FormCalc with 2 seperate table cells
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
How would you script this scenerio:There are 2 tables, each with their own amount cell. These cells grow dynamically as user enter data in either of the table cells. A third table needs to sum these amount(s) in each cell in this manner > if Table_Two amount cell has value, then sum all Table_One and Table_Two amount cells, otherwise, only sum Table_One amount cell(s).I am coding this using FormCalc in this manner:if (HasValue(Table_Two.amount))thenSum(Table_One[*].amount[*].rawValue)+ (Table_Tw...

Views

386

Likes

0

Replies

0
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Hi Bruce,My apologies (newbies, I tell you). So here is the link to the document>https://workspaces.acrobat.com/?d=gXLN793XZjRXpTkNJS6QNote: Issue is with text being overwritten and new instance of table row not passing on new action.ThanksShai

Views

541

Likes

0

Replies

0
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Hi Bruce,I have attached my latest version of the document. So I do have a link from the check box. It's an action script that says: if I check the box, two fields in the table are populated with text and then there is a focus on the third field. That part works fine. I can even control the uncheck box action script that put all values to null.My issue lies in the fact that when I check the next box, I need another instance of the Table (one row) to populate.So what happens is the new instance o...

Views

536

Likes

0

Replies

0
Re: Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Hi Bruce,Sure please find the entire form attached. I looked at a few examples and even added more table-type sub-forms, but it is still not behaving as I would like.Similarly, is there a way to transpose one field value from a text to another on another page?Thanks in advanceShai

Views

535

Likes

0

Replies

0
Table rows functionality with passing data and instances
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
My form setup is as follows:I have several check boxes overlaid on an image. Each box will have several actions associated to it (more on this in a minute).I have a Table that will take in some data, depending on what check boxes are checked and unchecked.Several things are happening as follows:A table is setup with the following headers and respective rows - vial#(txt), location(txt), area(txt), amount(dropdown), price(dropdown), cost(calculated - eval(amount * price)).When a check box is selec...

Views

5.9K

Likes

0

Replies

13
Re: How to make formfield to clear after user submits data
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Ok... Sorry.Yes. JS = JavaScript, but not to worry.If you are using LIfeCycle (LC ES), then the re is a button called Reset Button in your Object library - this should do it for you.But.. you can also add an Action to the email button as well. So click on the button and in the (show events with scripts) add the JS code for clear all fields: xfa.host.resetData(); - this can also be accomplished by right click the button and use action script - when button is clicked.. Condition / Result.The email...

Views

61

Like

1

Replies

0
Databases and LC ES2 connectivity - Issues and Solutions!
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
By far the most important subject mater and yet probably a simple solution, yet there are some questions that just elude me. And finding the answers in an online manual is sometimes cumbersome at best - if the examples even make sense. So here are the 3 most pressing questions and some insight.1. Once a PDF form is created in LC ES2, and the connection to a database (MS Access) is made, tested, confirmed, how do you install this new form on someone else's system and create the same connection, i...

Views

551

Likes

0

Replies

1
Re: How to make formfield to clear after user submits data
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Not sure if this will work, but you can code a clearing JS in the submitt button. So - you have submit - it sends the PDF form to the email you entered in the email field, but also in the JS section, you have the xfa code for clear.Its a shot

Views

65

Likes

0

Replies

0
Re: Submitting data from a form to Access Database
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
those links are not a solution to the issue. I am also looking for an answer to send the data to MS Access. The connections are made and work. Testing the connections work. But I just need the data to populate the DB - not the otherway around.Should be simple JS

Views

152

Likes

0

Replies

0
Array for dropdown choices
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
I recently saw a static array created in ES2 form, whereby selecting a specific item, filters the next available items in another (next) dropdown form. But how can this be achieved via the connection to a database (MS Access)? How can the information be populated in the PDF form and waht is the actionscript for that?ThanksShai

Views

439

Likes

0

Replies

0
Re: Javascript to prop error message
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thank Steve,But the link only shows how a message box will appear and the paramaters involved, i.e. title, message, icon, button. But how do you write a script that will evaluate the value of a input on the form and only pop-up the message box, when the value is exceeded?Guess I am asking, if you enter a blodd pressure numerical value higher than normal, then the box will appear. So In guess I am looking for the IF then Else statement - right? Cheers Shai

Views

87

Likes

0

Replies

0
Javascript to prop error message
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Is there a way to write a Javascript statement to invoke a pop-up window when certain values are eneter in a form?Specifically: Say you are entering a value for blood pressure and the number is above the avarage. So as you populate the numerical field and tab to the next field, a pop-up window comes up reminding you of the value you entered is above the normal range.Thanks for the helpShai

Views

910

Likes

0

Replies

3
Multiple fields into one Database (MySQL)
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
I created a table with multiple fields that need to populate a MySQL database, but a bit more complex than mere entry. Each line holds information that is particular to that line and resides in multiple tables that are then related to eachother. Not sure if such a thing is possible with the forms, but here is a detailed explanation and attached form.0. Top of form has information about the place and date of visit1. Each line holds name (first,last), Room#, Proceedure code, Diagnosis code and f/u...

Views

347

Likes

0

Replies

0
Re: Repeatable Forms
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Hi Paul, So it seems to work, but what is the action code to make the subform appear? I set the main page as flowed. Have the subform as hidden, went into the button action builder and tried both Show or Hide an object or Enable or Disable an object - but neither of the two actions worked. Any suggestions is much appreciated.

Views

94

Likes

0

Replies

0
Pin down field in flowed form
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
How can one pin down a field in a form that is set as flowed. My form is only 1/2 a page to allow for some fields to grow and be added, but I want to have the page number of this form pinned to the bottom right corner. How can this be accomplished?

Views

373

Likes

0

Replies

1
Re: Duplicating a field
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thanks - that worked. I used the global binding. Cheers Shai

Views

110

Likes

0

Replies

0
Duplicating a field
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Two Questions:1. I have a two page form, where the user enters a name. I want the name to also show up on the second form on the bottom (like a footnote), so that the two pages are not miss filed. How do you create a field (possible text) that when you enter a name in the first page, it automatically filles in on the second page?2. If I enter a persons DOB, how can I have it calculate his age and display it in another firld (numeric)?ThanksThis forum is the best!

Views

533

Likes

0

Replies

3
Signature
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
I created a form in LC ES2, made sure that the properties allowed for the form to be filled and signed. Yet when one opens it up in the plain Acrobat reader, it does not allow for the form to beelectronically signed. On the other hand, opening it up in Adobe Acrobat Pro, does allow for the form to be signed. Is there a way that someone can receive or I can distribute the forms so that they can be opened in the plain Acrobat reader (9.1) and be signed, or is that not possible?Thanks.

Views

369

Likes

0

Replies

1
Re: PDF to MySQL database
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thanks Paul - few mentioned that I have set a required field in my relational db, preventing any data from being accepted without data residing in the other tables. Working on fixing that, then back to the forms. Cheers Shai

Views

204

Likes

0

Replies

0
Re: PDF to MySQL database
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thanks KevinGuess I thought that since the ID's are required for creating the relationships between tables, I needed to make them a requirement, but I need to figure out how I can assign them automatically and increment them as new data is entered. Will work on the db some more - but any advice is greatly appreciated - I always seem to miss the small details. Cheers Shai

Views

200

Likes

0

Replies

0
Re: PDF to MySQL database
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
So how familiar are you with MySQL databases? Having some issues and not getting anywhere from their forums. I did notice that I have to change the date format when sending data from PDF to MySQL db, since their syntax is yyyy-dd-mmI did take some screen shots at the database - see what you think where I am going wrong. No data is accepted at all. No Javascript error from the PDF file either. Connections work fine and data seems to go, but not reside in the db. I even tried to enter the data man...

Views

200

Likes

0

Replies

0
PDF to MySQL database
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
So here is the enigma. I set up a PDF form with fields that are correctly bound to the backend MySQL database - i.e. the connections work, I see and can chose the correct table values, all seems well. The submit (add), update buttons seem to work fine (i.e. the xfa code is correct) since all the data dissapears from the form, but when I query the database, no data ?So where is the error? I get no error messages at all.Advice always appreciated. Not sure if this is a MySQL end issue or not.Shai

Views

3.5K

Likes

0

Replies

7
Re: Repeatable Forms
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Thank Paul.I was able to set the buttons in a seperate subform (since the entire document is Flowable). The using the action builder - sweet toy add-on it was simple to just point to the subform that I needed repeating. Remembering that I also had to make sure I set the subform as repeatable,Worked great.I do have a mnore complex question:Is it possible to have a form (text field) and resides in the middle of the original page, have it hidden (until invoked by a check box or button) and then app...

Views

99

Likes

0

Replies

0
Repeatable Forms
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
How can one repeat a subform with text and dropdown menues, but without having to have the button also repeat within the subform.So there are 2 buttons in the subform - add and delete (they are only visible on the screen), But I just want the fields repeated, without the buttons.Do I have to put the buttons outside the subform? Is there a way to isolate what is to be repeated?Thanks - PS: I am using the LC ES2 and love the new additions (recommend the upgrade) But is there a way to also get the ...

Views

1.1K

Likes

0

Replies

5
Re: Checkbox response to open a subfield
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Hmmm.Your example did not run in browser, plus it seems to be created in CF not an Adobe PDF form. So what is the Javascript for creating a check-box that will invoke a text-field to drop and move all other fields after it - keeping things organized and in sequential order. Cheers Shai

Views

64

Likes

0

Replies

0
Checkbox response to open a subfield
Avatar
Ignite 20
Level 3
Shailevit
Level 3

Like

1 like

Total Posts

56 posts

Correct reply

0 solutions
Top badges earned
Ignite 20
Give Back 25
Ignite 10
Give Back 10
Ignite 5
View profile
Shailevit
- Adobe LiveCycle
Can one use a check box field to open (invoke) a subfield.Meaning, if you click on the check box, then a section (text field) drops below where you are. Say there is a change and unchanged check box option for one to click. clicking on the change, will drop a text field below the subfield you are currently in; but checking of the unchaged check box will do nothing.Hope this set-up makes sense, since I see they are not letting anyone to upload files anymore.Last quick ?. If one got ES 8.2 with th...

Views

634

Likes

0

Replies

3
Likes given to
Likes from