Hi 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?
Hey
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.
Does 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.