API Endpoint(s) and/or Zoom API Event(s) Zoom Tables (Data Structure & Logic) Note: This inquiry is related to the fundamental data logic of Zoom Tables, which affects our planned automation workflow via API.
Description Hello, I am currently building an internal “Leave Management System” using Zoom Tables. I have encountered a blocker regarding the dependency logic between columns.
My Goal: To calculate “Remaining Leave Days” automatically using a Formula.
- Logic:
Total Leave Days (Number)-Used Leave Days (Rollup)
Current Setup:
-
Table A (Employees): Contains
Total Leave Days(Number). -
Table B (Requests): Contains individual leave requests.
-
Relation: Table A and B are linked.
-
Rollup:
Used Leave Daysin Table A aggregates the sum of days from Table B.
The Issue: When I try to configure the Formula column in Table A, I cannot select or reference the Rollup column (Used Leave Days). It seems that referencing dynamic values (Rollup/Relation) inside a Formula is currently restricted.
Questions:
-
Is this restriction an intended architectural decision to prevent performance bottlenecks (e.g., cascade updates) or circular dependencies?
-
Is there a roadmap to support referencing Rollup/Relation data in Formulas in the future? (This is a critical feature for our automation).
Error: #REF! RollUp column cannot be referenced. Please review and correct the formula.
How To Reproduce Steps to reproduce the behavior:
-
Create two tables (Table A, Table B) in Zoom Tables.
-
Create a Relation column linking them.
-
Create a Rollup column in Table A that sums up values from Table B.
-
Create a Formula column in Table A.
-
Attempt to write a formula that references the Rollup column created in Step 3.
- Result: The Rollup column is not selectable/visible in the property list.