Jump to content

OBJECT NAME Calc


This topic is 1899 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 ????

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 1899 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.