How do I auto-refresh a calculated drop-down field when it is based on another calculated field?

Avatar

Avatar
Validate 1
Level 1
cdavis236
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cdavis236
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
cdavis236
Level 1

04-10-2017

Hello,

I have an expanding table with a calculated total. Based on that total, I am running an action that populates a drop-down menu with the correct information. However, the drop-down does not populate when the total changes but rather when the total value is selected and then exited. I cannot find anywhere that I can indicate that I would like the drop-down to update when the total changes, rather than when the field is exited. The total field cannot be overwritten, so there is no reason for anyone filling in the form to exit the field.

The fields:

Form fields visual.PNG

Sample Action:

action.PNG

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile
_Bruce_Robertson
MVP

11-10-2017

Hi

I don't think you will be able to do this with the action builder, but try this JavaScript in the calculate event of the DOFATitle field

(!Total.isNull && Total.rawValue <= 9999.99) ? "Manager" : "";

Regards

Bruce

Avatar

Avatar
Validate 1
Level 1
cdavis236
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
cdavis236
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
cdavis236
Level 1

10-10-2017

Hi radzmar,

Thank you. I have tried that, but it had no effect.

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

05-10-2017

Why you don't add a script to the calculate event of the total field?

DOFATitle.rawValue = this.rawValue < 10000 ? "Manager" : "";