I have an existing table that uses an [ID] to reference a person's [Name] from another table. I want to bring the name of the person into the [ID] table as I'm having issues with VC's not behaving themselves.
I can get this process to work on a row-by-row basis with a data action:
SELECT(Onboarding[Associate Name], [Transporter ID] = [_THISROW].[Transporter ID], TRUE)
How can I run a data action that will check all 997 [ID]s already in the table and match them to the correct [Name] from the other table?
I have found some solutions by searching but they seem to apply to an older version of AppSheet.
LinkedIn
Twitter
