Need a form field (lines verified) to return a value.

Forum|Forum|3 years ago
July 11, 2022
3 replies
670 views

I need a field (lines verified), to show if there is data in a group of other fields. i.e 5 fields, only three have data. I need the lines verified field to show 3.

Hope I explained somewhat

Yes, I am new to scripting

TIA

JavaScript

This topic has been closed for replies.

Correct answer try67

You can use this code as the custom calculation script of the "lines verified" field to do it (just adjust the field names in the first line):

var fields = ["Text1", "Text2", "Text3"];
var totalFilled = 0;
for (var i in fields) {
	if (this.getField(fields[i]).valueAsString!="") totalFilled++;
}
event.value = totalFilled;

try67

Correct answer

Community Expert

You can use this code as the custom calculation script of the "lines verified" field to do it (just adjust the field names in the first line):

var fields = ["Text1", "Text2", "Text3"];
var totalFilled = 0;
for (var i in fields) {
	if (this.getField(fields[i]).valueAsString!="") totalFilled++;
}
event.value = totalFilled;

A

Alan25205326ctc7Author

Participant

Hi ,

Thanks for the sript.

I really need to learn this.

Thanks again I appreciate this.

ls_rbls

Community Expert

You need to be specific about what exactly do you mean by verified.

Are you trying to perform anarithmetic calculation that shows the total in another field ? (for example)

If yes, you can use the built-in calculating features or employ a JavaScript script.

Otherwise, please describe in more detail what type of values are contained in those text fields (i.e. names, numbers, fractions, decimals)

A

Alan25205326ctc7Author

Participant

Hello and thanks.

This document is like an invoice; a list of 10 items each with a field for quantities. On the invoice there is a field that needs to verify if there is a quntity in any or all of the quantity fields, not a sum only if there is an entry.