How to link a column having formula

[sourav_kumar]

I have asked my guests to enter mobile number and name in a form.
Now in my base, the mobile number will be a unique value that will be used for linking to another table.
But I can’t link a column with a formula (concatenate) & if I convert phone-number or a text column into the linked column - then a new guest will not be able to enter data in the form but will have the option to choose someone else’s number only. Any suggestions?

[JonathanBowen]

Hi @sourav_kumar - two suggestions for you, see these posts:

Use a formula + link to another record in the same field Ask the community

Hi, I have some columns in my table where I want to use a formula but also link the data from that column to another record. Is that possible? Thanks. Tom

How do I merge submissions from multiple forms? Views

I am attempting to set up a base to manage volunteer records. Volunteers complete several forms in the registration process. I would like their submissions from the multiple forms to be automatically merged into a single record, determined by a common email address entered on the different forms. I have the base set up with the different forms set up, I just can’t figure out how to auto-merge entries. Is this possible? Any suggestions? (Though I understand a single form would make this process v…

JB