OBJECT NAME Calc

[Dr.Gopala krishnam raju AMBATI]

is there any way to enter calculation into the object name of the field

table name - CONTACTS

filed name - CLIENT NAME

name of the object to be - entered clients name is <<contacts::client name>> in object name filed is it possible

trying but not getting the result is there a way or its impossible  hope u understood

[OlgerDiekstra]

It would be extremely inefficient to have the client's name as the field name. How would you go about adding a new client? You'd have to create a new field for each. If, like in my case, you have 350,000 clients/customers, that would result in 350,000 fields in the one table. You would also have to give users training and access to add fields and ensure they name them correctly, and educate them on how to deal with duplicates.

Searching would be a nightmare, layouts and scripts would become a disaster.

The way to do this is to create a field called 'Client Name' and store clients names in that field. That's generally how databases work.

[Dr.Gopala krishnam raju AMBATI]

18 minutes ago, OlgerDiekstra said:

It would be extremely inefficient to have the client's name as the field name. How would you go about adding a new client? You'd have to create a new field for each. If, like in my case, you have 350,000 clients/customers, that would result in 350,000 fields in the one table. You would also have to give users training and access to add fields and ensure they name them correctly, and educate them on how to deal with duplicates.

Searching would be a nightmare, layouts and scripts would become a disaster.

The way to do this is to create a field called 'Client Name' and store clients names in that field. That's generally how databases work.

is there a way to enter a calculation in object name is my question ????

[OlgerDiekstra]

If you want to have the actual field name as a calculation, then no, that's not possible afaik. On the other hand, if you want to have the a fieldname called 'client name' and have the value calculated (ie a calculated field, or a text field with an auto-calc), then yes, that's possible. How to do the calculated field would depend on where the info comes from. If it's pulling related data, then a calculated field is best, if the data resides within the record (ie contacts::firstname & " " & contacts::lastname) then an autocalc would be best.

[comment]

2 hours ago, Dr.Gopala krishnam raju AMBATI said:

is there a way to enter a calculation in object name is my question ????

The answer is no. The object name must be hard-coded. 

Once again, it would be better to ask about your real goal, not about the way you think is best to accomplish it - see: http://xyproblem.info/