Help

Count the number of Records in a Table using Script

Topic Labels: Scripting extentions
805 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Banks
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All,

I am using script to assign a unique ID to a household. Part of doing this includes counting the number of records that currently exist in the table that the unique ID will be assigned to. I am struggling to obtain this count.

I created a column in the table using the Autonumber function that automatically assigns a number to a new record - in an ascending manner. I then us the input.config() method to try obtain this value of the most recently created record. But I get an undefined return from this.

Any ideas on another way to do this?

Thanks in advance.

Cheers,
Ryan.

1 Reply 1

Why not use the autonumber value as the unique id? It is guaranteed to be unique.

Also, the value of the most recent autonumber is not a good way to determine the number of records in a table. If you delete any records, the autonumber will be greater than the number of records.

Did you setup the input variable in the left panel of the editor?