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

TarnG
Community profile TarnG Level 2
Job title here
Location here
7 BADGES
Level 2

Level 2

Learn more
Joined the community 20-07-2014 11:29:58 PM
Offline
Top badges earned by TarnG
Customize the badges you want to showcase on your profile
Re: Colour change on Calculated field
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Thanks radzmar, but I just can't get it to work It is doing the same as the original script I had - calculation formula works fine but once the colour script goes in even the formula stops working. I tried moving the colour script portion to validate event but that doesn't work either. Would it make a difference that I'm not using tables, just fields?I have other fields in the form that change font colour based on calculated result but I ended up doing them via javascript as it was a simple num=...

Views

715

Likes

0

Replies

0
Re: Colour change on Calculated field
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Thanks Josh, I did try using the action builder first because I'm really bad with code, but I only lets me do it as an exit script so it doesn't actually do the colour change unless the user tabs through or clicks in and out of that total field (which they wouldn't usually do 'coz it's a calculated field). Do you know of a way to get it do this as a calculate or validate action?

Views

713

Likes

0

Replies

0
Colour change on Calculated field
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
I have a calculated field: TotalDiff. It is the sum of amounts in repeating subforms. I want this calculated amount to display in red if it is a negative amount. I have used FormCalc as this was the only way I could figure out how to sum the amounts from the repeating subforms. I have never used FormCalc before and cannot figure out how to do the font colour change. From reading other discussion threads, I thought the following should work, but it doesn't. The sum formula works fine by itself, b...

Views

2.3K

Likes

0

Replies

6
Re: Form end user entered calculation scripts
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Thanks again jasotastic81 - Your coding works like a charm and I have a very happy internal customer who love their new form!

Views

520

Likes

0

Replies

0
Re: Form end user entered calculation scripts
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Gosh, jasotastic81, let me say sarcastically that I sort of hate you for answering this question... now I gotta at least try to make it work instead of telling them to just stick with their Excel spreadsheet version! 🙂But seriously, thank you, and apologies for the late thanks (but lucky me I've been on holidays). I will let you know how I go with this once I work through my backlog of tasks and get to this beauty of a form.

Views

476

Likes

0

Replies

0
Form end user entered calculation scripts
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
I have been asked if it is possible to create a LiveCycle form where users can click in a field, add or subtract several amounts (as they apparently can in Excel by entering a formula with the amounts, eg '=2.54+41.87+14.62'), then, in addition to seeing the resultant total, they also want to be able to see the items that were added/subtracted, ie the working out! Is this even remotely possible in LiveCycle?

Views

1.4K

Like

1

Replies

4
End user entered calculation scripts
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
I have been asked if it is possible to create a LiveCycle form where users can click in a field, add or subtract several amounts (as they apparently can in Excel by entering a formula with the amounts, eg '=2.54+41.87+14.62'), then, in addition to seeing the resultant total, they also want to be able to see the items that were added/subtracted, ie the working out! Is this even remotely possible in LiveCycle? (Or should I just suggest they keep their form in Excel? )

Views

461

Likes

0

Replies

1
Re: Re: Pop up message on email button
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Thank you so much. Perfect. And thank you for the brilliant way you presented the answer - nice and easy to follow for a newbie like me and most importantly helps me understand WHY we are doing things that way.

Views

409

Likes

0

Replies

0
Re: Pop up message on email button
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
Thank you - works great for most times I'd want to use it.Problem is, for one particular form I'm working on, I have two submit buttons, and when I use the script, even though I set it on the 2nd email button, users still get the message when they click the 1st email button (which is in a separate subform and has a different name). Is there a way I can limit the message to just one button or because it is a presubmit script, will it always appear any time the form is submitted?

Views

415

Likes

0

Replies

0
Pop up message on email button
Avatar
Give Back 5
Level 2
TarnG
Level 2

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
TarnG
- Adobe LiveCycle
I would like to create a pop up message that appears when users click on an email submit button. So far, I've tried to create a message using the Action Builder but that displays the message after the user has already been taken into their email and they end up sending the form off before they see the message. I would like the message to appear BEFORE the user is taken to their email package. Is there some scripting I can use in the presbumit event that ill enable me to do this?

Views

967

Likes

0

Replies

4
Likes from