Retrive data to update record (like SQL JOIN)


I have an application where i need to fill table column with data from another table.

Here an example:

Table A

Column A
Column B

Table B
Column B
Column C

I need to search in Table B using a non ID field (Column B) that is present in both table. In the end i have to copy Column C into Column A

How can i do it inside a trigger?


Take a look at the knowledge base article for modifying tables: How To Modify Tables Within the App Editor | Tulip Knowledge Base - Support for Building Operations Apps

I think what you’re looking for is under “Loading Existing Records” if I understand your case correctly. Especially the section on using a variable in a trigger.