When adding an item, automatically add Row-ID to another table

Hi community,

I’m building a CRM where I have project data and financial data for projects in two separate tables. Reason for that is that I want only a subset of my users to have access to financial data.
The finances table has a project_id column, which refers to a project’s row ID.

What I’m trying to achieve is that whenever I add a new project, I want to automatically make a new entry in my finances table, containing the row ID of the newly created project.

Is there a way to do that automatically?

You should be able to do that with an on-submit action to write a new row to the Finances table, assuming you’re using a form to populate a new project.

1 Like