I can create a new row and it saves correctly etc. However, I'm pulling my hair out working out how to fetch this new row id and add it as an 'index' in another table we use in our company table.
Am I missing something obvious to fetch this new id?
The process for creating new rows in a database can vary a bit depending on the resource. This is a great question to ask though! Would you mind sharing a bit more about the DB you're using and how you're adding rows to it with Retool?