Runactions() with lookup value

2

Coda doesn’t work that way. You cannot put a formula text in a cell and then have some other control evaluate it; there’s no dynamic evaluation. *

You have to put all the code in your Action formula.

If you need some dynamic behavior (e.g. execute one thing for one status and another thing for another status), you can still use If(), SwitchIf(), Switch() etc in your action formula, e.g.

If(
  thisRow.IsAdmin,
  Polls.AddRow(
    [Admin template], thisRow.Template,
    ...
  ).Activate(),
  Polls.AddRow(
    [My template], thisRow.Template,
    ...
  ).Activate()
)
  • — There is actually a way to dynamically substitute actions in a button with a hack, but it is extremely unsafe, can break your doc beyond recovery at any Coda update, and requires deep knowledge of how Coda works internally, so I totally discourage it. I’m just leaving this here for the sake of completeness of the answer.
1 Like