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
BedrockMission!

Learn more

View all

Sign in to view all badges

whyisthisme
Community profile whyisthisme Level 7
Job title here
Location here
26 BADGES
Level 7

Level 7

Learn more
Joined the community 03-08-2011 11:16:58 PM
Offline
Top badges earned by whyisthisme
Customize the badges you want to showcase on your profile
Re: If less than zero, then zero
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
I am not sure of the java but in formcalc it would be:if (a - (b+c) > 0) then $ = a - (b+c)else $ = 0endif(in the calculate field of the total box)

Views

451

Likes

0

Replies

0
Re: Completing a form in stages with different people.
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
Yes you can do that. There is a function called access where you can change a field to read-only or protected. You could put this fuction either in the exit event of a field so once your staff put in the details it will lock, but that means they couldn't change it if they made a mistake. I would probably make a button which your staff can click when they have finished and are happy with their section which would lock all their fields and then disappear.

Views

76

Likes

0

Replies

0
Re: Reset subforms on pdf reload
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
Your form should be 'remembering' the changes when you reload them - you do not have to fire the change events again. If you go to File/Form Properties under the Defaults tab there is a Scripting box. Under the question 'Preserve scripting changes to form when saved:' make sure the Automatically radio button is checked. This means that whatever you do to a form will be saved and when you reopen it will be the same.

Views

77

Likes

0

Replies

0
Re: Getting the sum in FormCal
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
It is not working becuase you need to reference the rows in the sum function. So it should be something like this:Sum(Row1.sq1 + Row2.sq2 + Row3.sq3) etcYou can make it easier for yourself by naming all the rows the same thing (eg. Row1) and all the total cells the same thing (eg. Total) then it will automatically rename them Row1[0], Row1[1], etc.Then for the sum of the columns you just need to put Sum(Row1[*].Total).

Views

93

Likes

0

Replies

0
Re: Using formCalc or JavaScript
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
It is becuase if files in blank it counts that as not equal to 0 so does the calculation. try:if (files > 0) then Sum(60/files) else $ = ""endif

Views

191

Likes

0

Replies

0
Re: Help a Rookie - Doing Date Calculations
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You have put the script in the enter event for the friday date so the dat will only appear if you actually enter that field. Try putting it into the calculate event. That way it will appear as soon as someone enters the Saturday value.

Views

85

Likes

0

Replies

0
Re: Date / Calendar validation.
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You can do a script like the following which will clear the entry if they don't follow the correct pattern:(if formcalc in the exit event for the calendar)var startDate = $.formattedValueif (Date2Num(startDate, "DD/MMMM/YYYY") == 0) then$=""endifthe Date2Num will give 0 if the pattern isn't correct.

Views

64

Likes

0

Replies

0
Re: FormCalc Help!
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
If you are looking for documentation on formcalc try this: http://help.adobe.com/en_US/livecycle/8.2/FormCalc.pdf

Views

108

Likes

0

Replies

0
Re: FormCalc Help!
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
Well the code you would use would depend on how the form was setup. Are the yes/no/na questions radio buttons, tick boxes, a table or what?There is a count function in FormCalc - the easiest way to use it is if you setup each of the questions in a table and name each row the same thing (eg. Question). That way livecycle will name them Question[0], Question[1], etc. Then when you want to count say the answers in cell1 (which would be yes) you could just do Count(Question[*].cell1). You would put ...

Views

105

Likes

0

Replies

0
Re: Hidden field revealed when date / time field is changed
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
To specifiy when to run the presence code you can use the Date2Num function. This will translate a date into a number and then you can say that when the Date2Num result is equal to the date you want then the presence will change.

Views

171

Like

1

Replies

