Getting Started

 View Only

Records won't save from Grid Edit because of Unique Value Field

  • 1.  Records won't save from Grid Edit because of Unique Value Field

    Posted 01-16-2020 17:32
    I have a formula field called [Export ID] which is based off of the Record ID#.  I had set this field to be a unique value.

    When I try to create multiple records via a grid edit report, it will give me an "Unable to Save Changes" error.   The problem
    is these tentative records don't have a Record ID yet because they haven't been saved.  Since there's no Record ID yet, the [Export ID] field has the same value for each, hence not unique.  If I could save the record, the [Export ID] would be unique but I can't get that far.  If I save one record at a time, it works fine.

    I was looking for a way to create a temporary unique value until the Record ID is created.  There can be situations where there is nothing initially different between the records where I could create some sort of unique formula code. I was looking for a way to generate a random number to temporarily create a code but couldn't find a formula function to do this. Any thoughts would be appreciated.​

    ------------------------------
    Carlos Santiago
    ------------------------------