Jump to content

Using the name of a field in that field's calculation


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

Recommended Posts

Hi,

  I've been struggling with the best way to explain this question, but here goes:  When defining a calculation in a field, is there a way to "get" the name of that field? 

For example: If I have a calculation field named "Tango10" and another field named "Tango20"  is there a way to have get the name of the field calculation in those fields such that I could do the following:

Calculation field = 10*right(getfieldname,2)

Where the getfieldname would be the function that I'm looking for and the result for fieldname Tango10 would be 100 and fieldname Tango20 would be 200?

So basically, I'd like to be able to use the name of the field in a calculation.

Thank you, and Happy Thanksgiving!

 

 

Link to comment
Share on other sites

Technically, yes. It's possible to use:

GetFieldName ( Self )

to get the name of the calculation field where this formula is evaluated.

However, I am quite certain there is a better way to accomplish whatever you're trying to accomplish by this contraption.

 

Edited by comment
Link to comment
Share on other sites

4 hours ago, metamict said:

If I have a calculation field named "Tango10" and another field named "Tango20" 

I hope you don't have fields named this way. It's a red flag that this should be related records instead. 

Link to comment
Share on other sites

This topic is 1583 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.