Nextcloud AIO Docker version: 1.7.0 (Nextcloud 24.0.3)
OnlyOffice Connector version: 7.5.4 (OnlyOffice Container version: 220.127.116.11)
I like how there are formulas for table cells, however, it would be nice to be able to utilize formulas with form text fields. Using the “Key” property attribute, this might be able to be used like a bookmark. That way if a person setup a formula for a table cell to reference certain filled text fields, it could add up the number in those fields.
In the example below, hours filled in for certain jobs in a day can be summed up in that day:
And at the end, the total for all days could be summed:
Though when I tested the table formula, it only ran when the user clicked to save the formula. It did not actively update if other cells were updated.