Adding up the number of cells of a default table means that the total number of rows automatically populates as you're adding more rows in your default table. Default tables don't have a fixed number of rows and you add more as you fill out your form. You may opt to have an auto-numbering system in your default table (automatically labels numbers as you add rows), but in this case we're just going to total the count.
To start, navigate your cursor to the left tab and choose 'Default table' under 'Table'. Design your data table as required for your form.
Navigate your cursor again to the left tab and choose 'Prefilled table' under 'Table'. this prefilled table is designated as the table that contains your display cell. The display cell contains the formula that counts your total rows in the data table (Default table). Designated a display cell, and make it into a 'Formula field'.
Use the formula on the display cell,
=COUNTA(Source_Table!Column:Column)
where:
Source_Table - is the data table (Default table)
Column - the column that you're going to count the number of rows.
Note: Make sure that the Column is a column where a value is surely to contain. The COUNTA() only counts the number of values in a range.
For example:
Given that you're looking for the total logs in an Excavation Pre-Entry Log in a month. There are multiple entries per week so you use a default table (Table1) for the log.
(Date Field) | (Time Field) | Inspector (Text Field) | Comments (Text Field) |
In your display table (Table2; prefilled table) and display cell (cell B1), use the formula to count the total number of entries/logs in a month:
=COUNTA(Table1!A:A)
Number of entries: | =COUNTA(Table1!A:A) |
Note: We're using Column A in Table 1 as our Column count because it is for sure to have an entry.