Hi, How can I update a field based on values from other fields in real time?

(1) Share

Report

Posted on by Ollie_mcerl

Hi,

I want to update the field Annual Salary, see below. The value comes from a SP list which has a salary beside Grade and Scale (other 2 fields on the page).

Ive added in the default function for the field but when I run this and change the values in the other 2 fields (Dropdown1 and Dropdown2) nothing happens.

Do all these fields need to be within a form or is an OnChange function required?

Any help appreciated.

Ollie

Categories:

General

All responses (1)

Answers (0)

Suggested answer

FLMike 26,162 on at

Like (0)

Report

Hi, How can I update a field based on values from other fields in real time?

Hi

1. Make sure that the correct Field is bound to the Text box. (that its not blank)

2. Make sure that you are not getting any errors (if it errors out it will not show anything)

3. Manually verify that what you are putting in matches.

You are doing a lookup, so you should be able to easily do this

Add another label.

In the Text do not take the values from the dropdowns/text instead hard code it

LookUp('Salary Information', Title = "DP" And Scale = "2")

Or

LookUp('Salary Information', Title = "DP" And Scale = 2)

If Scale is a Number then make sure to convert it to a number, OTHERWISE if you put in a string, it will essentially fail, but not always tell you.

If you are unsure then put 2 more labels, and put one with a number 2 and one with a string 2 and see which one errors out.

If it does NOT show you any data, then you know its an issue with your data in the back end.