0
Re: Drop Down Selects Sub Form
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You can use FormCalc rather than Java if you are not familiar with Java. To make things hidden or visible depending on what happens in a dropdown menu you will need to do:- For the dropdown you will need to assign values to the possible choices in the Object>Binding tab by checking the box next to "Specify Item Values". Now each choice will have a number value and you can use that to determine what happens when each choice is made.- In the Exit event of the dropdown you put the following code (i...

Views

133

Likes

0

Replies

0
Re: Can I use math functions in a PDF?
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
you can also do it in formcalc. For adding use the sum() function.For averages use the Avg() function.You could put the formula in the calculate event of the field you want the results to show in and it would appear as soon as the initial numers are entered, or if you want to use a button you could put the formula in the click event of the button.

Views

111

Likes

0

Replies

0
Re: Date Field Validation
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You could do an if statement where if the field fails its validation the field becomes "" (blank) and validate.nullTest="error" (makes the field mandatory).

Views

178

Likes

0

Replies

0
Re: Json to livecycle
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
Sounds a bit complicated. I will find another way. Thanks for your help.

Views

267

Likes

0

Replies

0
Re: Division aritmetic overflow
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
It is because you can't divide by zero which is what would be happening if one of the fields was empty so perhaps the calculation of the third box should be (in formcalc):if (NumericField1.isNull == 0 and NumericField2.isNull == 0) then $ = NumericField1/NumericField2else $ = ""endifthis is saying that it should only do the calculation if both the other fields have a value in them

Views

118

Likes

0

Replies

0
Re: Align my_text in the CENTER of the form?
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
There is probably a fancier way of doing this but one way is to make the textbox the entire width of the form and make sure it is center aligned. That way no matter how long the string is that you enter it will always be centered.

Views

111

Like

1

Replies

0
Re: Json to livecycle
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
transport. I need to use it to extract data from a database to prefill some fields in my form. Thanks.

Views

214

Likes

0

Replies

0
Json to livecycle
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
Does anyone know if you can use Json to connect a database to a form in Livecycle?

Views

2.1K

Likes

0

Replies

4
Re: Radio Buttons
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
In the click event of the radio button you put (in formcalc)$.caption.value.#text="new text" // put whatever you want it to change to in the ""The box will automatically select when you click on it.

Views

94

Like

1

Replies

0
Re: connecting selection of radio button to a text or numeric field
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
In the click event for each radio button you could put (in formcalc)numericfield = 1 // where numericfield is the name of the field you want the number to show in and 1 is where you would put the value you want when the user clicks that button

Views

118

Likes

0

Replies

0
Re: Calculated Field Problem
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You can use FormCalc instead of Javascript and either do:$ = Table1.Row1.tptw1 + Table1.Row2.tptw2 + etcor you can name all the rows and the cells with the number the same thing (ie. call them all Row1 and then it will automatically make it Row1[0], Row1[1], etc and do the same with the cell) and them just do$ = Sum(Row1[*].tptw)

Views

56

Likes

0

Replies

0
Re: Applying different master pages
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
In Object> Pagination you need to make sure the 'After' is set to 'Continue Filling Parent'. That should remove the extra pages.

Views

76

Likes

0

Replies

0
Re: When adding a page a extra page appears
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
In Object> Pagination you need to make sure the 'After' is set to 'Continue Filling Parent'. That should remove the extra page.

Views

112

Likes

0

Replies

0
Re: Prefill fields from a database
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
So I have now worked out the SQL bit and have a OLEDB connection with an SQL query which links the tables. It gives me the correct record for one client but what I now don't know is the code to put into the form so you can enter a client number and it will bring up that record. I have a client number numeric field and I assume the code goes in the exit event but can someone please help me with the actual code. Thanks!

Views

124

Likes

0

Replies

0
Re: Form Design query
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
what about using + for yes and - for no in your dropdown list? would that work for you?

Views

187

Likes

0

Replies

0
Re: Prefill fields from a database
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
and how do I do that? That is the bit I need to know.

Views

116

Likes

0

Replies

0
Re: Prefill fields from a database
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
OK so I have watched the video but I have multiple data connections and I am not sure how to link them together to get the one record? (ie. the client number is in one table of the database and then in a seperate table ( so new data connection) is the address and in a seperate table are other details I need to access).

Views

119

Likes

0

Replies

0
Prefill fields from a database
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
I have a form with a OLEDB connection and I have bound certain fields to it (name, address etc.). What I want to do is allow the user to put in their client number and then the form fills in the other information (name, address etc) from the database. How do I do this (in formcalc if possible)? Thanks!

Views

1.2K

Likes

0

Replies

5
Re: Is this possible?
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
the basic script (in formcalc) is:$ = Date2Num(endDate.formattedValue, "DD/MM/YYYY") - Date2Num(startDate.formattedValue,"DD/MM/YYYY") // the DD/MM/YYYY part should be whatever format you have set your date fields to.You put this script in the calculate field of the textbox. You may want to put in some extra code so you dont see a number until they have entered dates into both start and end date fields.

Views

84

Likes

0

Replies

0
Re: Is this possible?
Avatar
Give back 300
Level 7
whyisthisme
Level 7

Likes

41 likes

Total Posts

324 posts

Correct reply

59 solutions
Top badges earned
Give back 300
Ignite 5
Ignite 3
Give Back 200
Give Back 100
View profile
whyisthisme
- Adobe LiveCycle
You can use (in formcalc) the Date2Num function to turn your dates into numbers which you can then subtract the end date from the start date to get the number of days in between. You could put that calculation into the restrictedDays field so it will calculate automatically without the need for a button.

Views

85

Like

1

Replies

0
Likes given to