Skip to main content

Case insensitive in linked fields

  • December 1, 2022
  • 2 replies
  • 55 views
A
Forum|alt.badge.img+4
  • arruga
  • Participating Frequently

Hi there

Is it possible to make a linked field case insensitive?

If in a source table I have "Blue", and in another table a record is created with "BLUE" in a linked field (response from a user form entry, which I have no control over... this is a simple example, I can't do a select field question in the form, it must be user text), I would like the "BLUE" entry turn into the "Blue" that already exists in the source table, rather than creating another "BLUE" record in the source table. How to best go about it?

Many thanks!

    2 replies

    Matthew_Lanni
    Forum|alt.badge.img+18

    There may be a way to have this happen automatically with scripting, but I can't speak to that if so.

    If you wanted to go the no-code route, perhaps you could set up a formula field that would capitalize words however you wanted, regardless of the input. Then, you could use that field to run the deduper extension every now and then to merge the varied inputs into one record.

      A
      Forum|alt.badge.img+10

      There may be a way to have this happen automatically with scripting, but I can't speak to that if so.

      If you wanted to go the no-code route, perhaps you could set up a formula field that would capitalize words however you wanted, regardless of the input. Then, you could use that field to run the deduper extension every now and then to merge the varied inputs into one record.


      Yes, standardizing words with a formula column ( UPPER() or LOWER() ) makes your life easy. Then you can set an automation which gets the standardized value of a new record and pastes it into the linked record field.
      So, a user types YeLLOw in column1, but you have "yellow" in the second table, so create a formula column with the formula of LOWER(column1) called formulaColumn1. Then create an automation, with trigger "when formulaColumn1 is not empty", then action is "Update Record", updated the linked record cell with the value comes from formulaColumn1 which is yellow, since LOWER() formula converts "YeLLOW to "yellow".

        Terms & ConditionsAccessibility statement