I am trying to follow this thread in order to add/edit items by scanning their barcodes. However when scanning, the app returns "'Key field 'Unique Key' is required', what could be the issue?"
I'm using the Inventory Management template. I'm a total newb to appsheets but I've been struggling with this for many hours now. Please help!
Action formula:
IF (ISNOTBLANK(LOOKUP([_THISROW].[Item ID], "Items", "Item ID", "Unique Key")),
LINKTOROW(LOOKUP([_THISROW].[Item ID], "Items", "Item ID", "Unique Key"), "Items_Form"),
LINKTOFORM("Items_Form", "Item ID", [_THISROW].[Item ID])
)
More details:
In the "Unique Key" column's Initial value field, put this: UNIQUEID()
Sorry, forgot to add that screenshot, I have already done this.
Did you try changing the the Field Type of the Unique Key to 'Text' instead of the current field type 'number'?
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |