Function to identify field?

[David Jondreau]

Is there a way to identify the a calculation field from within itself?

I had this idea for a recursive custom function that would concatenate the values from all the indexable fields in a record (in order to search on).

I was thinking of using it in a calculation field, but don't want the calc to reference itself (making a circular argument).

I'm looking for something like Get(CalculationRepetitionNumber) but for the field ID itself.

Thanks

[comment]

I don't think so. You could pass the field name as a parameter to your function (the field to exclude), but it would need to be text (IOW, if you rename the field, the formula will not automatically update).

[David Jondreau]

What about a way to grab the literal calculation text referenced in a calculation field? That way I could test with PatternCount for the name of the CF.

So if I have a field:

CalcField = "Calc" & "Field"

I want the result of " "Calc" & "Field" " (Not "CalcField"). I've been playing around with Quote, Evaluate, GetField but can't get it too line up.

[comment]

I think the closest you can get is the FieldType() function.

Seems like a lot of work for something that could be achieved simply by concatenating the fields that are worth searching (usually not than many, and they don't change too often).