Jump to content
  • 0

Inserts and Grid Edit/Spreadsheet Mode



I have a Report datapage where users can insert records.  If they click the 'Spreadsheet Mode' button, they are able to easily update existing records.  This mode also seems to expose a row for adding records just like in the regular mode but entering values results in the error


"Invalid entry in one or more fields.  Roll over the error icon for information on how to correct each field"

But no fields have an error icon.  I have exposed all fields including the primary key which is set to autonumber but nothing is flagged as having an error.  The page includes some calculated fields.  The editable values entered are unique and there are no foreign key issues.


If Grid Edit does allow adding records, is there a configuration I missed?

If Grid Edit does not allow adding records, is there a way I can hide or block the extra row that is exposed so users can't attempt to add a record when in Spreadsheet Style?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...