since ‎06-02-2015
‎10-12-2019
Beachbum2015
Level 1
Re: Need an In-Field Calculator Function Similar to Excel's "=" Sum Function For Data Entry Beachbum2015 - Adobe LiveCycle
It seems that will only work with text fields. I have 98 numeric fields that I would need to change, and then I'm summing all of the expenses for each day at the bottom of each column. Each column total is derived with this formula: sum (Table_Exp.Row1[*].Amount1). If I change all of the numeric fields to text fields, I would then need to find out how to convert the values back to numeric to allow for the formulas to work.
217
Views
0
Likes
0
Answers
Re: Need an In-Field Calculator Function Similar to Excel's "=" Sum Function For Data Entry Beachbum2015 - Adobe LiveCycle
This image better explains what I would like to do....
220
Views
0
Likes
0
Answers
Re: Need an In-Field Calculator Function Similar to Excel's "=" Sum Function For Data Entry Beachbum2015 - Adobe LiveCycle
No replies yet. Must be someone out there that has come across this need.Anyone??
222
Views
0
Likes
0
Answers
Need an In-Field Calculator Function Similar to Excel's "=" Sum Function For Data Entry Beachbum2015 - Adobe LiveCycle
I created a new expense form with a bunch of numeric fields for things such as transportation, lodging, meals, etc. This form replaced an Excel spreadsheet. Everything works fine, but now users miss the Excel sum (=) function to manually calculate a total for a field themselves.For example, a user has four different charges for transportation that he needs to total up, and then needs to enter that total in the transportation numeric field of the form. In the Excel version, the users had the abil...
790
Views
0
Likes
4
Answers and Comments
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Magus,The problem with this solution is that it will turn off field highlighting for ALL fields. It may help with the fields I want to color, but all of the other fields will be white, confusing the user.Also, turning off highlighting with my form will leave the user with this feature disabled. I wouldn't want to mess with someone's environment and risk ticking them off. I don't want to rely on them knowing how to re-enable highlighting.
544
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Well....it does work...BUT, as you mentioned, there's no way to ensure that users will disable Highlight Fields.Unfortunately, I can't use the solution. It has to work without requiring the users to modify any settings. They must be able to open the document and have it work without having to do anything else.Oh well, I guess this one's going to have to go under the "Not Possible" column.
542
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Magus069,This does not work either. Field color only changes when clicking on field.
543
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
XIIIX,That's the code I mentioned in my original post. But, you're getting close....I opened your modified form in Reader, and the field's value color changes now, but only after you click in the field. Once you leave the field, the value color reverts back to the default.The goal is to have the value's color changed when the form opens, and have it stay that color. The user should not have to click in the field to get the color to change. Here's a video of what is happening.https://www.dropbox....
546
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
BTW, I'm using LiveCycle Designer ES4. I made the change to the field's XML, then tried to preview, but no change in color.
545
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Hi Magus069,Thanks for your input. Unfortunately, no luck with the suggestion.I created a new form with just one text field and applied your suggested code to the XML for the field. No color change.Here's the form that I created as a test: http://tinyurl.com/o32e76pHere's the field's XML: (The addition is in bold) Name
544
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
XIIIX,I had tried your suggestion before, but it colors the whole field green, instead of just the value (content) area. I don't want to change the color of the caption, just the value. Here's the result of your suggestion:
543
Views
0
Likes
0
Answers
Re: Calculation No Longer Works if a Value in a Field is deleted Beachbum2015 - Adobe LiveCycle
XIIIX,I was using Numeric fields, along with the same pattern setup, but no luck. Switching to Javascript corrected the issue.
343
Views
0
Likes
0
Answers
Re: Calculation No Longer Works if a Value in a Field is deleted Beachbum2015 - Adobe LiveCycle
PDFGuru,Thanks for the info. I switched the calculation from Formcalc to JavaScript and it works fine now.
281
Views
0
Likes
0
Answers
Calculation No Longer Works if a Value in a Field is deleted Beachbum2015 - Adobe LiveCycle
I've got an issue where a FormCalc calculation stops working if I delete a value in a field that is part of the formula.Here's a link to the test form: https://www.dropbox.com/s/3w6weyd3bp5dfss/Test_Totals.pdf?dl=0When I enter the values in the table as below, the calculation in the CASH DUE EMPLOYEE field works fine.If I delete the value in the CASH ADVANCE field, the calculation in the CASH DUE EMPLOYEE field doesn't recalculate. In the below example, I deleted the cash advance, so the CASH DU...
1052
Views
0
Likes
4
Answers and Comments
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Well, it appears to be pretty straight forward. Yet...it doesn't work.Here's a sample form I just made using the code from Cameron's article to change the color of the Content Extent fill. The code was placed in the Name field's initialize event. Also tried in the form's initialize and docReady events.Give it a try for yourself to see what I am talking about. Do you have any suggestions??https://www.dropbox.com/s/ym3z0uxoj1xytxg/Test_Field_Color.pdf?dl=0
550
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Tried that as well, in both the form1 docReady and Initialize, and no luck. There has so be a way to do this.
543
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
Yes, I read the article first, which is where I got the syntax from in the original post.
541
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
I tried using the docReady event, but get the same results. The field color is light blue when the form opens, but only changes to green once you click on the field.
543
Views
0
Likes
0
Answers
Re: Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
OK, but how do I change the color of the field when the form opens. That's the part that is not working. Please see the original post.Thanks
542
Views
0
Likes
0
Answers
Set Field's Content Fill Color Beachbum2015 - Adobe LiveCycle
I have a few text fields that I want to set the background, or fill color to a different color when the form opens. I want these fields (not the captions) to stand out from the others, rather than making them required fields.I tried this method with JavaScript in the field's initialize event, but the field only changes color when you enter the field. Subform_Employee_Info.Table1.Row1.Name.ui.oneOfChild.border.fill.color.value = "0,200,0"; // greenI want the new fill color to show when the form o...
4907
Views
0
Likes
25
Answers and Comments
Re: Field Highlight Color No Longer Defaults to Blue - All Forms Have White for the Highlight Color Beachbum2015 - Adobe LiveCycle
Wow, embarrassed to admit that I overlooked this extremely obvious button in Form Preview mode....Time to go home......
205
Views
0
Likes
0
Answers
Field Highlight Color No Longer Defaults to Blue - All Forms Have White for the Highlight Color Beachbum2015 - Adobe LiveCycle
I'm using ES4, and suddenly, all of my forms lost the default field highlight blue color. All fields appear white. I rebooted my system, and still the same result.I also opened a few forms in Reader, and even though the field highlight color is set to Blue in the Options screen, the fields still appear in White.Any idea as to how I can resolve this issue?Thanks!
400
Views
0
Likes
1
Answers and Comments
Re: Date field to populate day Beachbum2015 - Adobe LiveCycle
Radzmar,I got it working. My fault. I did not adjust the date format to match the display format of the First_Day date field.Thanks again!
270
Views
0
Likes
0
Answers
Re: Date field to populate day Beachbum2015 - Adobe LiveCycle
Radzmar,Thanks for the reply. I tried your suggestion, but it doesn't work quite right. I selected 8/20/15 as the date in the First_Day field, which is a Thursday. In the screen shot below, you can see that the script started with Monday, and it started with the second field, instead of the first. What do you think?Here's a link to the form: https://www.dropbox.com/s/6tvb11ch0q9lnha/expense%20report%20v1_1%20-%20lc%20original.pdf?dl=0Thanks again for your help!
262
Views
0
Likes
0
Answers
Re: How to sum numeric fields based on a value in a text field - Expense Report Beachbum2015 - Adobe LiveCycle
Karan,Your solution works great!Thank you very much for taking the time and effort to help me resolve this challenge. That's exactly what I needed.Dean
311
Views
0
Likes
0
Answers
Re: Date field to populate day Beachbum2015 - Adobe LiveCycle
Hi Radzmar,I always enjoy and learn from your posts!I have a slight twist to the day of week issue that you resolved above. I have a date field called "First_Day", and seven text fields, one for each day of the week. I can get the above to work on the first text field, but what I want to do is change the date that is evaluated to First_Day + 1, First_Day + 2, etc.My goal is to enter or pick a date in the date field "First_Day". Then, use that date to extract the day of week for each of the seven...
256
Views
0
Likes
0
Answers
How to sum numeric fields based on a value in a text field - Expense Report Beachbum2015 - Adobe LiveCycle
I'm working on an employee Weekly Expense Report that contains a list of expense amounts, and each can be marked as a company or employee paid expense. There are two fields on the form that need to show the totals for Company and Employee paid expenses. There are seven columns for amounts, one for each day of the week. The Expense Code text fields are called "Exp1" through "Exp7". The Amount numeric fields are called "Amount1" through "Amount7". The fields under each column share the same name. ...
702
Views
1
Like
2
Answers and Comments
Re: How to get the name of a subform in a script? Beachbum2015 - Adobe LiveCycle
Hi Magus069,No luck adding the last if statement shown above. Actually, the subform name is Door_Subform, which I changed, and it looks like the derived subform name is not matching what is specified. I have an if statement not shown above that evaluates if nChk is < 3, then display an error message. When I check off more than three boxes, I still get the error that not enough boxes have been checked. So it seems that vNode.nodes.item(i).name may not be grabbing the correct attribute (subform na...
210
Views
0
Likes
0
Answers
How to get the name of a subform in a script? Beachbum2015 - Adobe LiveCycle
I have a script that I'd like to use to count how many checkboxes are checked in a particular subform. Problem is that I have several subforms with checkboxes, and I only want to evaluate checkboxes in a certain subform. The following script works, but again, looks at all checkboxes on the entire form.What if statement would I need if I wanted to limit the function to only work on the subform named Employee_Info? I just can't figure out how to specify a subform name and compare it to the subform...
559
Views
0
Likes
3
Answers and Comments
Re: Problem trying to make a LC Designer ES4 form "Reader Extended" in Acrobat XI Pro Beachbum2015 - Adobe LiveCycle
Although I did not find a cause for the errors, I did find a workaround in my case.This only happens when running the Javascript Debugger in Acrobat XI Pro. If you turn it off, you can Reader Extend the document. If you turn it on, you have to cycle through all of the debugger errors/warnings using the arrow button in the top left corner of the debugger window, then close that window. Still not sure what the errors are for, but at least I got the form to work.
139
Views
0
Likes
0
Answers
Likes from