Skip to main content
Question

Auto correct fields based on formulas?

  • June 6, 2023
  • 0 replies
  • 74 views

I have data that is for the same company but is manually put in and is sometimes misspelled and not the same way it is entered. Is there a way for QB to look up the misspelled entries and autocorrect that field to be the correct spelling of the company and therefore match all the entries up to the one correct company? Can this be done with a formula?



------------------------------
Amy Migliore
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    Spell check auto correct is a tough ask.  Is there some way you can control the data entry by making the users select off a list that comes from a relationship. 

    If you trust the users and you do it via our relationship then you can allow the users to add new choices to the master table if they don't find the company they want on the drop-down list.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement