April 5, 200718 yr 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
April 5, 200718 yr 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).
April 5, 200718 yr Author 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.
April 5, 200718 yr 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).
Create an account or sign in to comment