Discussions

Expand all | Collapse all

Display message when field in not unique?

  • 1.  Display message when field in not unique?

    Posted 08-08-2017 09:39
    Hi!
    I have a field that should be unique. It all works fine, and it displays the error message from Quickbase saying that the field is not unique when it isn't.

    But, my users are new to Quickbase, and frankly said, will not understand the mistake causing the error. (I already changed the field name to a line explaining the problem, but I don't think this will work in practice). Also, the unique field is in the beginning of a long form, so I don't want them to spend all that time to find out it cannot be saved.
    Is there a way to display a message when the value in that field changes to a non-unique value?


  • 2.  RE: Display message when field in not unique?

    Posted 08-08-2017 09:48
    The only way to test for uniqueness is to try to save.

    One solution is to have the Add Form be a super mini firm and instructions to users to say to save the super mini form as step , then edit to complete step 2.


  • 3.  RE: Display message when field in not unique?

    Posted 08-08-2017 09:59
    Thank you for thinking along, this would make it a little more userfriendly.