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

Speich4fun
Speich4fun
Offline

Badges

Badges
10

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
45

Discussions

Discussions
0

Questions

Questions
15

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Speich4fun
Customize the badges you want to showcase on your profile
Sum fields based on dropdown field - Adobe LiveCycle 13-10-2014
Hey sorry I haven't touched this in awhile.I have an expense report and a dropdown for category. I need to then sum the expenses based on that dropdown.Something like:If ExpenseDesction[n] ="abc" or "bca" or "cba" thensum ExpenseAmount(n)Else sum ExpenseAmount(n)Seems super simple.

Views

258

Likes

0

Replies

1
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
Yes. There is the "Total" field which gets the $=0 but I added "holiday" to total just holiday hours. So I took your formula and added a bunch elseif statements. I can post my final formula later as now I am out of the office. Best Regards,Benjamin Speich Customer Service SpecialistMentice Inc.Cell 312-504-8820

Views

350

Likes

0

Replies

0
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
Oh sorry yes. I guess i need to go get lunch. I have a "Total" column and then a a break out section of what the the hours are as monday can have 3 hours of Vacation and 5 hours of regular, so i just had to tweak the if statement and yes replace the $=0 with what i wanted.

Views

276

Likes

0

Replies

0
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
So I have a Total Field that on the calculate event i have:Sum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)However when i add your if statement:if (Activity == "Holiday")then Holiday.rawValue = Sum(Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) else Holiday.rawValue = 0endifThe total field no longer totals anything UNLESS I choose holiday for the Activity field.... Any idea why that is?

Views

278

Likes

0

Replies

0
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
Thanks for your patience. Working pretty good now.

Views

275

Likes

0

Replies

0
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
So i switched to FormCalc and got this to workfor I=0 upto Activity.nodes.length - 1 step 2 doif (Activity[I] eq "Holiday") thenHolidayHours.rawValue = Monday[I] + Tuesday[I] etc...endifendforProbelm is I can't figure out in what even to place it so it is updated everytime the user edits any of the hours.

Views

276

Likes

0

Replies

0
Re: Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
The script is on the Calcuate event of the the "total" field so as the add hours on differnet days the total will change.So what i am trying to do is run through the different activity fields and find with column is "Holiday" if it happens to be Activity[5].rawValue = "Holiday" then I want the totals for Monday[5].rawValue, tuesday, wednesday etc.

Views

276

Likes

0

Replies

0
Adding values from mulitple arrays in a for loop with if then statement - Adobe LiveCycle 11-01-2012
So I have a table set up and need to add up the hours for specific activities.I have Activity() as an array of drop down boxes with things like "holiday, regular, vacation, etc"Monday(), Tuesday() etc, are numeric field arrays.and i am trying to popluation totals from the differnet Activities.Using Java like this and it doesn't seem to be working:for (var i = 0; i < 12; i++) { if (Activity[i].rawValue = "Holiday"){ $.Value = Monday[i].value + Tuesday[i].value + Wednesday[i].value + Thursday[i].v...

Views

3.1K

Likes

0

Replies

10
Re: Populating days of the week from user Selected date. Timesheet style - Adobe LiveCycle 11-01-2012
This is definately a big help and on the right track. However I am having issues with the focus. If i choose NOT a monday i get stuck in a sort of loop with the message.I will keep trying to fix this, but my other option would be to create a dropdown box that is populated by all mondays for the current year. Anyone have any suggestions on that?

Views

223

Likes

0

Replies

0
Populating days of the week from user Selected date. Timesheet style - Adobe LiveCycle 10-01-2012
So I haven't touched Adobe or Java in over a year and am having trouble remembering a few things.I have a weekly timesheet I am editing and am having some issues.1. The User is to select the start date first, however i only want this to be a monday.2. This date will then populate the columns with the day and date in this format "Monday, Jan 9"For some reason I cannot get the fields to populate the way I want. Any help would be appreciated.

Views

1.4K

Likes

0

Replies

4