Using an update-only table, using form, error on save "key field is required"

[tomdengle]

I'm using an update-only table, where the user selects the record to be updated. When I attempt to save, a "key value is required" error message is returned. 

Other values I can LOOKUP when the record is selected. I can't add a LOOKUP formula to a key field. Setting an initial value doesn't help either. 

How do I grab the required key field when the record is selected, whilst keeping it hidden from the user? 

[Joseph_Seddik]

Welcome to the community!

Please read this:  What is a Key? | AppSheet Help Center 

[tomdengle]

Perhaps a screen shot will better explain. I'm attempting to update a record. The record is selected by name, via a dropdown

I think my problem lies with the Initial Value (of the Key), but as step one is selecting the record, there is no "initial value". Thoughts? 

[Steve]

There's no such thing as an "update-only table" in which rows don't already have key column values. I suspect you have described your setup inaccurately.

[tomdengle]

The only changes allowed are updates:

Every row does have a unique Key established.

When I attempt to save, I get the error. 

[Steve]

How does the user get to the form view?

[tomdengle]

The preview currently starts at the "blank" form. From there, they select a record, add some information, then save it - that's where the error occurs. 

[Steve]

Yeah, that's not going to work. They need to select an existing record first, then open that in a form to edit it.

You cannot put the user in a blank form, allow them to enter data, and use that entered data to load and edit an existing row in that same form. AppSheet just doesn't work that way..

[tomdengle]

The first thing the user does within the form is select the record. They are not "entering data" until they've selected a record to update. 

I believe the issue is: when they select the record, the ID is not associated with the selection. I can lookup other data; I cannot lookup the key. 

I tried making the name the key record,  but it Erred at sync.

[SkrOYC]

Maybe they are not going to a detail view of the record you want to edit

[Steve]

---

@tomdengle wrote:

The first thing the user does within the form is select the record. They are not "entering data" until they've selected a record to update. 

---

Not going to work, period, full stop. You're doing it wrong.

[Joseph_Seddik]

Please show all the configurations of your ID column. Thanks.

[tomdengle]

I switched the Account Name to Key, but it Erred at sync. The ID def: