I am trying to bring back related data (i.e. combine two tables), much like numerous topics already on the forum. I have been through them all and cannot see how to get it working in codeless. I have so many questions but am going to start with a basic one because I am falling at the first hurdle…
Two tables; ‘User’ and ‘UserWorkouts’. Want to bring in values from the ‘User’ table for fields such as country and city in to the ‘UserWorkouts’ table…so all 1:1 relations and both tables have ownerId (and objectId).
This is my ‘UserWorkouts’ table;
What I don’t understand is how to dynamically link/relate them. Going through manually and linking each new record in ‘UserWorkouts’ is…crazy
I have created the basic codeless below which is working for entries where I manually populate but I get null for the others;
I have spent a few days on this (not complaining!!!) and I just cannot crack it…