How to get contents of one field into another and edit it

[Victor Warner]

In a form I have two number fields:

1. Time Spent (with number format set to Time (HH:MM));and
2. Time Charged For.

For the second field (Time Charged For):

(a) I would like to show the value entered into the first (Time Spent); and
(b) be able to change the value if necessary.

For example,

If I enter 00:12 in Time Spent, that value is automatically displayed in Time Charged For, but I can then amend 00:12 to 00:09.

(a) is the easy part (using a Calculation field type), but a Calculation field type is not editable.

Is it possible to do this with Tap Forms?

[Brendan]

Hi Victor,

Yes. You can do this with a Script field.

In a Script field when you use the record.getFieldValue(field_id) function, Tap Forms begins watching that field for any changes made to it. It executes the script if the value of that field changes.

So by adding a Script field, you could have Tap Forms copy the value from your Time Spent field into your Time Charged field. Now normally a Script field will display its contents in your form, but recently I added a Hide field function to Tap Forms 5.3 which will let you hide any field. So you could have this hidden Script field that’s just watching what’s going on with your form and running automatically when fields the script is watching change.

Thanks!

Brendan

[Brendan]

Oh, and to have Tap Forms copy the value to another field, you would do this:

var time_spent_id = 'fld....';
var timeSpent = record.getFieldValue(time_spent_id);
var time_charged_id = 'fld....';
record.setFieldValue(time_charged_id, timeSpent);
form.saveAllChanges()

[Victor Warner]

Brendan,

Thank you for the explanation.

I have tried to follow the approach you outlined. But it appears not to work: the script field and the Time Charge For fields are not updated.

I created:

1. Time spent Field = type: number
2. Time spent to time charged for Field = type: script.
3. Time charged for Field = type: number.

The Time spent to time charged for Field only shows a “1” regardless of what I put in the Time spent Field and the Time charged for Field is not updated.

Attached is the Form. Could you let me know where I have gone wrong?

Attachments:

You must be logged in to view attached files.

[Brendan]

Hi Victor,

You put quotes around one of the variable names:

var timeSpent = record.getFieldValue('time_spent_id');

That’s wrong because it treats the text 'time_spent_it' as the value instead of using time_spent_id as the variable to get the value from.

So it should be:

var timeSpent = record.getFieldValue(time_spent_id);

So just remove the quotes and it will work.

[Victor Warner]

Brendan,

Thank you very much! Problem solved.

I will hide the script field (as you have suggested), but just to know for the future, will that script field always show a ‘1’ regardless of what is in the other fields?

[Brendan]

Yes. The 1 is just that it was successfully ran. You can have it return something else if you like.

[Author]

Posts