Tengo una aplicacion de contabilidad en appsheet, en una vista tengo el libro contable donde hago todos los registros.
Me gustaria crear una fila al final que sume el total de lo que este seleccionado en ese momento, se que con la formula de sum(Select()) se puede pero como se agrega la fila hasta abajo para que esta sea dinamica y vaya sumando lo que se vaya filtrando.
The Table Structure of Appsheet is such that each new entry made in Appsheet is added as a new row in the Table. Hence you cannot have a row which has a separate behaviour (TOTAL) compared to other rows. You can you virtual columns to get the Total of desired columns in the table
Maybe I could solve it in the following way (I haven’t tried it):
In another table with a single record (I always use a configuration table where I keep these things), create a field that is TOTAL. As it is a single record, its value can be obtained with ANY(table[TOTAL])
Create a bot that is activated every time you add a record and whose action is to take the TOTAL field and add what corresponds to this record.
Don’t forget to create an action that recalculates the TOTAL taking all the records (in case the calculations ever go wrong).
If you try it like this and succeed, I would like you to tell us about it.