Forum Academy Marketplace Showcase Pricing Features

Text field multiple entries - Extract the position of an element to use as a number

Hi everyone! I’m afraid it will be a bit difficult to explain but I’ll do my best.

I have two tables (image 1 and image 2).
The first represents a group with its participants while the second represents the reservations made by each individual player.
I would like a number to be automatically created that matches the player’s position in the “Player Name” field of table 1 when a reservation is made.

If for example the player’s name is in third place I would like the player to be assigned ID 3 when making a reservation.

Thanks everyone for the help!

This topic was automatically closed after 70 days. New replies are no longer allowed.