Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

OBJECT NAME Calc

Featured Replies

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

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.

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

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.

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/

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.