Where can I find information on the field type Tables?
I can make one but the auto increment does weird things.
I have numbers in a col and I can see the total, but where can I put it where I can see it?
How do I add the total of a col in the Table to the previous record total if it isn’t in a field?
Youtube didn’t even come up with an instruction.
The manual doesn’t seem to talk about it and searching only gets the properties.
There’s no function to get the “previous record” in order to get a total. The previous record can change depending on what your sort ordering is.
But you can click the little Sigma ∑ button to show the calculation row so you can see the grand totals for the values in a Table field. What do you mean where can you put it so you can see it? It’s at the bottom of the Table field.
Do you mean you want the total for that column to appear in the parent form somewhere in a separate field? If so, you can add a Calculation field or Script field to compute that value and display it in the parent record.
The fields that are available to you are mostly the same as the fields that are available to you in a regular form. But only the more simple field types and not the complex ones like Link to Form, Table, File Attachment, etc.
.
