I want to update the "Member" table(precisely Photo Column) using a form submission from the "Input" table in AppSheet. Here are the steps I've taken:
I created a new action called "Set Photo" in the Input Table. In this action, I set up the type of action to perform as "Set Column," specifically setting the Photo column to: LOOKUP([_THISROW].[Photo], "Members", "Member_ID", "Photo").
Next, I created another action in AppSheet called "Set Photo | Member" applied to the Member Table. The type of action was set to "Data: execute an action on a set of rows." The referenced table was the Input Table, and the referenced action was the previous action "Photo Set."
However, when I tried to reference the rows using this expression:
Select(Input[Photo], [_thisrow].[Full Name] = [Name])
It gave me an error saying, "The value '=Select(Input[Photo], [Name] = [_thisrow].[Full Name])' of data action 'Set Photo | Member' does not match the expected type List or its expected type details"
How can I solve this issue?
LinkedIn
Twitter
