I am trying to connect two tables. Table 1 is a user table. Table 2 is a payment table (we need to do this outside of Knack because Knack does not allow monthly recurring payments). Table 2 is populated via Zapier.
The problem is that the connected field cannot be written to via zapier.
Anyone have any ideas about how to get the user name into the connected field? Can it be calculated?