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

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

cdavis236
Level 1
Level 1

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

3 Replies
radzmar
Level 10
Level 10

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

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

cdavis236
Level 1
Level 1

Hi radzmar,

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

_Bruce_Robertson
Level 10
Level 10

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