Table Component - Looking to set a column value based on State variable

[jhill-mindex]

Currently I have a table component that I want to be able to add, edit, and delete rows. One of the columns that I need to insert into the table is an ID that I have access to from a State variable.

Any thoughts on how to do this? I was hoping I was going to be able to use a row created automation that would update the row with the ID, but it doesn't look like this is supported for external data sources (I'm using PostgreSQL).

Any thoughts or help is much appreciated, thanks!