One question: I have one table with a number ...

data
(Peter Westin) #1

One question: I have one table with a number of records created. All have a unique article no. The I would like to create a table where I assign a status of the article. I’ll do this by scanning the qr-code placed on the physical article, and I have made a ref to the first column of articels. But then, If I like to scan the qr-code again, and show the record and change the status it does not work. The app says “there is already a key created” or something like that.

any clues?

(Tony Fader) #2

@Peter_Westin Your second table needs a unique key, too. Try using a timestamp or a UNIQUEID() value for your key.

https://help.appsheet.com/data/columns/what-is-a-key