Skip to Main Content
Status Future consideration
Categories Features
Created by Guest
Created on Sep 18, 2024

Enhance the advanced functions in Aha! to list unique values from a string field

What is the challenge?

The primary challenge we are facing is the presence of duplicate values in the lists generated by our custom field formula. We have a custom field in our feature layout that pulls values from a specific column in a related custom table for each feature using the formula:

What is the impact?

Duplicate values in custom field and the feature view looks messy

Describe your idea

Current Scenario:



In our feature layout, we have a custom field that pulls values from a specific column in a related custom table for each feature. The custom field formula we are currently using is:



=self.custom.cpi_test_link_cp[].custom.lob_jj



While this formula successfully retrieves the required values, it results in a list that includes duplicate entries. These duplicates can lead to confusion and inaccuracies in our data analysis and reporting.



Proposed Enhancement:



We propose the addition of a built-in function that can be used within custom field formulas to remove duplicate values from the list. This would streamline our data and ensure that each value is unique.



Example Syntax:



An example of how this function might be integrated into our existing formula could be:



=unique(self.custom.cpi_test_link_cp[].custom.lob_jj)


PFA for sample screenshot.

  • Attach files