Error: does not allow new entries. I'm not trying to Add, only Update.

AppSheet AppSheet Q&A
1

Hello,

I am trying to update a record in a table using a form, but I’m getting the error: does not allow new entries. I have no doubt that the id I’m testing with exists in my database and I’ve set my table to only allow updates. In addition, the only field I want the user to fill out, “Rating”, doesn’t show up in the form. I must me making a silly mistake, any help is much appreciated!

Form:

Rating_Form.JPG
Rating_Form.JPG362×635 16.6 KB

I have set my table to only allow updates.

PutView_Allow_Updates.JPG
PutView_Allow_Updates.JPG871×224 16.8 KB

I’ve created a behavior to pass the id from a different table.

Add_Rating_Behavior.jpg
Add_Rating_Behavior.jpg722×406 36 KB

Table columns:

PutView_Columns.JPG
PutView_Columns.JPG1099×699 88 KB

Thank you for your time!

2

LINKTOFORM is only for adding new entries. You can use LINKTOROW to get to the Form View for a specific record, but you can’t pass any values into it as with LINKTOFORM.

5 Likes
3

Ha! The hours I’ve spent on such an avoidable error, now I know. Thank you for the quick response :blush:

4

Here’s how I fixed my behavior for anyone looking.

LINKTOROW(ANY(SELECT(dbo.InspexPutView[id],[Id]=[_THISROW].[Id])),“Rating”)

2 Likes