Action to set rows in another table won’t set reference column

AppSheet AppSheet Q&A
1

I’m trying to create an action that creates a new row in another table and sets each column to the same values as the first table. All of the columns work except the table ID column and I think this is because it is a reference type in the second table and just text in the first.
Is

45754672-0C4C-4241-8DBB-B64BB25A040F.png
45754672-0C4C-4241-8DBB-B64BB25A040F.png2048×1536 298 KB

there a way around this? I need the ID to be filled in by this action so that it will create a relationship to the first table.

2

Can you show more details? What is [Lecture Note ID]? Why are you wrapping it in LIST() and ANY()? That seems wrong. What is the base type of the Ref column?

1 Like
3

The base type of the ref column was just text. I managed to fix this with a LINKTOFORM() filter Expression :+1:t5:

1 Like