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.
Juggernaut

Featured Replies

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

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).

  • 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.

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

Important Information

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

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.