how to create a “menu” type field in a particular table
No I do not mean single select, specifically I want a field in which i want to accommodate different requirements but with some value!
just like below
-> Name: “value”
I don’t understand, you could add 2 fields: one for Name and other for Contact. But I guess you want something different
Could you explain deeper?
Oh, I think some multioption field, with the capability to enter a Label and a Value for every option, isn’t it?
Something like that? You could write all that in a Single Select, and then add a formula to get the value. Also, you could have only the labels in the options, and automate it with Zapier or similar.
Oh, and of course you could have the correspondant on another Table and then use Linked Record to select the item, and a Lookup to get the value.