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:
I have set my table to only allow updates.
I've created a behavior to pass the id from a different table.
Table columns:
Thank you for your time!
Solved! Go to Solution.
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.
Here's how I fixed my behavior for anyone looking.
LINKTOROW(ANY(SELECT(dbo.InspexPutView[id],[Id]=[_THISROW].[Id])),"Rating")
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.
Ha! The hours I've spent on such an avoidable error, now I know. Thank you for the quick response 😊
Here's how I fixed my behavior for anyone looking.
LINKTOROW(ANY(SELECT(dbo.InspexPutView[id],[Id]=[_THISROW].[Id])),"Rating")
User | Count |
---|---|
27 | |
26 | |
22 | |
22 | |
21 |