I’m wondering if it’s possible to have a table on the front end of a page which populates from the data set it’s connected to, but also populate some columns using info from a different data set.
E.g.
Data set one has columns
user email - name - age - country
Data set two has
user email - weight lifted - rep - sets
The table would have the column for the common user email field plus, - weight lifted - reps - sets. Could I also pull in the age from data set one into this table (a new age column) automatically based on the user email?