+9Hi there,
In order for me to create a junction table. How can I get certain data from one table to another? I am looking to get all submissions, team, month, points awarded.
I would like it to move over these fields and when a new recorded is added for it to add those as well
Is this possible?
+28Hey
Would you mind providing additional information (screenshots, real use case, and details) to further understand?
Most probably you’ll want to look into linked record fields and lookup fields.
+31Does this look right? This’ll show you the points for each team for each month and you can see the base here
If so, the idea is to create a formula field that’ll create a unique value for the table you’re trying to get data from, and then use an automation to paste it into a linked field to the new table:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.