Adding the capability of multiple users doing different calculations (with different input values) at the same time using the same doc is surprisingly simple with Coda. You don’t need to duplicate and then filter the rows for each user. Looks like if you have dependency on
User() anywhere in a formula’s dependency graph, it will only calculate that on the client side and never share the value with other users.
See how two instances of Coda show completely different numbers in the same table without clashing:
Drawback: in this setup Automation most likely will see an empty table, since automations by default are run by Automation Bot system user. You can set up automations to run as any actual user though.
Also, need Codans like @Krunal_Sheth to confirm if my low-level assumption is true: values calculated by formulas dependent on
User() anywhere in dependency graph don’t propagate to other connected clients and don’t get saved to snapshots (i.e. are always calculated on the client) — aka volatile functions