since ‎20-07-2014
‎10-12-2019
TarnG
Level 1
Re: Colour change on Calculated field 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=...
534
Views
0
Likes
0
Answers
Re: Colour change on Calculated field 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?
534
Views
0
Likes
0
Answers
Colour change on Calculated field 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...
2134
Views
0
Likes
6
Answers and Comments
Re: Form end user entered calculation scripts 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!
431
Views
0
Likes
0
Answers
Re: Form end user entered calculation scripts 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.
387
Views
0
Likes
0
Answers
Form end user entered calculation scripts 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?
1262
Views
1
Like
4
Answers and Comments
End user entered calculation scripts 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? )
376
Views
0
Likes
1
Answers and Comments
Re: Re: Pop up message on email button 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.
360
Views
0
Likes
0
Answers
Re: Pop up message on email button 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?
364
Views
0
Likes
0
Answers
Pop up message on email button 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?
909
Views
0
Likes
4
Answers and Comments
Likes from