'Write to' is limited

I am trying to make a tool for people to put together a team of people, by choosing a person to go with each position. Currently, I have a table with each person and what position they can be chosen for, which is the source for the choice component.
Here’s the issue: when I choose what collumn to write to, the only options I’m given are the collumns from my ‘People’-table. But then I’d be overwriting my data!
I want to write the choices to a second table, but that table isn’t an option to choose for ‘write to’.

Hello.

  • ‘Write to’ writes to the table that is the source of the tab/screen.
  • The source of the choice is any table in your project.

Have you tried creating two separate tables, one with the choices and one where you will write to?

2 Likes