Select a single table from multi to write data to

[Davgin]

I am trying to create a notes app. The app will have several tables behind each one is a unique google sheet for example: personal notes (sheet1), work notes (sheet2), study notes (sheet 3).

I want to be able to select the destination table when I am creating a new note.

How can this be achieved?

[TeeSee1]

Create a temporary Data Input Table consisting of two columns, ID, NOTE(LONG TEXT) which has one record and create three actions of Add a new row to another table..., each corresponding to one of the three tables.

You can show the Detail view of the Data Input table with Quick Edit enabled and after editing the note column, press the button that copies the note to the desired table.

To make things even simpler, I would just put everything in one table by adding a Note Type column (ENUM). You can create three slices showing each category of notes to see them separately.

[Davgin]

I found a different way to achieve what I wanted with a single table and automation to copy data.

Thanks!