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

SOLVED

Add a unique row number to a dynamic form

Avatar

Level 1

Our engineers use a Dynamic PDF form to complete their dailiy activities.

I now want to import this data in XML to SQL. However I need a unique row number for each line entered.

Does anyone know how to scipt this in Java?

The layout of the dynamic form currently is:

Date - Activity Code-JobNo-StartTime-EndTime

The engineer adds more rows as necessary.

Want I want is :

IDNo-Date - Activity Code-JobNo-StartTime-EndTime

Regards

Chris C

1 Accepted Solution

Avatar

Correct answer by
Level 4
5 Replies

Avatar

Level 4

We use our Pesticide recertification form the same way.  However, we distribute the form

and when it is returned it is exported into XML and our SQL server identifies new entries and transfers the data to tables.

If you email me directly, I will send you an example form with the script.  I can't figure out how to attach it from the forum.

Avatar

Level 1

Hello Ida,

Thanks for replying.

If you could send me an example form with script that would be very helpful.

Overall I find LifeCycle very good and have been using it for past three years but there are always things I need to add. I only discovered there was this forum recently.

Regards

Chris Chalcraft

Avatar

Level 4

Same here, I find myself referring back to the forums when I need add new features to forms for my agency.

The attached form has the following:

1. Unique Form ID creation. Every time the form opens, it generates an unique ID.

2. Read only fields w/secret space. Author of the form must know the a combination of words to access the secret space. For this example: Enter Tree in the cell after the save button and Frog after that cell to display secret space to enter read only text.

3. Unlimited dynamic table rows. Only way I could get unlimited rows was by using a button.

Functionality:

Staff enters the data and emails a distributed form to someone. They fill it out and return it via email. From there, it is add to a portfolio and exported in XML and saved in a specified location. From there, the SQL server identifies the new XML entry and uploads it into the table by using stored procedures and triggers.

Other options you might want to consider is binding your form fields to the SQL table directly. Don't know how to do that with dynamic table rows though, never had to do it with any of my forms....yet.

I. Eve Tracy

Avatar

Level 1

Hello Ida,

Thanks for the reply. I did not receive a form with your e-mail? Possibly my virus checker stripped it out. Could you please re-send.

Thanks

Regards

Chris C

Avatar

Correct answer by
Level 4

Here you go.