Virtual column as a key

[Ekkapong14]

I'm using a concatenation of 2 columns as a key. For example I have 2 enumlist columns (product [pen, pencil, desk] and color [red, green,  blue]) where I wish the combination of these two to always be unique. This works fine but  I can't seem to edit either of these columns after the entry has been created.

Is this how AppSheet works? If so, is there anyway I can enforce the uniqueness of combined columns without nominating them as a computed key?

Thanks

[diogolupcosta]

Yes. Because actually they're key parents. I don't see the point of that. Could u tell why to set a key like this?

[Ekkapong14]

I want to make sure that a combined value of 2 column is unique. I find it convenient to set them as a key to make sure its uniqueness.

[TeeSee1]

That is how AppSheet's "key" column works and it should be that way. Keys, once created, should not be edited.

https://support.google.com/appsheet/answer/10106434?hl=en

Having said that if you want to ensure the uniqueness of the combined value of multiple columns, you can adapt this post to a multi-columns case.

[Ekkapong14]

thanks for your post. I'll look into your post to find out how I achieve the uniqueness of 2 columns without setting them as a key.

[TeeSee1 · Accepted solution]

I forgot to attach the link to the second post

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-Prevent-Duplicate-Records/m-p/322114#M203...

You can also search "AppSheet avoid duplicates".