Why does Grid Edit take me to a different report?
I created a new report. When I click "Grid Edit," instead of being the same report with the same columns in the same order, I'm taken to a completely different report. Any ideas why? Thank you!! ------------------------------ Amber Gartner ------------------------------
Records won't save from Grid Edit because of Unique Value Field
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 ------------------------------
